CODEWITHSUNDEEP
sqlreporting-servicesreportbuilder3.0
NDV
NDV

Reputation: 3

Report Builder 3.0: Forward Dependency Error When Creating a Filter

I'm creating a fairly simple report in Report Builder 3.0 that requires a filter for part numbers between two user-specified values, both of which are taken from a list of existing part numbers. Before I added a filter, everything ran perfectly fine-- no errors with either of my two parameters(which are under the "Parameters" folder in report data, not the "Parameters" section within dataset properties). Although, after adding it and trying to run the report, I receive an error that reads:

The report parameter ‘pnPromptField1’ has a DefaultValue or a ValidValue that depends on the report parameter “pnPromptField1”. Forward dependencies are not valid.

I've tried messing around with the default and available value sections under the parameter properties, but nothing I do seems to work. All of the properties for both parameters are default, minus the name/prompt and the available values, which both have options set to "Dataset: inv, Value field: pn, Label field: pn".

The fact that everything ran smoothly before the introduction of a filter is what confuses me most, as nothing was changed in the report at all with the exception of the filter being added. The filter's properties are "Expression: [pn], text(unchangeable), Operator: Between, Value: [@pnPromptField1] & [@pnPromptField2]

Any and all help is appreciated, I'm still new to SQL and pretty much anything related to it. Thanks in advance

Upvotes: 0

Views: 2170

Answers (2)

Tab Alleman
Tab Alleman

Reputation: 31785

You've put a filter on a dataset, and made that filter dependent on the same dataset. Due to way SSRS handles this, this means that you basically made your dataset dependent on itself, which SSRS doesn't like for obvious reasons.

I don't know if there are other ways around it, but the way I have handled similar issues in the past is to make two datasets, even though they are both using the same query or proc, and make one dataset dependent on the other.

Upvotes: 0

Manoj
Manoj

Reputation: 631

The report parameter ‘pnPromptField1’ has a DefaultValue or a ValidValue that depends on the report parameter “pnPromptField1”. Forward dependencies are not valid.

This Error occurs when One parameter depends on the other Parameter value. for example if you have first parameter 'pnPromptField1' that depends on the 'pnPromptField'. In design time you have added 'pnPromptField1' after 'pnPromptField' then it will through you error.

so you have to check the Order of Parameter that you added to your reports.

'pnPromptField' 'pnPromptField1'---this parameter depends on above one.

not like this

'pnPromptField1' 'pnPromptField'---this through you error 'dependency'.

Upvotes: 0

Related Questions