I have a report developed in ssrs 2005 and it runs on 2008 report server. It has 5 parameters (out of which 2 are date parameters and the other 3 are multi select parameters (A, B and C) and these three parameters are cascading parameters (depending on the value of A that we choose, B and C values differ).
I need to create a subscription saying start date is yesterday, end date is today and my user gave me some defined values for parameter A and depending on these values, B and C parameters will be determined. For start date = yesterday, I should be creating a data driven subscription, but in that case, I don't see any drop down values for the other three parameters.
If I choose a regular subscription, then I cannot achieve start date = yesterday.