Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

how can a  run time parameter be created in SSRS 2005/2008?

Posted on 2014-11-08
2
Medium Priority
?
405 Views
Last Modified: 2014-11-10
Hi,

what is a run time parameter and how can I create and modify it in SSRS2005/2008?

Thanks in advance
0
Comment
Question by:shmz
2 Comments
 
LVL 66

Accepted Solution

by:
Jim Horn earned 2000 total points
ID: 40431603
In SSRS you can have parameters that are exposed to the user / scheduled job, such that the user / scheduler can choose values and then the report will run based on those values.  

Some often-used examples are customer id, state code, days / months.   Usually these parameters will directly feed parameters in a Data Source that is a SQL Stored Procedure that accepts those parameters.

To create one that the SP uses, just add the SP to the data source, and you'll automatically see them in the Parameters folder.   To create one that is not related to a data source, in the Report Data window find the Parameters folder, right-click: Add Parameter, and add away.
0
 

Author Closing Comment

by:shmz
ID: 40433949
Thank you
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

564 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