More Dates

[EscapeUK]

I would like the user to select a parameter value, Day, Week Month.

I would then like a table searched depending on that date

eg

if the select weekly all the records from the last week are shown or if they select month all the records from the last month are shown.

 

[kenhamady]

if using version 7 or 8, create a Character Parameter with three default values:
Day, week, month and then prevent them from modifying the defaults (this is a check box in the parameter options.


Then your record selection formula would be:

If {?param} = "Month"
then {date} in LastFullMonth
else

If {?param} = "Week"
then {date} in LastFullWeek
else

(you didn't say what the day criteria was but it would go here)

If there are other criteria in the selection formula, put this series in a single set of parentheses.

Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[EscapeUK]

thanks but how do I get the full weeks records

e.g

if they enter a date and select weekly how do I get the start and end date of that week