May 14, 2010 at 8:25 pm
Hello Experts
I have a SSRS report designed on SSAS Cube, which is deployed and working fine.
I have built a asp.net application and configured this with the SSRS report, such that the values I select in asp.net page will be passed to the parameters of the ReportServer and so I get the Report displayed using reportviewer control.
Everything is working fine when a single value is selected for a multi value parameter but, When I selected multiple values, it throws an error saying, "Parameter Country is missing a value".
To avoid the error I tried the following different ways, but not all at a time.
1. Wrapped up the selected values with '{' and '}' in the asp.net code
2. Added a ',' to differentiate the mutliple values
3. In SSRS, a used "=Split(Parameters!Country.Value)"
4. Removed the multi value property for the report parameter in SSRS, so that if the selected values are passed like '{[Country].[Country].&[UK], [Country].[Country].&[USA]}', that might treat the whole stuff as a single value.
Please help me out, in fixing this. Let me know, if you need further information.
Thanks
May 25, 2011 at 1:27 am
Can you tell me the way you have used to pass parameter value to SSRS ?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply