Error entering calcultated fields
Since upgrading to version 11.04 from version 10 the length of formula that
can be entered in the Function Field on the Calcs tab of the Query Designer
has reduced. More characters can be entered, but if you do the SQL
generated is truncated and therefore invalid
For example one of our customers had a report where they had entered the
value:
cast(floor(cast(wodFinishDate as float)) as datetime)
After the upgrade this would not run. The section of SQL produced was:
cast(floor(cast(wodFinishDate as float)) cast_floor_cast_wodFinish
The function seems to be cut off at 40 characters.
Regards
Mike Bennett
can be entered in the Function Field on the Calcs tab of the Query Designer
has reduced. More characters can be entered, but if you do the SQL
generated is truncated and therefore invalid
For example one of our customers had a report where they had entered the
value:
cast(floor(cast(wodFinishDate as float)) as datetime)
After the upgrade this would not run. The section of SQL produced was:
cast(floor(cast(wodFinishDate as float)) cast_floor_cast_wodFinish
The function seems to be cut off at 40 characters.
Regards
Mike Bennett
This discussion has been closed.
Comments
In my testing with RB 11.07, I was able to enter the exact function you have
below as a Calc field and the entire call was generated as SQL. Perhaps try
updating your version of ReportBuilder and see if that solves the issue.
Contact info@digital-metaphors.com for upgrade instructions.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com