Passing a formula field value into a Crystal Reports command
Posted
by DarkDeny
on Stack Overflow
See other posts from Stack Overflow
or by DarkDeny
Published on 2010-06-11T10:17:32Z
Indexed on
2010/06/11
10:23 UTC
Read the original article
Hit count: 253
crystal-reports
Hello eveybody!
I have a report, in which I calculate starting date via Formula Fields. Then I need to pass calculated value into a subreport, where I can use it as one of the parameters for the stored procedure in my database.
The problem is that for some reason value of the corresponding parameter when the database is queried is empty (or null, I am not sure exactly).
What can be wrong in my report template?
The formula I use is: ToText( ShiftDateTime ({@StartDate}, {?TimeZone}, "UTC,0")) Name of this formula field is StartDate I pass it into subreport as a Pm-?@StartDateUTC (also tried Pm-@StartDateUTC). I am sure, that @StartDate has correct value (tested in preview with this field in report), also Pm-?@StartDateUTC does has a value, but when CR is accessing DB - the result is empty field value...
© Stack Overflow or respective owner
