Exporting Reports with Total Group By

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

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

• Custom Export
• Using Total Group Options in Report Builder