Nice setup... makes sorting this stuff out not to hard! I would probably use a cursor because you have to process each combination of Version and Doc separately... ...

Why can't you just do that in your SQL statement? You would probably have to do a lot of

COALESCE(MyColumn1,0) + COALESCE(MyColumn2,0)....

What are you trying to accomplish? can you...

Which was...?

I think I just very carefully solved this using a 2012 solution... figured I would post it for people to tear apart...

the ROWS PRECEDING window function is new in 2012......

Look it up in Active Directory

Like this...

=MonthName(Month(Fields!DueDate.Value)) & " " & Year(Fields!DueDate.Value)

just change DueDate to your field name.

If you are breaking up the year into 4-week "groups", then from what date are you starting the count? The first day of the year? If not, how...

Remove Dates? Where?

Do you have a Calendar/Date dimension table? Could just be me, but I thought you had to add a column to your Fact table for the...

Sean,

I had to cheat and add an extra record, because I needed to check the grouping... (should have mentioned that).

To the OP...

If you're asking for help, please help...

Sean,

I had to cheat and add an extra record, because I needed to check the grouping... (should have mentioned that).

To the OP...

If you're asking for help, please help...

Good to hear!

You're welcome =)

In a SSRS 2008 report, I will have between 1 to 30 different small ssrs reports that will be executed in a specific order. All the reports will pass the...

What's the rule about the 52 weeks? Do they start at the first of the year, or is there some other rule for that?

I figured that since he was new, I would be nice and show him how to set up the problem so that people could help...

to the OP - if ...

Turns out I did that same thing when I first tried it... You have to wrap the units in double quotes, because this is .NET, not SQL (so the rules...