Exporting Reports with Total Group By

When exporting to Excel a report configured using Total Group By you must use the Custom Export:

ExportTotalGroupBy.PNG

Within the Detail section, wrap the Total Group By fieldss within a new row wrapped within <ssTotalTag> </ssTotalTag>.
(Note: In the example provided above, the Display Total Label is blank which is resulting in the label in the Custom Export displaying as @@)


After the ssTotalTags, add <ssTotalHeader> </ssTotalHeader> to the end of the Detail section. This will allow for the Total Group By headers to display.

See Also