• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 367
  • Last Modified:

SSRS Report Manager - Subscriptions failing

Hi,
Very new to SSRS. I created a report with two params (@StateDate and @EndDate). In Visual Studio, I get prompted for the dates, enter them and the report runs with no problems. I then deployed this report to the Report Manager and set up a Subscription. The subscriptions are failing and when I try to generate the report in Report Manager I get the error that it failed and 'Procedure or Function 'sp_nameofmyproc' expects parameter @StartDate which was not supplied.

So I guess I just don't know where I'm off. It works fine in Visual Studio, but fails in Report Manager.

Thanks.
0
cpm45
Asked:
cpm45
  • 2
  • 2
1 Solution
 
dodge20Commented:
The subscriptions are failing because you need to enter a value for your 2 parameters.

You need to set the report parameters default values in the report menu-report parameters

You can hard code a default value or more likely, you can put a dynamic value in using expressions. Todays date for example;
=Today()
0
 
cpm45Author Commented:
Again, very new at SSRS, in fact this was my first report. Could you please be more specific i.e. where in the report params screen do I enter the values?
0
 
cpm45Author Commented:
Disregard, I found it.
0
 
dodge20Commented:
I did answer his question, the disregard part was on the location of the default parameters.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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