How do I build a single parameter to work across 3 different datasets?

Current:
I have a report with hard coded filters on:
1. Community
2. PayPeriod

This worked fine while I worked out report issues. But now the report is complete accept I want to add parameters.

How can I create the parameters above and have them work across all datasets?

Let me know I need to clarify anything for you.

Thanks, Merry Christmas
rhservanAsked:
Who is Participating?
 
Phillip BurtonConnect With a Mentor Director, Practice Manager and Computing ConsultantCommented:
By default, all parameters are AVAILABLE to all datasets - but you need to reference them in the dataset.

See http://www.sqlchick.com/entries/2012/1/8/relating-parameters-filters-in-sql-server-reporting-services.html for more information. Hopefully that will help.

If you have a more specific question, please let us know.
0
 
mlmccCommented:
What issues are you having?

Can you create a parameter?

What do you mean across all datasets?

mlmcc
0
All Courses

From novice to tech pro — start learning today.