Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2090
  • Last Modified:

SSRS Subscription - Only today's data

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
nulad
Asked:
nulad
1 Solution
 
lcohanDatabase AnalystCommented:
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
 
nuladAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now