Forum Discussion
MikeDubya
2 years agoHelper I
REPORT BUILDER Question - How to Filter a Parameter
Hello, I want to filter my Parameter to only show values with data. Example, I am pulling in a bunch of email addresses and using that as my Parameter. User selects an email address and a list of i...
- Anonymous2 years ago
Hi, MikeDubya
Based on your descriptive information, I have the following dataset:
Table1Additionally, as you mentioned you have a table of email address statistics:
Table2In Report builder first use dataset1 to create a dataset1, select Filters to filter the Count column to non-zero:
Create a new parameter:
Import table1 into report builder and create a dataset2:.
In filter, select fx, and set it to the parameter you just created:
After setting it up, the result of putting dataset2 into the table is as follows:
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
MikeDubya
2 years agoHelper I
I should also mention that it is one Table, not two.