Deja vu, all over again.

I agree a calendar/date table is the way to go.

I haven't tested the efficiency of this, but I suspect it is a bit more efficient than what you have listed...

I assume that when you look at it online it has the number of pages listed, and when you look at the pdf it also has the number of pages...

In my opinion, both. It is possible to run a data warehouse from an OLTP db directly without a cube. If you think about the term warehouse it...

Clouds

Create a data driven subscription. I do this with dates all the time.

SELECT StartDateParm = DATEADD(dd,-7,GetDate()), EndDateParm = GetDate()

As you set up your subscription, you use StartDateParm and EndDateParm...

Fiddle with the report size and margins until you get a one to one match with pdf output.

bopeavy (7/28/2011)

Ray K (7/28/2011)

"I'll have the spam spam of...

Try using the CONVERT function in your dataset rather than your report.

You didn't give us much to go on with regard to the data you have to work with, but I would be inclined to do this in the dataset. ...

One thing I did forget to mention is to refresh your preview. The dev environment will frequently hold data in cache to show a preview screen faster. After...

Meadow

Use a matrix with your months at the top, your groups on the side, and your count as the data.

SSRS has the ability to filter data in datasets, so the first place I would look would be to see if the dataset is being filtered.

Next I would look carefully...

crookj (7/26/2011)

Ray K (7/26/2011)

Well I'm a chicken hawk, and I'm here to get myself a chicken!!!...