parameter

[Paul1981]

Hi,

I have a gender field, and have created a parameter where the user enters "male" or "female".

Is there a way to have a drop down box from this field? and allow the user to select "male", "female" or "either". Of course "either" returning both.

 

[Madawc]

Right-click on the parameter, edit, default values. You can put as many as you like and they will be shown at parameter selection.

It helps to give your Crystal version, but this function is the same for 8.5 and 10, probably for other versions also.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[Paul1981]

Thanks

Sorry, Its version XI, but that works.

Bu how do I now associate "either" to find all records?

 

[Turkbear]

Hi,
In your record selection formula use something like:

If {?param} = 'either'
 then
True
else 
If {?param} = 'male' 
then
{table.genderfield} = 'M' else
if {?param} = 'female' 
then
{table.genderfield} = 'F'

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Paul1981]

Hi,

Thank you, that works a treat. I will try and give more info next time

My next challenge is to have one bar chart, where the axes are variable. IE the user selects the two data fields to show the results they require.... not even sure its possible.