SQL Reporting Services - Report Builder

Posted on 2009-04-15
Medium Priority
Last Modified: 2012-05-06

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.

Question by:pnadakuditi
  • 2
LVL 15

Accepted Solution

Faiga Diegel earned 1500 total points
ID: 24152558
set in in an expresion, something like:

Admissions with All of (Diagnosis in " & parameters!yourdiagnosisobjectname.value & " Discharge on or after " &Parameters!Yourdateobjectname.Value

Author Comment

ID: 24159223
faiga16, thanks for getting back to me.

I'm not sure how to set the expression. When I look at the filter formulae for Diagnosis and Discharge fields, this is how the expressions look like...

For Diagnosis field -    IN(Diagnosis, Parameter: Diagnosis)
for Discharge field -    Discharge Date >= Parameter: Discharge Date

Can you please let me know how to edit these expressions to achieve the above functionality. (I'm using Report Builder 2005).

Author Comment

ID: 24161425

the solution you proposed worked really well for the Discharge date field. I added a text box in the report and added the below expression,
= "Discharge Date from " & Parameters!DischargeDate.Value
However, for the Diagnosis prompt (which allows users to select values from a list), I have added another text box with the below expression and it doesn't work.
= "Diagnosis in " & Parameters!Diagnosis.Value

Please let me know if we have to change the expression for prompt fileds which allows values to be selected from a list. Thanks for your help.

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
Integration Management Part 2
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question