Unable to add SSRS Parameters/Filters

2
votes

I have created a ssrs report which requires a drop down filter to select values.

The steps I have taken in report:

  • Created the Dataset
  • SELECT * FROM Voluntary_CCC_Split
  • Then applied where statement in dataset - where [WORK ORDER OPERATIONS TYPE] in (@WorkOrderOperationType)
  • The parameters now appears but when changing to available values and selecting dataset, value field and label field i get error below when generating report:
  • the report parameter has a default value or a valid value that depends on the report parameter. forward dependencies are not valid
  • I only have one parameter
1
reporting-servicesssrs-2008
Does your parameter reference itself to set defaults? Can you post the code from any expressions you're using in the defaults or available values for the parameter? - kyzen
SELECT * FROM Viewname WHERE ([WORK ORDER OPERATIONS TYPE] IN (@WorkOrderOperationType)) - user3588635
Kyzen this is only data inputted into the dataset. I then want to just get a drop down filter in the parameter but when i try to select something there i get a error message as above. - user3588635
Does the parameter source its available values from the same dataset that you're using on the report? - kyzen
Kyzen - Yes I have tried both methods with data source and another data source - user3588635

1 Answers

1
votes

Your parameter was configured to have its available values populated from a dataset that referenced the same parameter. Instead of this circular reference, create an additional dataset that simply returns the labels and values for the data you need, and use that to populate your parameters available values.