thanks guys, works great!

hi Mike

Thanks for that.

The actual function is a lot more involved and ive just simplified for demonstation purposes. The customercodes arent actually hardcoded in the function.

in my previous post, i...

hi.

Ive simplified all the code so its easier to illustrate.

For each customer-record in #TempResults, the function Fn_GetAmount is called. The method used to do each function call is...

Perfect.thanks, winash

The function is actually outside the scope of my question and , in fact cannot be changed and is written as efficiently as possilble.

Thanks

Thanks for the replies , Drew and Eugene.

RecordDate is a field on #TempResults - see definition below

ive tried using Drew's idea method but have found that you cannot reference the...

nice to hear.

do you by any chance know of some documentation on the various functions of sql Xml fields and how they are used.

for example , why (header)...

Thanks Lutz !

thanks for the help and advise guys. Gianluca, your posting explains it well!.

Hi YSLGuru

thanks for the reply .

i have tried to use summary sections in the main report but the subreport became necessary as it summarises the data very differently to...