Passing a formula field value into a Crystal Reports command
- by DarkDeny
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...