Solved

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

Posted on 2014-12-24
2
95 Views
Last Modified: 2016-02-18
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
Comment
Question by:rhservan
2 Comments
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
What issues are you having?

Can you create a parameter?

What do you mean across all datasets?

mlmcc
0
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 500 total points
Comment Utility
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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now