Pass multiple values to parameter

Question

Hello I've a crystal report which is using table adapter from dataset to fill data. I also have a parameter with type string and option as allow multiple values. Can anyone please explain how I can pass multiple values from array to this parameter so that I will get desired result. I have countryParameter as parameter for field country. I want to display output only for USA and UK on report. USA and UK are stored in one array. In case of single parameter I can use it easily as rep.SetParameterValue(countryParameter USA); but not sure for multiple values. Thanks Rahul.

Rahul Sharma · Answer

And yes I'm using strongly typed data set. I am using VS2005

Rahul Sharma · Answer

I have achieved it almost. But not sure what is the reason I am not able to suppress prompt to enter value in Crystal report. public void createReport() { countrysrpt rep = new countrysrpt(); ParameterFields myParams = new ParameterFields(); ParameterField myParam = new ParameterField(); dscountry ds = new dscountry(); searchCountryTableAdapter adp = new searchCountryTableAdapter(); adp.Fill(ds.searchCountry); rep.SetDataSource(ds); myParam.ParameterFieldName = countryParameter; ParameterDiscreteValue pdv = new ParameterDiscreteValue(); pdv.Value = USA; myParam.CurrentValues.Add(pdv); pdv = new ParameterDiscreteValue(); pdv.Value = IND; myParam.CurrentValues.Add(pdv); myParams.Add(myParam); crv_country.ParameterFieldInfo = myParams; crv_country.ReportSource = rep; }

Manish Kumar Choudhary · Answer

create strongly type dataSet.

Rahul Sharma · Answer

It is not working. I am using dataset and tableadapter.

Manish Kumar Choudhary · Answer

Hi Rahul Sharma  Go through following links it will help you http://imar.spaanjaars.com/310/passing-multiple-parameters-to-a-crystal-report-programmatically http://www.codeproject.com/Questions/272046/How-to-pass-multipal-Parameter-Value-to-crystal-re http://scn.sap.com/thread/1951788