Hi ninu

Have you tried explicitly formatting the date on the textbox of the report to the format that you want....?

I can think of a couple of ways:

use SSIS to create a staging table that contains the images and data from the two servers - and then use this newly...

I would double-check your data first - just to make sure there is a total by site. I only say this as you state when you add another column, data...

Just in case this is useful for anyone else, resorted to VB code in the end. Really don't understand why the switch didn't work...?

This is the function:

'**********************************************************************************

'Function to prevent divide...

Thanks Chinna for you reply.

I think this would work if you don't have column groups as well as row groups....

....I've also tried using RunningValue against the values but an error...

Thanks for your reply.

Managed to resolve this last night. I used the following expression in the background colour:

=iif(RunningValue(Cstr(Fields![RowGroupNameHere].Value),CountDistinct,"DatasetName") Mod 2,"LightGrey", "White")

This exploits the CountDistinct across the entire matrix's rows to...

Hi Everyone,

We managed to resolve this in the end. Just in case it proves useful to anyone else, here's what we found:

The N0 (or n0) format means Number with 0...