"xxx" parameter value is missing when trying to pass a parameter that is 'hidden' in reporting services

• tebalsamo

  Old Hand

  Points: 378

  More actions

  December 21, 2009 at 6:53 am

  #207658

  I have a very simple report that defines a shipdate as a datetime value so I can use the calendar functionality in SSRS2005. The user can choose the date, which then gets passed to a hidden parameter which has a sql back end that returns an mdx value to be used by the cube. When I uncheck the 'hide' button on the second parameter, the report runs fine. When I hide this parameter I get the error the "xxxx" parameter is missing a value.

• only4mithunc

  SSCrazy Eights

  Points: 8434

  More actions

  December 21, 2009 at 7:02 am

  #1094727

  Hi,

  When you keep it as hide, try passing some default value (either use From query or Non-queried option).

  Regards,

  MC

  Thanks & Regards,
  MC