[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Displaying date range in report header of crystal reports

Posted on 2009-12-23
Medium Priority
Last Modified: 2012-05-08
I have a report built in Crystal Reports 11.  I would like to display the minimum and maximum dates in the report header but cannot figure how to do.  Can anyone help?
Question by:OB1Canobie
LVL 13

Expert Comment

ID: 26112546
Create a formula

minimum({datefield} )

and paint it on the report header?
LVL 14

Expert Comment

ID: 26112834
I agree with PCI -

If you want to print something like: Containing information from: 11/30/2009 to 12/06/2009

you would do the following formula:

"Containing information from: " 
& totext({Command.START_DATE}, 'MM/dd/yyyy')
& " to " &
totext({Command.END_DATE}, 'MM/dd/yyyy')
LVL 101

Accepted Solution

mlmcc earned 2000 total points
ID: 26115669
Are you talking about the minimum and maximum dates in the data or in a date parameter range?

For the minimum to maximum date in the data of a particular field.

"Containing information from: " 
& totext({DateField}, 'MM/dd/yyyy')
& " to " &
totext({DateField}, 'MM/dd/yyyy')

For a parameter
"Containing information from: " 
& totext({?DateParam}, 'MM/dd/yyyy')
& " to " &
totext({?DateParam}, 'MM/dd/yyyy')


Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question