Date Parameter Using LastFullWeek OR Date Range 1

[jwrjwr54]

Afternoon all

Using Crystal XI Professional. I’m trying to create a date parameter that has the following options:

1 – LastFullWeek
2 – LastFullMonth
3 – Specify the Date Range

Some of my users would like to schedule the report and need the LFW and LFM options. Other users would like to select the data range. Can you have both in the same parameter?

If {?Date Parameter} = 1 then LastFullWeek else
If {?Date Parameter} = 2 then LastFullMonth else
??

 

[lbass]

You would have to add a parameter {?RangeType} with string options of: "Last Full Month", "Last Full Week", or "Specified Range". Then create a date range parameter {?DateRange} which allows range values. Then set up your record selection formula like this:

(
select {?RangeType}
case "Last Full Month" : {table.date} in lastfullmonth
case "Last Full Week" : {Table.date} in lastfullweek
case "Specified Range" : {table.date} = {?DateRange}
)

-LB

 

[jwrjwr54]

Very cool - thanks for your help

FedEx