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

Reference static parameter description in formula?

Status
Not open for further replies.

TomRand

MIS
Oct 23, 2001
1
US
Crystal 11, Release 2. Is there a way to reference the static parameter description field in a formula?
Parameter Description
DEPUTY/SWORN/FT Full Time Position
JAIL/SWORN/FT Full Time Position
TRANSP/JAIL/FT Full Time Position
CLERK/SWORN/FT Full Time Position
DEPUTY/SWORN/PT Part Time Position
JAIL/SWORN/PT Part Time Position

The description will determine the wording of the output. I know I could use the last 2 characters of the parameter, but there should be a means to reference the description.

Thanks,
Tom
 
There isn't really. You can hard code it in a formula or if it is a field in a table, you can insert a subreport that uses the parameter value for selection and then display the description field. If this is a single value parameter, then you could just use:

if right({?Parm},2) = "FT" then
"Full-time Position" else
if right({?Parm},2) = "PT" then
"Part-time Position"

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top