Using one parameter to select multiple values

[kwood1985]

I need some help in how I can get my current report generating correctly.

I need my report to display particular data stored in the database under a particular location, and the parameter I would use is based on that locations number, so in this case, the locationtype column = 21, which is for the location of Hertfordshire storage.

So when the parameter is used it will select any column data that had the locationtype of 21. But for my case the location of Hertfordshire storage as been added 4 times under four different locationtype numbers, so what I am trying to do is, when the parameter is selected, it displays all data related to those four locationtypes.

Hope this makes sense. Any help and advice will be greatly appreciated.

 

[fisheromacse]

I do not have crystal in front of me right now, but you would use something like this in your selection criteria (sorry for any typos/errors):

If YOURPARAMETER = '21' then locationtype in ('1','2','3','4')
else locationtype = YOURPARAMETER

 

[kwood1985]

Thank you for your response.

I have tried this but I am getting an issue where it is saying it is missing a ')' after the first number in the 'in()' section. I have tried with '', "" and none, but still states the same issue.

I think what might be the easiest way is to create the parameter as a multi value parameter so the user can select each locationtype

 

[kray4660]

You need to use square brackets ([]). If you spend any time with SQL they use parenthesis, easy to forget.

 

[kwood1985]

Yes, thank you...it is easy to forget lol...well for me anyway.