Had a brainwave as this will be an SSRS report I could do conditional sorting on it in there versus in the query itself.

Although I am a dog with a...

Phil, those were the groupings they wanted but I am going to change them as I do not disagree with you it's misleading :).

So I did change it to this:

with...

I think I was staring at it for too long, HOW can I keep missing brackets. I really am a chud.

Thank you both very much, actually the explanation was helpful....

Hugo, my apologies as it was an SSRS question I didn't post more but you are right best to put everything on here.

Actually what you gave me worked perfectly, so...

Making sure I reply back to all threads I get advice on, it was date related but thankfully solved :). Thanks for your help it has been so useful. Feel...

Thank you again for this, I am reading everything at the moment so thoroughly as it can only make my coding better :).

If I tell you what I did you...

Hmm it's always something. Oddly no data is going into the table although the report will run/no errors. So got a table with the headers but no data.

Running fine everywhere...

You know, I am a good baker I wish I could pay all you good people in cakes.

Worked perfectly, am adding try_parse to my list of things newly learnt. I...

It is:

An error occurred during local report processing.

An error has occurred during report processing.

Query execution failed for dataset "FULL_DATA".

Conversion failed when converting date and/or time from character string.

No errors when...

Just coming back to this, I am now trying to use this in SSRS and it keeps throwing up an

conversion failed when converting date and/or time from character string

error.

I...

That's amazing just read the article, tested it in Dev WOAH! Thank you SO much saved me a lot of rubbish coding with CASE statements.

Hi Luis,

Thank you am going to have a good read of that article, put it in Dev first (because I am not crazy) and test it fully.

Really appreciated, learn something...

Right so, it's still not working but I really do think it is almost there rarrghh. Sorry for delay I was off with this vile bug.

So, the date field matches...

Get me? you are coming up trumps for me! It hasn't entirely worked but I am going to persevere as I reckon it just needs tweaking. I might be back,...

Hi peterzeke,

If it's similar to what I had, I tried this solution yesterday and it worked like a charm.

There are compatibility issues with IE11 (and Chrome and so on!)

https://www.mssqltips.com/sqlservertip/3666/sql-server-reporting-services-ssrs-is-not-compatible-with-internet-explorer-11/

Hope this...