User requested variables are not filtering the report correctly

[haleb]

We have variables set up to be "Request from User", both fields being used are strings. When previewing or running the report and selecting the desired value from these variables we the report is not filtering the data correctly, in many cases it is still returning all values. We tried adding an expression to the databand and that did not correct this issue. Expression: Status.Contains(ServiceRequests.Status) Has any one had issues with this?

[Andrew]

Hello,

The images are cut, please upload them again.

Thank you.

[haleb]

Please see the below.

Variable set up:

The attachment Variable_SetUp.png is no longer available

Report preview not rendering per user selection:

Variable_SetUp.png (19.45 KiB) Viewed 2697 times

[haleb]

Image two:

Report preview not rendering per user selections

Preview_of_report.png (79.11 KiB) Viewed 2696 times

[HighAley]

Hello.

Did you use the variable to set the filter of the data band?
Please, look at the tutorial video.

Sorry, it's too old but the solution is the same.

Thank you.

[haleb]

When following the exact steps of the provided video link we now have an extra check box in the header and we are still receiving inconsistent results. We would prefer to have a list of items and be able to select one or multiple. Please see the below images.

VideoSample.png (52.55 KiB) Viewed 2671 times

Status_List.png (23.04 KiB) Viewed 2671 times

SB_Var.png (16.59 KiB) Viewed 2671 times

Filter_Expre.png (14.69 KiB) Viewed 2671 times

[Lech Kulikowski]

Hello,

Please send us a sample report with test data which reproduces the issue for analysis.

Thank you.