Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 254
  • Last Modified:

Crystal Report Date Range Parameters

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?
0
jspc
Asked:
jspc
1 Solution
 
James0628Commented:
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
0
 
mlmccCommented:
That looks good.

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now