Viewing 15 posts - 1 through 15 (of 76 total)
Many thanks for your prompt responses. I am testing it now. Looks good.
August 3, 2022 at 9:11 am
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...
July 20, 2018 at 6:44 am
Thanks guys. I've done some initial testing and the issue appears to have been resolved.
Excellent prompt responses!
March 2, 2015 at 8:47 am
You would handle this in the default value for each child parameter. Make the default value the same as the available values
Thank you for your reply, I appreciate your...
February 25, 2015 at 2:41 am
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.
November 18, 2014 at 5:08 am
Many thanks Anthony
July 25, 2014 at 9:18 am
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)....
July 25, 2014 at 9:14 am
Aah yes... A 'null' would be fine. Thanks 🙂
July 25, 2014 at 8:58 am
Thanks guys (Abu + ChrisM@Work)
The update looks good to go!!
April 25, 2013 at 8:20 am
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, 🙂
April 25, 2013 at 5:26 am
Phil - Many thanks!! It looks like it's done the trick 🙂
February 6, 2013 at 8:46 am
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...
August 22, 2012 at 6:57 am
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).
August 22, 2012 at 6:55 am
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...
August 21, 2012 at 12:49 pm
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...
August 21, 2012 at 11:45 am