OK. I understand. Could you show how that looks for just one of the case statements in the group by clause

That's ok. I really really want it to work. I have been working on it for ages and would really appreciate it if you could.

Thank you so much!!!

Thank you so much for spending the time to do that. Can I ask you for one more favour? Can you get the code I wrote to work also?

OK. Thanks for your help.

I'm sorry. But I am a bit lost here. I think I need the sum aggregate function. I don't think max will give me what I'm looking for.

OK. I have changed the code, but I am still getting the following error:

Cannot use an aggregate or a subquery in an expression used for the group by list of...

Thank you for all the feedback so far.

I am a bit surprised the SQL Management Studio is interpreting my code as sub-queries. Can someone please explain why? I don't think...

OK. I'll give it a go!!

Ok. Thanks to everyone for their help.

Thank you. Your explanation is very useful and I am beginning to understand more and more about the first function.

Thanks Again!!

OK Thanks

So its better to just let SSRS insert the First function for you automatically?

That works just fine!! Thanks very much for your help!!

Does that also mean I don't ever need to worry about inserting the First Function myself, or are their times that the First function may be needed that SSRS doesn't...

Does that mean that SSRS inserts the First function automatically for you?