report created in older version, imported to 11.04, error in SQL
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
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
This discussion has been closed.
Comments
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
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
I will see what I can do. My manager may not permit it, as we're on the
verge of going to beta....
--
Bill
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
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
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
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