Universe multi parameter only passing 1 value in Crystal

[goofaholix]

We have a Universe where parameters have been defined, for example;

eqa_qa.dbo.PROVIDER_STATUS.provider_status_desc in (@Prompt('Select the provider status(s) required','a','Lov Status\Provider Status Desc [LOV]','multi',))

When I add it to the query the following is added to the where statement;

WHERE ( eqa_qa.dbo.PROVIDER_STATUS.provider_status_desc in ('{?Query1_Prompt0}') )

In Crystal I define the parameter as multi.

What happens however is when I select, one value the report selects the data for that ok, when I select nmore than one it returns no values

I've proven it has passed all values with this formula join({?Parameter},', ') so assume it's puttting brackets around the whole array or something, IN ('Value1,Value2') rather than IN ('Value1','Value2')

Any idea what is going wrong?

Thanks.

bruce

 

[Turkbear]

Hi,
Try manually removing the 's around the {?Query1_Prompt0} in the where clause...:

WHERE ( eqa_qa.dbo.PROVIDER_STATUS.provider_status_desc in ({?Query1_Prompt0}) )


Not sure where they are coming from but they do not look right..





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