SQL Reporting Services - Report Builder
Posted on 2009-04-15
I have created Report Models and I'm trying to generate reports from the models using Report Builder. (I'm using SQL Server 2005). I have created a filter on my report so that the user will be prompted to enter filter criteria and thus filter the results on the report. The filter criteria appears on the generated report like below.
Filter: Admissions with All of (Diagnosis in (prompted), Discharge on or after (prompted)
However, I want my generated report to show the complete filter criteria with all the values I selected for the prompts. For example, I want the filter criteria to look like below.
Filter: Admissions with All of (Diagnosis in (Anemia, Acidosis), Discharge on or after (14/1/2007)
Please let me know if there is a way to achieve this. Many Thanks for your help.