Show all data on the table if Parameter is empty

0 Answers 456 Views
General Discussions Report Designer
Raniel
Top achievements
Rank 1
Iron
Iron
Raniel asked on 12 Nov 2021, 07:45 AM | edited on 12 Nov 2021, 07:50 AM

Hello, I'm using a Standalone Report Designer and I'm trying to filter out the table thru Parameter and so far, I managed to make it happened. Now, I want to show all the data on the table if the parameter is empty (my parameter type is string). I saw this thread and did follow the instruction here https://www.telerik.com/forums/how-to-show-all-values-with-filter-enabled and https://www.telerik.com/blogs/do-not-filter-on-null but I didn't succeed, If I empty my parameter, no data is showing.

NOTE: MY DB TABLE ACCEPTS NULL VALUES

Here's the  situation:

I have a list of accounts and I'm filtering  them out by their status which is I managed to filter those who are Activated and Pre-Activated status.

What I want to do is if I empty the parameter, there should be nothing to  filter which means the table should show all the data both Activated and Pre-Activated.


My parameter screenshot


Filtering the table if null

Raniel
Top achievements
Rank 1
Iron
Iron
commented on 15 Nov 2021, 05:04 AM

UPDATE:

I figured it out after checking this https://www.telerik.com/forums/optional-filters-in-telerik-reporting

Close this thread, thanks.

No answers yet. Maybe you can help?

Tags
General Discussions Report Designer
Asked by
Raniel
Top achievements
Rank 1
Iron
Iron
Share this question
or