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!

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

How do I show a range parameter in my report?

Formula Help

How do I show a range parameter in my report?

by  AyJayEL  Posted    (Edited  )
If you have a range paramater it won't display if you drag it into the report. This is how you get it to display for the different types.

Create a formula thus;- (For versions 9 and above I am told you need to substitute Cstr for ToText, I don't use 9 so can't vouch for it!)

For a Date Range

"From: " + ToText (Minimum({?DateRange}))+"To: " + ToText(Maximum({?DateRange}))

Where ?DateRange is your parameter.

For a number range
"From: " + ToText (Minimum({?NumberRange}),0,"")+"To: "
+ ToText(Maximum({?NumberRange}),0,"")

Where ?NumberRange is your parameter

For a String Range
"From: " + Minimum({?StringRange})+
"To: " + Maximum({?StringRange})

Where ?StringRange is your parameter

Then put the formula in your report.
Register to add this FAQ to your archive
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top