Many thanks for your prompt responses. I am testing it now. Looks good.

• This reply was modified 2 years, 4 months ago by  DerbyNeal.

Hi,
I realise my error....

I set the conditioning within the 'Row Visibility' instead of 'Row Group/Group Properties'. It made me feel humbled but at the same time, I think the...

Hi,

Thanks guys. I've done some initial testing and the issue appears to have been resolved.

Excellent prompt responses!

Hi Alan,

Thank you for your reply, I appreciate your...

I have removed the initial section (which is largely irrelevant here). After the declarations (some variables might be superfluous), this example begins with the pre-loading of the @tblResults table.

In the...

Many thanks Anthony

I only want data from the current month. The selection criteria is from the 1st until the previous day (i.e. as today is the 25th, then from 01/07/2014 until 24/07/2014)....

Aah yes... A 'null' would be fine. Thanks 🙂

Thanks guys (Abu + ChrisM@Work)

The update looks good to go!!

Thanks Abu,

But I need the Perc column to be updated to 67 where DeliveryDate = '2013-04-25'

because ((2/3) * 100) = 66.6666 (rounded = 67).

Thanks for your help though, 🙂

Phil - Many thanks!! It looks like it's done the trick 🙂

I do have another query though...

I have a table (@PTable) which needs 2 updates performed on it.

Firstly, the records are grouped by 'Phone'. I need a distinct count on the...

Thanks Luis & Dwaine for your help.

Dwain - I Don't need to cater for that, as the table query is refreshed each day (It is a snap-shot query).

Hi Luis,

Essentially I need to update the 'CustomerName' column based on the phone grouping where the phonecount <> 0 (see Max(Id) in your 1st post) .

If there are more...

Can someone help further please?

I need to update an additional column 'CustomerName' within the table. How do I count the TableSource for each Phone (for example: In the above...