Using Crystal Reports 11
I am hoping there is a better way of running a seven day report that i have to run weekly
In the report i have it set when refreshing the document, the "Prompt for new parameter values" comes up and there is a date field for start and end
This is how i did it
I made a formula called "Date" this comes from the closed date of our accounts
I made a Parameter Field "Start Date" with the TYPE field is "Date"
I made a Parameter Field "End Date" with the TYPE field is "Date"
I made a Select Expert Using data from the "ClosedDate" in the first drop down I picked "Formula" and used this as the formula
{WH_ACCTCOMMON.CLOSEDATE} in {?Start Date} to {?End Date}
Two things
1. Is there a way to have "Prompt for new parameters values" as the default checked off box when clicking "Refresh"?
2. Is there a way to only enter a start date and the refresh would just run 7 days without entering a end date?