ParameterRR in filter

[Ann_E_(Guest)]

I^ve created an "as of" date ParameteRR field in v10+ and now want to incorporate it into the filter of a report generated via wizard (in an older version of R&R). The ParameteRR field does not appear in the field drop-down list. Is this possible to do?

[kfleming]

Is this the designer or runtime?____Kathleen__R&R Support

[Ann_E_(Guest)]

I^m working in the designer right now to set up the report, but want the user to be prompted for a value for the "as of" date during runtime.____Ann

[kfleming]

If the parameteRR field is used in the filter and prompt at runtime is checked, then that parameteRR should display when the report is excuted.____Kathleen__R&R Support

[Ann_E_(Guest)]

The as of date wasn^t appearing in the "compared to" field list in the filter. I changed the first date field after "and/or" to a calculated date field instead of using the table field directly and then the as of date appeared in the compared to field list. That works now. __Thanks, Ann

[kfleming]

If the table field was date/time and the parameteRR field was a date, then it would not appear in the comparison list due to the data type difference.____Kathleen__R&R Support