Try setting the KeepWithGroup property of your footer rows to "Before"

PSB (2/14/2011)

I have a query that is filtered by StartDate and EndDate

WHEN I used

DECLARE @StartDate DATETIME

DECLARE @EndDate DATETIME

SET @StartDate = '01/01/2011'

SET @EndDate = '02/02/2011'

And in...

chocolate hearts

The people that got it wrong must have thought there was a trick in the question. Sometimes the questions is just what the question is. 🙂

Moor

Durable

LOTR is an epic story spread across several books & movies. Clearly a single story, but you can count the books & movies as you like.

A lot of people, including me really like this one.

http://www.amazon.com/Applied-Microsoft-Server-Reporting-Services/dp/0976635313/ref=sr_1_1?ie=UTF8&s=books&qid=1297106129&sr=8-1

Make your existing parameter a single select. Then make another parameter that is virtually identical to the first with just a different name. Assuming the months do not...

Do you have the rdl?

A character from one of my favorite fantasy movies ever.

The short answer is yes.

You need to put some error handling in your SSIS package that will execute a SQL script when the job fails.

All SSRS report subscriptions ultimately become...

I always thought something was fundamentally wrong with the universe.

paul.knibbs (2/4/2011)

Hugo Kornelis (2/4/2011)

I chose the correct answer because I considered the scenario of a database with a long-running transaction. When the oldest active VLF is necessary for tha ttransaction,...

The Albany NY area. We hit about -14 below last week. Average highs in the mid teens lately. Now even more snow.

I did the opposite...