Creating reports and dashboards | Stimulsoft community forum

Hi

Is there a way to create multiple filters but allow users to choose which filter to apply at runtime (Preview)?

Hello,

You can use the Request From User variables for this task.

Thank you.

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

Hello,

You can add additional boolean variables that will apply only the necessary filters.

Thank you.

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

Hello,

You can add additional variables, and you use the following expression:
{ApplyFilter && HireDateRange}

Thank you.

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.

Hello,

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

Thank you.

hi Lech,

Where can I get test data? is there a document I can follow to create this sample report?

Hello,

You can use the Embed All Data to resources option.

Thank you.