?
Solved

SSRS Subscription with Parameters

Posted on 2013-01-23
1
Medium Priority
?
485 Views
Last Modified: 2013-02-09
Urgent.
I have a report in SSRS that shows data that has been updated and I need to set a parameter that gets the last update (this is being run daily) and a subscription that runs daily but if there are no updates then do not send report.

Presently, I only have an update that is timestamped last week so I cannot test for =today() because this throws an error (and I cannot change the timestamp or create a table). Pls explain how to set the parameter so that it gets the days' updates.

Also, How can I set up the subscription?  Do I copy the SSRS query to the query text box in subscription area to run the report?  

I am a bit confused on these processes - just started using SSRS.

Thanx, Bobbi
0
Comment
Question by:BobbiD
1 Comment
 
LVL 11

Accepted Solution

by:
SThaya earned 1800 total points
ID: 38814165
hi,

 Try the below below steps .

1. create a parameter and set the available values and Default values properties .
2. in default parameter set the default value expression as per your requirement.


3. go top the subscription tab.... create a new subscription.... in the bottom you can see a option with the check box for default value. select the check box and press ok .. this will take the default value as per your expression when ever its running.



if you are not clear  can you please tell me what value are you going pass for processing your report.

give one example with data
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
In this article I will describe the Detach & Attach 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.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…

864 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