errormessage
1 Topic
Report Builder Error - Forward Dependencies Are Not Valid
Hi everyone! I'm working on building a paginated report using Report Builder. I created a data source and dataset on Report Server. The dataset has a parameter specified in the query, so the parameter was generated in Report Builder when I connected the report to it. I'm trying to add values in the Available Values tab of this parameter, but when I try to run the report, I'm getting an error message that says "The report parameter xyz has a DefaultValue or a ValidValue that depends on the report parameter xyz. Forward dependencies are not valid." This parameter is being used in a where clause on the dataset (something like below), so I don't believe there are any dependencies here. SELECT * FROM table1 t1 JOIN table2 t2 ON t1.key = t2.key WHERE Department = @Department AND XYZ = xyz Please advise. Thanks!Solved9.7KViews0likes2Comments