Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Displaying a Date Parameter in a report title??? 1

Status
Not open for further replies.

gbiv

Technical User
Nov 21, 2002
13
US
My report prompts for a date range, and I want to put that date range into the Title of my report. I cannot figure out how to display the Date Parameter that was entered. Any ideas?

Thanks
 
Hello,
From the parameter list window drag and drop the parameter you want to display on the title. When you right click on the parameter you can select format and use the exact type you want.

 
Use a formula such as:
-----------------------------------------------
"From: " + ToText ( Minimum ( {?Your_Date_Param} ) ) + " To: " + ToText ( Maximum ( {?Your_Date_Param} ) )
-----------------------------------------------

Cheers,
- Ido
CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
 
aproddut,

Your method will only work for dicrete value parameters. It will not display range parameters. It will display only the first parameter if there are multiple discrete values entered, but only if the parameter is not set up to accept ranges.




Mike
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top