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

Leave a Reply

19 comments

  1. Thanks. Very helpful.

    byron Reply

  2. what if X and Y are the same?

    eric Reply

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

    eric Reply

  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 Reply

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

    Santosh Mahajan Reply

  6. nice was useful ty

    pedro abrahan Reply

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

    iggydarsa Reply

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

    Ryan Reply

  9. Thanks! Just what I needed!

    JoelB Reply

  10. your answer really helped me

    thanku Reply

  11. Excelente!!

    Mister Reply

  12. Definitely helpful. Thanks.

    Marcos Reply

  13. Perfect, thanks!

    essgee Reply

  14. very helpful, thanks !

    Goran D Reply

  15. Thank you.

    Gil Reply

  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. Reply

  17. Thanks, very helpful.

    Joaquin Reply

  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 Reply

  19. thanks a lot for your help

    Amruta Reply