I have a SQL RS report that I'm exporting into Excel. The export works and actually is exporting my GROUPS into separate Excel Worksheet Tabs. This is good, however I would like to be able give each TAB a distinct NAME based on the GROUP.
My Group is actually AGENTNAME, and so I would like the AGENT NAME to appear on each TAB when exported to Excel.
How can I accomplish this?