Choosing filters to apply
Choosing filters to apply
Hi
Is there a way to create multiple filters but allow users to choose which filter to apply at runtime (Preview)?
Is there a way to create multiple filters but allow users to choose which filter to apply at runtime (Preview)?
-
- Posts: 6272
- Joined: Tue Mar 20, 2018 5:34 am
Re: Choosing filters to apply
Hello,
You can use the Request From User variables for this task.
Thank you.
You can use the Request From User variables for this task.
Thank you.
Re: Choosing filters to apply
Hi,
What I meant was I have 2 filters that is set to "Request from User"
However, is there a way to allow user to choose which filter to use when previewing the report, without having to check and uncheck "Request from User"
For example.
For an instance, i would like to filter using ONLY hire date range,
Another instance, I would like to filter using ONLY Cess Date,
Another instance, I would like to filter using BOTH
What I meant was I have 2 filters that is set to "Request from User"
However, is there a way to allow user to choose which filter to use when previewing the report, without having to check and uncheck "Request from User"
For example.
For an instance, i would like to filter using ONLY hire date range,
Another instance, I would like to filter using ONLY Cess Date,
Another instance, I would like to filter using BOTH
-
- Posts: 6272
- Joined: Tue Mar 20, 2018 5:34 am
Re: Choosing filters to apply
Hello,
You can add additional boolean variables that will apply only the necessary filters.
Thank you.
You can add additional boolean variables that will apply only the necessary filters.
Thank you.
Re: Choosing filters to apply
Hi Lech,
Thank you for your quick response.
I'm quite new to stimulsoft and still trying to figure things out.
I tried to create a boolean variable but I can't seem to change the Key value. It will always be defaulted to false
And I am not sure how to write the expression to retrieve the boolean value
is it
But this code doesn't seem to work
Thank you for your quick response.
I'm quite new to stimulsoft and still trying to figure things out.
I tried to create a boolean variable but I can't seem to change the Key value. It will always be defaulted to false
And I am not sure how to write the expression to retrieve the boolean value
is it
Code: Select all
{bool_variable[0]? "true" : "false"}
-
- Posts: 6272
- Joined: Tue Mar 20, 2018 5:34 am
Re: Choosing filters to apply
Hello,
You can add additional variables, and you use the following expression:
{ApplyFilter && HireDateRange}
Thank you.
You can add additional variables, and you use the following expression:
{ApplyFilter && HireDateRange}
Thank you.
- Attachments
-
- Screenshot 2024-02-14 102612.png (10.94 KiB) Viewed 642 times
Re: Choosing filters to apply
Hi Lech,
I am able to create 2 boolean variables
However, in the filter section, I wrote these 2 expressions When I tried to preview the report, I have to tick both checkbox for my report to display data because i'm using the AND operator in the filter screen
I tried the OR operator, but when I tick both checkbox, it applies both expression separately. (Means records that meet the hire date range criteria ONLY, and records that meet the cessation date range criteria ONLY)
This doesn't give the user the flexibility to choose either 1 or 2 filters to apply For example.
If I ONLY tick Hire Date, my data should apply the hire date range ONLY
If I tick Hire Date and Cessation Date, my data should only show records that meets BOTH the Hire Date Range and Cessation Date Range critieria.
I am able to create 2 boolean variables
However, in the filter section, I wrote these 2 expressions When I tried to preview the report, I have to tick both checkbox for my report to display data because i'm using the AND operator in the filter screen
I tried the OR operator, but when I tick both checkbox, it applies both expression separately. (Means records that meet the hire date range criteria ONLY, and records that meet the cessation date range criteria ONLY)
This doesn't give the user the flexibility to choose either 1 or 2 filters to apply For example.
If I ONLY tick Hire Date, my data should apply the hire date range ONLY
If I tick Hire Date and Cessation Date, my data should only show records that meets BOTH the Hire Date Range and Cessation Date Range critieria.
-
- Posts: 6272
- Joined: Tue Mar 20, 2018 5:34 am
Re: Choosing filters to apply
Hello,
Please send us a sample report with test data that reproduces the issue for analysis.
Thank you.
Please send us a sample report with test data that reproduces the issue for analysis.
Thank you.
Re: Choosing filters to apply
hi Lech,
Where can I get test data? is there a document I can follow to create this sample report?
Where can I get test data? is there a document I can follow to create this sample report?
-
- Posts: 6272
- Joined: Tue Mar 20, 2018 5:34 am
Re: Choosing filters to apply
Hello,
You can use the Embed All Data to resources option.
Thank you.
You can use the Embed All Data to resources option.
Thank you.
- Attachments
-
- Screenshot 2024-02-20 232905.png (37.28 KiB) Viewed 518 times