SSRS Report Manager - Subscriptions failing

Posted on 2009-02-19
Last Modified: 2012-06-27
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.

Question by:cpm45
    LVL 11

    Accepted Solution

    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;

    Author Comment

    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?

    Author Comment

    Disregard, I found it.
    LVL 11

    Expert Comment

    I did answer his question, the disregard part was on the location of the default parameters.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    728 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

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now