You do it by making your available parameter values come from dependant queries. For example the available values for your enddate would come from a query something like:

SELECT datefield...

I had a similar problem where I went back to the query to get the results I wanted. Using temp tables or common table expressions I built a top...

I have been really getting beat up by the QoTD lately, but I am learning a lot. The code from #4 went right into my code library.

The follow up...

Do the reports run manually from Report Manager?

Are you getting any errors when it won't allow you to create a subscription?

Cut my heel, had to cruise on back home.

Does anyone really know what a pop top is anymore? Don't look now but our age is showing.

So if the Parameter selection is Auto you want column headers to be something like

COL1, COL2, COL3

If the parameter selection is Workers Comp you want the column headers...

What happens when you do a normal subscription (non data driven()? Does an email get sent?

Does your data driven subscription have more than one recipient? If so, have...

Instead you might want to make the end date dependant on the start date (cascading parameters) so that the end date can not be less than the start date.

Learned something new today, thanks.

It is a small problem, but I do it all the time. I regularly have SSMS connected to several servers at a time. I regularly open a script...

If you have a group, you can use a scope statement that should sum it according to the grouping. Something like

=Sum(Field!Delta.Value,"groupname")

Everything you say can be used against you.

I think the question is kind of a tricky one, but many QoTD are tricky. I missed the point, but I did learn something...that you can color code the...

If you are talking about running the report multiple times with a single value as an input parameter, accumulating in a PDF document so that the PDF document shows all...

electroplate