Skip to Content
0
Former Member
Jan 11, 2012 at 04:13 PM

A better way to run a 7 day report?

57 Views

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?