Home » SQL Reporting Services Parameter Definition Error

  • SQL Reporting Services Parameter Definition Error

    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

    Share this

19 comments

  1. Thanks. Very helpful.

    byron

  2. what if X and Y are the same?

    eric

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

    eric

  4. 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?

    iggydarsa at gmail dot com

  5. Was very useful…
    Simple + concise answer …
    Thanks

    Santosh Mahajan

  6. nice was useful ty

    pedro abrahan

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

    iggydarsa

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

    Ryan

  9. Thanks! Just what I needed!

    JoelB

  10. your answer really helped me

    thanku

  11. Excelente!!

    Mister

  12. Definitely helpful. Thanks.

    Marcos

  13. Perfect, thanks!

    essgee

  14. very helpful, thanks !

    Goran D

  15. Thank you.

    Gil

  16. This didn’t help at all.
    I have the second parameter based on a query of data – completely different from the first parameter which is based on non-query values. Is there any other solution?

    Keith H.

  17. Thanks, very helpful.

    Joaquin

  18. Hi,
    If you same problem error. you can use the another data set (Ex:field name: accountname, accountid)
    assign the values to the first data set parameter which you created inside the parameter.

    Open the parameter tab go for text datatype — choose the multiple allow option.keep as visible button and click for available option .. inside the available option select the get the values from a query — select Dataset2
    Value field: accountname,label feild:accountname..ok.

    you get the parameter as all the account names …

    Gengiti.Sainathyadav

  19. thanks a lot for your help

    Amruta

Comments are closed.