2008 SSRS Filter

Posted on 2011-05-09
Last Modified: 2012-05-11
I  create a report on SSRS 2008, and I am tring to use Multi Value filter to select produst name or supplier name. I can select Null because there is no Null option on the drop down list!!!
sometimes I dont have a supplier naem or product name and when I select all it gave me everything in the parameter string but not the Null value.

Question by:DBA2010
    LVL 22

    Expert Comment

    by:Nico Bontenbal
    Please check my example in this question:
    It is bit different but you can use the same technique. You can add an 'empty' value to your list instead of the 'indifferent' value I added in this example. Then in your query you can use the
    or 0 in (@Project)

    Open in new window

    trick to show the records without a product/supplier.

    Author Comment

    its a filter not a parameter
    LVL 22

    Expert Comment

    by:Nico Bontenbal
    Sorry. That's a Dataset or Tablix filter then I suppose?

    Could you use an expression like this on your filter:

    Open in new window

    This would return 0 if the Customerid is null. Now you can use operator = and Value 0.
    If you have Customers with id 0 in the database you could use -1 (or any other value not in your database) instead of 0 in the expression and the value.

    Author Comment

    Actully what I did.
    update the Supplier data set select statment
    Union '' from supplier
    and now I have '' value in the parameter drop menu.


    Do you have an idea if we can create an alert message when we run the report  to check like if the start date < End date

    LVL 22

    Accepted Solution

    <<and now I have '' value in the parameter drop menu.>>
    So it was a parameter, not a filter?

    <<Do you have an idea if we can create an alert message when we run the report  to check like if the start date < End date>>
    Yes, but since your original question got answered you should close this one an add a new one. This makes the information easier to find for anyone who is trying to find a specific solution.
    But in this other question I would then answer you that you can add a text box with the warning message to your report (for example with a large red font). Then you set the visible property of this text box to something like
    Start date >= End date
    And the visible property of your tablix/table you set to
    Start date <= End date
    You can find other techniques when you search on google for:
    "parameter validation" ssrs
    (Including the quotes)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
    How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

    737 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

    16 Experts available now in Live!

    Get 1:1 Help Now