Dan560
asked on
Crystal Reports Date in Parameter
Hi,
I am trying to create a running parameter that will utilise the "is in period"
When a user runs the report I want them to be able select from a drop down menu the options listed in the picture attached.
Can anyone explain how to set the parameter up?
Thanks
example.png
I am trying to create a running parameter that will utilise the "is in period"
When a user runs the report I want them to be able select from a drop down menu the options listed in the picture attached.
Can anyone explain how to set the parameter up?
Thanks
example.png
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
If {?Param} = 'Last7Days' Then
{table.date} >= Today - 7 and {table.date} <= Today
Else If {?Param} = 'MonthToDate' Then
{table.date} > Today - Day(Today) and {table.date} <= Today
Else If .........etc.
HTH