Page 1 of 1

User requested variables are not filtering the report correctly

Posted: Fri Sep 20, 2019 2:35 pm
by 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?

Image
Image

Re: User requested variables are not filtering the report correctly

Posted: Fri Sep 20, 2019 3:51 pm
by Andrew
Hello,

The images are cut, please upload them again.

Thank you.

Re: User requested variables are not filtering the report correctly

Posted: Fri Sep 20, 2019 4:10 pm
by 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
Variable_SetUp.png (19.45 KiB) Viewed 3408 times

Re: User requested variables are not filtering the report correctly

Posted: Fri Sep 20, 2019 4:11 pm
by haleb
Image two:

Report preview not rendering per user selections
Preview_of_report.png
Preview_of_report.png (79.11 KiB) Viewed 3407 times

Re: User requested variables are not filtering the report correctly

Posted: Sat Sep 21, 2019 8:09 am
by 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.

Re: User requested variables are not filtering the report correctly

Posted: Mon Sep 23, 2019 2:43 pm
by 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
VideoSample.png (52.55 KiB) Viewed 3382 times
Status_List.png
Status_List.png (23.04 KiB) Viewed 3382 times
SB_Var.png
SB_Var.png (16.59 KiB) Viewed 3382 times
Filter_Expre.png
Filter_Expre.png (14.69 KiB) Viewed 3382 times

Re: User requested variables are not filtering the report correctly

Posted: Tue Sep 24, 2019 6:52 am
by Lech Kulikowski
Hello,

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

Thank you.