Forum Discussion
REPORT BUILDER Question - How to Filter a Parameter
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.
I apologize, I didn't do a good job giving example data. Let me try again.
What we have is a list of emails with dates.
| Email Address | Date |
| [email protected] | 7/20/2024 |
| [email protected] | 7/21/2024 |
| [email protected] | 7/22/2024 |
| [email protected] | 7/21/2024 |
| [email protected] | 7/22/2024 |
| [email protected] | 7/27/2024 |
| [email protected] | 7/28/2024 |
| [email protected] | 7/26/2024 |
| [email protected] | 7/27/2024 |
| [email protected] | 7/28/2024 |
| [email protected] | 7/29/2024 |
We want to only see email addresses in the parameter where the date is within 7 days. So if todays date is 7/17/2024, based on the dates above, only these would appear:
| [email protected] |
| [email protected] |
Then if we select an email, the report populates with the appropriate data. We have that part working. We just want to remove any emails with no rows that are within 7 days of "todays" date from the dropdown parameter.
I hope that makes a bit more sense. I do believe what you are showing is close but we couldn't get it to work based on how I had previously described the data. Does that change anything for you?