?
Solved

SSRS Subscription - Only today's data

Posted on 2011-03-02
2
Medium Priority
?
2,009 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 40

Accepted Solution

by:
lcohan earned 2000 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying 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

Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error With the introduction of SQL Server 2008 R2 and Vista (Windows 7 as well) came new enhanced security features. One of the features included was User Access Control (UAC) t…
Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

741 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