Hi
Using SQL I want to assemble a dataset (to be used by a Quick
Report) that will allow me to express each group total as a percentage of the
grand total.
I can't calculate the percentage at the group level in the
report because we don't have the total until the end, so it seems that I need to
have the grand total read into the dataset.
Are there any tricky ways of achieving this? or is there no
alternative to just doing a double pass through the dataset?
TIA
Mark
|
BEGIN:VCARD VERSION:2.1 N:Howard;Mark FN:Mark Howard EMAIL;PREF;INTERNET:[EMAIL PROTECTED] REV:20010925T234725Z END:VCARD