Calc Field SQL alias not allowed to be defined by me in ReportBuilder 10?!
We are moving from Delphi 4 to Delphi 2007 so we have replaced
ReportBuilder Professional 5.0 for Delphi 4 with
ReportBuilder Enterprise 10.07 for Delphi 2007.
In all of our existing report designs whenever we defined a Calculated
field we gave it an alias name in the expression like:
(CASE HATempHistory.Type WHEN 'J' THEN HATempHistory.EndDate WHEN 'D' THEN
HATempHistory.EndDate2 END) AS calcEndDate
but now with RBuilder 10 whenever I open our reports RB tells me that
there is an error in my SQL where the calc fields are.
As I understand well this is due to a change in RBuilder that the user is
now not allowed to define an Alias name in the Expression of the Calc
field because RBuilder will allocate one to make sure it's unique.
The only way I could fix my report was to take off the alias names from
the expression of my Calc fields(in the above example I had to remove "AS
calcEndDate"). After I've done this, my report works perfectly, no problem
at all.
My problem with this though is that I have to go through 500+ reports and
change them one by one and ask all of our customers who designed their own
reports to send in all of their reports(1000+) to us and we have to fix
them manually!? This would cost us a fortune in time and money...
So if anyone knows a solution, for example how to switch this "auto
allocation of the SQL field aliases" feature off in RBuilder or has a
converter which does the trick and changes the report file, please help me.
Thanks everybody in advance,
Zoltan.
--- posted by geoForum on http://delphi.newswhat.com
ReportBuilder Professional 5.0 for Delphi 4 with
ReportBuilder Enterprise 10.07 for Delphi 2007.
In all of our existing report designs whenever we defined a Calculated
field we gave it an alias name in the expression like:
(CASE HATempHistory.Type WHEN 'J' THEN HATempHistory.EndDate WHEN 'D' THEN
HATempHistory.EndDate2 END) AS calcEndDate
but now with RBuilder 10 whenever I open our reports RB tells me that
there is an error in my SQL where the calc fields are.
As I understand well this is due to a change in RBuilder that the user is
now not allowed to define an Alias name in the Expression of the Calc
field because RBuilder will allocate one to make sure it's unique.
The only way I could fix my report was to take off the alias names from
the expression of my Calc fields(in the above example I had to remove "AS
calcEndDate"). After I've done this, my report works perfectly, no problem
at all.
My problem with this though is that I have to go through 500+ reports and
change them one by one and ask all of our customers who designed their own
reports to send in all of their reports(1000+) to us and we have to fix
them manually!? This would cost us a fortune in time and money...
So if anyone knows a solution, for example how to switch this "auto
allocation of the SQL field aliases" feature off in RBuilder or has a
converter which does the trick and changes the report file, please help me.
Thanks everybody in advance,
Zoltan.
--- posted by geoForum on http://delphi.newswhat.com
This discussion has been closed.
Comments
Can you try using RB 5 to create an example that uses the DBDemos or
Interbase Employee data. Create a Delphi project with a single report. Then
zip it up and email to support@digital-metaphors.com. We can run the example
using RB 10.07 and take a look at it.
We have conversion logic in place for old reports, from a quick of review of
our conversion code, I did not spot anything that is looking for old calc
field aliases.
--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com