• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2059
  • 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

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

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