Convert String Value to Function?

[rhinok]

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?

 

[kenhamady]

I think the nested if then is the only way. Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.

 

[MalcolmW]

You have more options with v8.5, but you are stuck with nested ifs with v8 and lower. Malcolm Wynden
I'm for sale at

http://wynden.net

malcolm@wynden.net