Forum Discussion

MikeDubya's avatar
MikeDubya
Helper I
2 years ago
Solved

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...
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi, MikeDubya 

    Based on your descriptive information, I have the following dataset:
    Table1

    Additionally, as you mentioned you have a table of email address statistics:
    Table2

     

    In 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.

     

     

     

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, MikeDubya 

Based on your descriptive information, I have the following dataset:
Table1

Additionally, as you mentioned you have a table of email address statistics:
Table2

 

In 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.