Post reply

How to restrict user to select only few values in multi valued parameter

  • December 2, 2015 at 3:06 am

    #322717

    Hi, In SSRS Report we have multi valued parameters. Now if user select all values (Not the SELECT ALL option but all the values coming from database in parameter)in parameter the the SSRS is throwing error after clicking on View Report button.

    I searched in google and the error is related to the length of the sql query which ssrs is trying to send to sql database. SInce the length of query is more then the specified limit, we are getting the error message.

    Is there any way we can restrict user to select only few number of values from each multi valued parameter. For example, I want user to select max 10 values from a multi valued parameter. If he try to select more than 10 then he should not able to select or he should get a message.

    Thanks in advance for any help.

  • December 2, 2015 at 8:28 am

    #1843515

    in cases like this, i suggest not working around the error, but addressing the error head on: huge query that exceeds 4K or whatever.

    instead of having the report pass a huge query, move the query into a stored procedure, and have the procedure receive the parameters.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • December 2, 2015 at 7:30 pm

    #1843672

    I've seen this issue when the report itself dumps tons of possible values for the parameter. Can the values be grouped somehow and chosen through a cascading relationship between the attributes? Ex//country = U.S. > 50 states > california > counties> zip codes <-- where this list is more manageable within one county .

    ----------------------------------------------------

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply