Home Datapipelines
New Blog Posts: Merging Reports - Part 1 and Part 2

report created in older version, imported to 11.04, error in SQL

edited November 2009 in Datapipelines
I have a report which was created in an older version of RB (I do not
have the version info at hand) and imported into 11.04. Looking at the
SQL for the imported report, it is quite different to that in the older
designer. The critical difference, however, is that the WHERE clause is
incorrect in two ways. First, it omits some fields which were tested in
the original, and second, the beginning of the WHERE clause looks like
this:

WHERE AND (

The contents in the parentheses are fine, it's the WHERE AND which is a
problem.

Thanks,

--

Bill

Comments

  • edited November 2009
    Hi Bill,

    My first suggestion is to upgrade your verstion to RB 11.06 and test with
    that. Contact info@digital-metaphors.com for upgrade instructions. If this
    does not solve the problem, please send a simple example demonstrating this
    behavior in .zip format to support@digital-metaphors.com and I'll take a
    look at it for you.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited November 2009
    Nico Cizik (Digital Metaphors) wrote:


    I will see what I can do. My manager may not permit it, as we're on the
    verge of going to beta....

    --

    Bill
  • edited November 2009
    Nico Cizik (Digital Metaphors) wrote:


    Nico,

    I am told that before I was assigned to be the support in our group
    for ReportBuilder operations, they had tried 11.06, to see whether it
    resolved any of the existing problems. I'm told it did not, and that it
    introduced some issues of concern, though I have not been told
    specifically what those were.

    That being the case, I am very concerned with the malformed SQL I
    see, and all the more because I am told that 11.06 did not resolve it.
    The pathologies I have seen are the WHERE AND I mentioned before, and
    also WHERE ORDER BY, and finally, empty WHERE clauses. Also, in one
    case, some filter conditions were omitted that had been in the original
    report.

    If it will be of any benefit, I can collect the original SQL and the
    11.04 SQL, for the same reports, and pass them to you.

    --

    Bill
  • edited November 2009
    Hi Bill,

    This would be a much easier issue to track down if we were able to see it in
    action. If possible please send a simple working example application I can
    run on my machine that demonstrates the issue. Send the example in .zip
    format to support@digital-metaphors.com.

    Note that if an issue is found, we will only be able to fix it for the
    latest version of ReportBuilder (11.06). If you (or others) are having
    issues with the latest version, please relay them to us and we will see what
    we can do to resolve them. There are not very many changes between minor
    releases so these issues shouldn't be too dificult to track down.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited November 2009
    Nico Cizik (Digital Metaphors) wrote:


    Nico,

    I understand. At this moment, being less than two weeks from a beta
    release, I have no time whatever to produce a sample app. Nor do I have
    any real confidence in being able to reproduce these issues. Still, at
    least with respect to the SQL WHERE clause, I will give it my best
    effort, when time (and management) may permit.

    I understand, too, that you will not apply fixes to earlier releases.
    Since I have not had the opportunity myself to observe the issues I
    have been told were raised by 11.06, I can offer nothing concrete at
    this time. Later, I hope that will change.

    --

    Bill
This discussion has been closed.