However when I export to excel I group the total by Date this is 95% right but the name field is only populated at the top i.e.
Name Date Total
Is there a way I can export to excel (csv/tab) or any work around so I get the same list of values as shown in my report?
Hi Henry, usually you get this kind of excel sheet when the main table is based upon name but the date and total come from a related (many side) table. Can this be possible in your case? If so, switch to the many side and place the Main::Name field on it. Another consideration if that doesn't help is that, when you export, you must check name in the Group By field (export dialog top right box) along with checking date. :smileyhappy:
Disclaimer: My suggestion is just a possiblity and there may be many others which might work or work better.
Thanks, I actually cracked it a few moment ago, by putting a portal on the page holding the field I wanted to always apear (name) solved the issue.
Thanks for you help.