Convert String Value to Function?
Convert String Value to Function?
(OP)
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?
RE: Convert String Value to Function?
Ken Hamady
http://www.kenhamady.com/
On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.
RE: Convert String Value to Function?
Malcolm Wynden
I'm for sale at http://wynden.net
malcolm@wynden.net