Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 118
  • Last Modified:

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
0
rhservan
Asked:
rhservan
1 Solution
 
mlmccCommented:
What issues are you having?

Can you create a parameter?

What do you mean across all datasets?

mlmcc
0
 
Phillip BurtonCommented:
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

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now