I have a strange SSRS 2008 subscription issue. I am hoping others have experienced this and can help point me in the right direction. Background: I have a report that has two datasets: One dataset pulls the max period end date from my data warehouse and stores the value in my @Period_End_Date parameter. The second dataset runs a standard query that is only filtered by the @Period_End_Date parameter. I have taken this report, published it to Report Manager, and created a time-based subscription that runs each weekday. The Problem: I am getting inconsistent results from the subscription. The first execution this week was flawless, as it passed in the appropriate @Period_End_Date value (15-May-2011). However, the very next day, the report output indicated that the value passed for @Period_End_Date was for last month (30-Apr-2011) - not what I would expect. When I then re-run the report manually, the report uses the appropriate @Period_End_Date value (15-May-2011) and returns the right data to the report. This has me scratching my head, and has my users questioning the realiability of our reporting solution. Has anyone experienced anything similiar? If so, please share. Thanks!

Hello Jeff Cornelius, Did you specify the report parameters in the subscription titled REPORT VALUE PARAMETERS at the bottom of the page??? Kind Regards, WCC44

Yes. The @Date_Period_End parameter is filled in with the correct default value in the subscription properties. The 'Use Default' checkbox is selected.

Hi Jeff, All you have mentioned seems to be fine. If you have specified the report parameters in the subscription and with “Use Default” is checked, generally, we could get the report from this subscription with the default value . Could you please make sure the default value in your report is “15-May-2011” like following steps, 1. Open the subscription you have designed for the report. 2. Make sure filled “15-May-2011” in the Period_End_Date parameter textbox. 3. Open report and click Properties. 4. Click Parameters tab on the left side. 5. Check filled “15-May-2011” in Default Value textbox of Period_End_Date parameter. Hope that helps you. Thanks, Eileen