SSRS parameter error sporadi

Posted on 2011-04-27
Last Modified: 2012-05-11
I have a report which group by data based a few parameters. Sporadically the report will give an error when loading the default values:
•      Default value or value provided for the report parameter 'Parameter1' is not a valid value.
I assume that the above error could be occurring since it is trying to pass a comma separated parameter string into the dataset query which accepts this parameter.
The same query works fine on the backend and there are no null or blank values in the parameter lookup tables. We are running SQL Server 2005.
Question by:JLEmlet
    LVL 21

    Expert Comment

    by:Alpesh Patel
    Please check the parameter datatype and the acceptance of "," in parameter.
    LVL 22

    Expert Comment

    by:Nico Bontenbal
    Does the default value always return a value that is in the list of available values. Suppose the available values are
    select distinct orderdate from orders
    and the default value is
    Then the default value is invalid on the days that don't have orders (yet).
    Could something like this be your problem?

    If this doesn't solve it. Could you copy the .rdl file. Then rename the copy to .xml and upload it here. (.rdl is not an allowed type on EE, xml is)

    Accepted Solution

    We resolved this by rewriting the logic so there were many fewer multi-select variables.  That corrected the issue.

    Author Closing Comment

    We resolved ourselves - see prior post.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error With the introduction of SQL Server 2008 R2 and Vista (Windows 7 as well) came new enhanced security features. One of the features included was User Access Control (UAC) t…
    Introduction As you'll probably know, a data region in a SQL Server Reporting Services report can be linked to only one dataset.  This makes it troublesome when you need to display data from more than one dataset in the same data region.  SQL Serve…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    754 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

    20 Experts available now in Live!

    Get 1:1 Help Now