Link to home
Start Free TrialLog in
Avatar of UniqueData
UniqueDataFlag for United States of America

asked on

Combo box functionality in Reporting Services

I have an input parameter who's source is based off a stored proceedure.  In the parameter section of the report a combo box displays the text but passes the selected ID, no problem there.  I added the stored procedure as a data source for the report (I called the source RegionCombo which has a union select added item 0,'<Show All>').  However, on the Report itself I want the selected parameter printed on the header, but obviously I want the text, not the ID number.  In Access I just add a combo box to the report and hide column 0.  How do I pull this off in Reporting Services.
ASKER CERTIFIED SOLUTION
Avatar of simon_kirk
simon_kirk
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of UniqueData

ASKER

Awesome.

Thank you.