Home Forums Reporting Services Reporting Services SSRS 2012 parameter selection issue RE: SSRS 2012 parameter selection issue

  • April 24, 2018 at 2:47 pm

    #1988124

    wendy elizabeth - Tuesday, April 24, 2018 1:46 PM

    In a production ssrs 2012, there is an option to select students at the school system based upon several parameters
    that are cascading parameters prior to the student selection parameter. Basically the idea is there will be several students to select from.
    However I found a way to run the report where there are no students to select from. When this occurs, the student parameter is a blank box. There is nothing for the user to select from.
    Instead of having a 'blank' parameter box, is there a way to say something like there are no students to select from? If so, can you show me how to accomplish this goal? If this is not possible, would you tell me that also?

    You would have to be able to derive the list of students in a query that used the previous parameter or parameters to generate the list, and if you get no resulting students, you add in a row that says something along the lines of No Students meet the criteria specified, and the value to be supplied to the report is some oddball value that could never result in selecting any records.  Would that work for you?

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)