Forum Discussion
Filtering with a sub filter with multiple value selection - will not work for Report Builder PR
Hi, Karolina411
Thank you for your reply. I also encountered the error you mentioned during the test. Here is how to solve it:
Here are the parameters and dataset I currently have, I will reproduce your error and suggest a solution in the steps below:
I get your error when I follow the steps below to create a dataset:
Here are the correct steps:
The main reason was that the parameter we created (report level) was not correctly recognized by the query engine even though I bound it correctly. My correct steps above utilized the query parameters generated by the query designer and then manually bound to our existing parameters.
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you. I started all over again. Where are you pointing the PhysicianOrganization parameter?
I am getting this error: The 'Value' expression for the text box 'PhysicianOrganization' refers to the field 'PhysicianOrganization'. Report item expressions can only refer to fields within the current dataset scope or, if inside an aggregate, the specified dataset scope. Letters in the names of fields must use the correct case.
----------------------------
The definition of the report '' is invalid.
----------------------------
An error occurred during local report processing.