SSRS Parameter from drop down not being passed

Former Member
Former Member $organization

Hi:

 

I have a couple of reports that use a query to populate a drop down box to select a value on which to report on.  I have discovered that when in Tessitura, the parameter from the drop down is not passed to the report, it just appears as <Select a Value> on the report page.  If I then select a value it will then run the report.  Has anyone else seen this and what did you do to fix it?

James

  • Former Member
    Former Member $organization

    I now know the answer to this one! 

    The query to populate the drop downs must only be in the Tessitura Report Setup for the values to work.  The query parameter values are not passed from the SSRS report to Tessitura (they appear but do not work).  Once I figured this out, everything worked great.

     

    James