Good Morning all, I have a series of Sales Rep reports that runs on shared schedule subscriptions. I have a monthly shared schedule that runs and a weekly shared schedule that runs. The weekly schedule report runs the first time and never runs again. When I go into Manage and Subscriptions, the Weekly Report Parameter Values are empty. There is a yellow triangle exclamation message that says "One or more report parameters have an invalid parameter value." The Monthly subscription looks fine and still populated with correct parameter.
To let you know how I set these up, I first created weekly and monthly parameters in the report itself. I created 11 reports for each Rep. In my queries where clause I created a [>=@StartDate and an <=@EndDate] parameter. Under "Parameters" I see those two parameters I created. Both parameters are DateTime with no null or multiples allowed. Available values have two values: Under @StartDate "Month Start" =DateSerial(Year(Today), Month(Today), "1").AddMonths(-1) "Week Start" =DateAdd("d", -8, Today()) Under @EndDate "End of Month" =DateSerial(Year(Now()), Month(Now()), "1").AddDays(-1) "End of Week" =DateAdd("d", -1, Today())
I have tried a regular subscription schedule and a shared subscription schedule. The same thing happens, the weekly runs once and never again. I have the schedule set to run at 7:30am every Mon of every week. The shared monthly schedule is a once a month on the 1st of every month. Under Report Parameter Values I see two drop downs "Start Date" and "End Date" and my report parameters "Month Start" and "Week Start along with "End of Month" and "End of Week" are in there - in that order.
I do not have "Default" parameters set up. The parameters checked say prompt user. Processing says to Run with the most current data and Do not cache temporary copies of this report. There is no snapshot setup either. When I did have "Allow Report history to be created manually" it also gave errors. So I unchecked it. I am desperately trying to find a reason for the subscription failure. I believe it might be my date formula calculating from the report parameter.... I just don't know. I'm under the gun. I appreciate any help I can get.
I do not have "Default" parameters set up
This may be your problem. A subscription cannot prompt anyone for parameters - there's no human there to supply them. You need to either provide defaults, or enter values for the subscription.
If I misunderstood, and you do provide parameter values for the subscription, try looking in the SSRS log files - they'll be in ...\Reporting Services\LogFiles\, and may contain a more verbose error to help you determine where the actual problem lies.