I have a created an SSRS report in 2005 version and it has a one multi-valued parameter and has a default value which is a query based value. The values in the parameter are like USA, Canada, India, Sing...
I would like to create a linked report for the above mentioned report and wound need to pass only two hard coded values (USA, Sing). But when I go to the report parameters of the linked report, it was showing 'Query Based' at the 'default value' section.
I need to pass hard coded values to the linked report.
Can any one please suggest how i can create a linked report with static values in the query based parameter?
Any help would be greatly appreciated.