Cheers Geoff - always great to see different ways of doing things...

Many thanks and cheers for the prompt reply!

Chris

That works perfectly!!

Thanks so much...

Hi Dev

Cannot guarantee order. Essentially I just want all Y rows and N rows when the customer (ID) doesn't also have a Y. The problem is they will have numerous...

Thanks so much - i'll give that a try. 🙂

Cheers for this - i should be able to adapt easily for my sproc...

Cheers

I'll give them a look...

Cheers Chris - worked a treat.

Hi Chris

This solution worked brilliantly - thanks again for your help.

How would this work if i wanted to merge a new set of rows to the same table?

It seems that the .rdl suffix disappeared from my reports name - I don't recall doing this but you never know...

To solve the problem I just Saved As the report...

Yes, that's right - I opened the Project folder and then within the Visual Studio Solution Explorer i opened the report item itself. It's odd because this is the...

Cheers Jeffrey

So rather that using DATENAME or DATEPART functions in T-SQL bring back the 'raw' date and then build an expression in SSRS to format the date in the way...

Works perfectly - many, many thanks again for this!

Cheers for this - i'll give it a crack straight away.

🙂

Although the year sort, month sort works in SSMS - when i pull through into SSRS it still doesn't sort in the correct way. My reporting period runs from April...