I have a report, in which I calculate starting date via Formula Fields. Then I need to pass calculated value into a sub-report, where I can use it as one of the parameters for the stored procedure in my database.
The problem is that for some reason the 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"))
The 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 the 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.