Jun 21, 2016 07:06 PM|Jon11sin|LINK
Currently I have a dropdownlist where a user can select one unique id. On the same page I have a reportviewer. I created a rdlc with multidatasets and one parameter. This parameter is assigned based on the unique id selected in the dropdownlist. I am
able to display results correctly.
I have added a check box labeled "All", when this checkbox is checked, I iterate through all the values in the dropdownlist and assign those values to the Report parameter. This is the same report parameter used when selected just one value from the dropdownlist.
I have assigned the multivalues in the dropdownlist to a list and added this list to the List<ReportParameters> lsrptparams = new List<ReportParameters>();
I have assigned these values to a hidden Label on the page just to confirm I am getting the correct values in the correct format(1,2,3,4,5). But I don't get no results in the ReportViewer. I have set a textbox in the ReportViewer with the expression "=Join(Parameters!Field.Value)
and I can see those values but I don't get the results. I am using a stored proc with a Where clause (Where field IN (@unique).
My end result is when a user checks the Checkbox...get the same report based on the different multivalues. So if there are 5 values within the multvalue parameter there should be 5 pages within the report for the results of the 5 different multivalues.
Any information is appreciated.