View source for Exporting Reports with Total Group By

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

[[File:ExportTotalGroupBy.PNG]]

Within the Detail section, wrap the Total Group By fieldss within a new row wrapped within '''<ssTotalTag> </ssTotalTag>'''. <br />
(''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==
* [[Custom Export]]
* [[Using Total Group Options in Report Builder]]


[[Category:Reports]]