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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Printing date ranges as report title 1

Status
Not open for further replies.

jercisneros

Technical User
Jun 3, 2002
38
US
I have created a parameter "{?Date Range}" and I want to display this field as a report title. The parameter is set to Allow multiple values and Discrete and Range values. I have created a formula like:

"Date Range: " + ToText({?Date Range}[1]) " to " + ToText({?Date Range}[2])

Then I get a message that says "The remaining text does not appear to be part of the formula" and the cursor stops in be between the first paranthesis and curly bracket.

Using CR.8

Any help would be greatly appreciated.
 
You are close. First change your parameter to a range value only, no multiple values. Then try this formula:

"Date Range: " + ToText(Minimum({?Date Range})) " to " + ToText(Maximum({?Date Range}))
Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top