SQL Reporting Services - Report Builder

Posted on 2009-04-15
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
    LVL 15

    Accepted Solution

    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

    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


    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

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Suggested Solutions

    How to increase the row limit in Jasper Server.
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    729 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

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now