I've created a report in CR7 that will allow the users to determine the date range by which to return data. The pick list values are strings that have the exact same text as the date range functions (LastFullMonth,YearToDate, Etc...). Is there any way to convert the parameter string value to an actual function? For example I'd like to select records as:
{table.datefield} in {?Reporting_Period}
I could always do something like:
If
{?Reporting_Period} = 'LastFullMonth'
Then
LastFullMonth
Else If
(etc ...)
but this doesn't seem very efficient. Any thoughts?
{table.datefield} in {?Reporting_Period}
I could always do something like:
If
{?Reporting_Period} = 'LastFullMonth'
Then
LastFullMonth
Else If
(etc ...)
but this doesn't seem very efficient. Any thoughts?