Crystal Report Date Range Parameters

jspc
jspc used Ask the Experts™
on
Hello, I have a crystal report with a transaction date range. When I run the report a date range is asked.
How do I get the selected ‘date range’ to appear at the top of the report?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solution Only
Commented:
You can use formulas.  If the parameter only allows a single range, you can use Minimum ({?your date range parameter}) and Maximum ({?your date range parameter}) to display the range values.  You could put those functions in separate formulas, or convert the dates to strings and combine them in a single formula.  For example:

"Date Range: " + CStr (Minimum ({?your date range parameter}), "MM/dd/yyyy") + " to " +
 CStr (Maximum ({?your date range parameter}), "MM/dd/yyyy")

Open in new window


 If you'd like the date in a different format, look up CStr in the CR Help for info on the different format strings.

 James
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
That looks good.

mlmcc

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial