blog community

Welcome to blog community Sign in | Join | Help
in Search

Raimond Brookman

Architecture and .NET Development

SQL Reporting Services Parameter Definition Error

Another (see also my previous post) error I often run into with SQL Reporting Services:

An error occurred during local report processing.
The definition of the report '/ABC' is invalid.
The report parameter 'X' has a DefaultValue or a ValidValue that depends on the report parameter "Y". Forward dependencies are not valid.

This simply means that in your reportparameters, Y should be declared before X.

How to do this:

  1. Go to the Layout tab
  2. Select the Report object in the properties window
  3. Go to the ReportParameters property and edit
  4. Move Y above X using the arrows
Published Wednesday, August 09, 2006 9:51 AM by Raimondb

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

byron said:

Thanks.  Very helpful.

September 7, 2006 9:28 PM
 

eric said:

what if X and Y are the same?

November 16, 2006 4:55 AM
 

eric said:

got it, the parameter default values need to be from a different data set then the query itself

November 16, 2006 6:25 AM
 

iggydarsa at gmail dot com said:

My query is:

SELECT     HumanResources.vEmployee.LastName, HumanResources.vEmployee.JobTitle, HumanResources.vEmployee.CountryRegionName,

                     HumanResources.Employee.HireDate

FROM         HumanResources.Employee INNER JOIN

                     HumanResources.vEmployee ON HumanResources.Employee.EmployeeID = HumanResources.vEmployee.EmployeeID

WHERE     (HumanResources.vEmployee.JobTitle IN (@JobTitles))

Basically I want to see a dropdown box with the list of JobTitles so I can filter based on the selected values. So what i did was, in  "Report Parameters" I checked "Multi-value" and under Available Values I chose JobTitle.... but I am still having the same error,,,, does anyone know what i have to do?

November 24, 2006 10:30 PM
 

Santosh Mahajan said:

Was very useful...

Simple + concise answer ...

Thanks

December 8, 2006 7:59 AM
 

pedro abrahan said:

nice was useful ty

March 21, 2007 4:33 PM
 

iggydarsa said:

I have the same problem of iggydarsa someone can ahelp me?

April 11, 2007 6:37 PM
 

Ryan said:

Thank you very much.  You just saved me a lot of time and effort! :)

June 8, 2007 3:48 PM
 

JoelB said:

Thanks!  Just what I needed!

July 27, 2007 3:28 AM
 

thanku said:

your answer really helped me

October 30, 2007 2:37 PM
 

Mister said:

Excelente!!

April 14, 2008 7:22 PM
 

Marcos said:

Definitely helpful. Thanks.

August 6, 2008 4:30 PM
 

essgee said:

Perfect, thanks!

August 19, 2008 9:26 PM

Leave a Comment

(required) 
(optional)
(required) 
Submit

This Blog

Syndication

News

Subscribe in NewsGator Online

Subscribe in Bloglines

Add to Google


 Visitors since June 2005




Powered by Community Server, by Telligent Systems