SSRS 2005 Report Manager parameters default values (Query Based)

• yvbchowdary

  Valued Member

  Points: 56

  More actions

  November 19, 2013 at 12:38 pm

  #286440

  Hi,

  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.

  Thank you,

  Venu Babu.