Hi, I've setup a report in Microsoft Visual Studio 2008. I need to setup 2 subscriptions for this report. The first subscription would be to run the report with date parameter of 9 days before Check In Date (=DateAdd("d",9,Today())) of a resort and the second subscription would be to run the report where the date parameter is set to 16 days before Check In Date at a resort. At the moment I have created two different reports, one for 9 days before checkin and one for 16 days before checkin with their respective subscriptions. I tried to use only one report with the different subscriptions, but one subscription would run and the other won't, saying that "the subscription conatains parameter values that are not valid". What are the steps in setting up one report with 2 different subscriptions on a DATE parameter? Thanks Antoinette

You can create multiple subscriptions on a single report. The error says that the value provided for a parameter of the report is invalid. You may have had a typo that created the error. Where do you get the error? Did you try copying the parameter setting from the working subscription and pasting it into the second after changing only the number of days (i.e. 9 to 16 or vice versa)?Please Mark posts as answers or helpful so that others can more easily find the answers they seek.

You can create multiple subscriptions on a single report. The error says that the value provided for a parameter of the report is invalid. You may have had a typo that created the error. Where do you get the error? Did you try copying the parameter setting from the working subscription and pasting it into the second after changing only the number of days (i.e. 9 to 16 or vice versa)?Please Mark posts as answers or helpful so that others can more easily find the answers they seek.

Hi Tim, I've tested the report with both the parameters and it runs perfectly when I choose a parameter and run the report. I've tried this with the 9 days parameter as well as the 16 days parameter. It also brings back the correct information per parameter. Then I've setup 2 subscriptions on the report. One for the 9 days and one for the 16 days. I've let it run every few minutes for a while and there were no problems. They both ran and brought back the correct information every time. After this I've setup 2 subscriptions on the report to run the next day. This is where my problem is. The one subscription on the 9 days ran and the subscription on the 16 days gives me an error saying: "The subscription contains parameter values that are not valid". If I go into the subscription by clicking the Edit button the "Use default" check box next to the date parameter is ticked again. (I unticked it when I originally set up the subscription for 16 days as it refers to the 9 days parameter and I have chosen the 16 days parameter). I don't know why this happens. It seems to happen only on the date parameter as the other parameters where I have unticked the "Use default" button for this particular subscription are still unticked. Thanks for your help thus far.

What are the Available Values for the parameter? That is what defines valid values for the parameter. Yours may be set to a query or perhaps not set at all. If not set at all, does the parameter allow null or empty values? Is the parameter set to datetime type or is it set for the default text type? When do the subscriptions run? If you rerun them later in the day, does it work? I ask because you said that both ran fine every few minutes and didn't fail until you switched it to run the next day. Also, as I understand it, you currently have both subscriptions set with the 16 day subscription failing. Have you swapped the values between the 2 subscriptions? If you do that and the previously working subscription begins to fail while the previously failing subscription begins to succeed then you know the issue is definitely with the value (the 16 day value) and not a glitch in the subscription itself."You will find a fortune, though it will not be the one you seek." - Blind Seer, O Brother Where Art Thou Please Mark posts as answers or helpful so that others may find the fortune they seek.