Solved

SSRS Subscription - Only today's data

Posted on 2011-03-02
2
1,945 Views
Last Modified: 2012-05-11
I have a SSRS report that has a parameter named “SelectDate”, with a datatype of “text”.  It is associated with a dataset field:  CONVERT(DATE, tableName.smalldatetimefield, 101) AS RECEIVED_DATE.

When a date is manually entered in the report’s “SelectDate” parameter, the report runs successfully.

I am trying to set up a subscription to be emailed daily with data received that day (using today’s date in the “SelectDate” parameter field).  In the subscription setup, under “Report Parameter Values”, I have tried:

today(),
GETDATE(),
NOW(),
CONVERT(varchar(10), GETDATE(),101),  
CONVERT(varchar(10),today(),101),
CONVERT(varchar(10), NOW(),101)

I receive the following error:
“Failure sending mail: An error has occurred during report processing. Mail will not be resent.”

What should be placed in the subscription setup under “Report Parameter Values”?
0
Comment
Question by:nulad
2 Comments
 
LVL 39

Accepted Solution

by:
lcohan earned 500 total points
ID: 35019234
I think you need to add a GETDATE() default parameter value and please see link to find out how

http://www.sql-server-performance.com/articles/reporting/report_parameters_p1.aspx
0
 

Author Closing Comment

by:nulad
ID: 35019846
After I added a default value in the parameter instead of trying to add it to the subscription it worked properly.  Thank you so much for your help.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack.  Those functions are IIF() and Switch().  And I'll be showing you how easy it is to add an Else part to the Switch function. T…
After much searching across the internet I have found that you could not set the name of the file you were attaching to dynamic report subscriptons in Microsoft Reporting Services. I did manage to find one article showing you how your could make a s…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

840 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