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!

Parameter Base Report Title

Status
Not open for further replies.

fhurmuzlu

Programmer
Nov 16, 2004
52
US
I have formula Called "Dist"


if{Command.District} = "NE" then "Northeast" else
if {Command.District} = "AK" then "Alaska" else
if {Command.District} = "SE" then "Southeast" else
if {Command.District} = "SW" then "Southwest" else
if {Command.District} = "NW" then "Northwest"

I want to create a Parameter Called "District" that work with the formula above when the user enter like dstrict " NE , AK, SE , SW, NW" it shows in report Title.
 
In the report title on the report itself? Or somewhere else?

For the report title on the report try this:

It won't necessarily work with the same formula, but you could use a similar one. It will look something like this:

If {?District} = "NE" then "Northeast" else
Ir {?District} = "AK" then "Alaska" else ....

At the top of your report, place a text box and format it so that the font is what you use for your title. Place the Report Title object inside this text box, type a space after the report title object, then drag the formula you just created into the text box and place it after the space.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.
 
Are you saying you want the abbreviations replaced by the names in the report title? Are you planning to allow multiple locations to be selected (moved individually to the right)? Or is there some reason you would be asking users to enter multiple values as one string?

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top