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.
cpm45Asked:
Who is Participating?
 
dodge20Connect With a Mentor Commented:
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
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.

All Courses

From novice to tech pro — start learning today.