Link to home
Start Free TrialLog in
Avatar of KANEDA 0149
KANEDA 0149Flag for United States of America

asked on

SSRS Change XML Data Tags in Report Output

I have created a report from a stored procedure query that works fine.  This report is published to our report server and the 2nd piece I would like to incorporate is the option to export completed report as an XML format.

The challenge is change the XML tags to something custom.  In the screenshot shown below, this is the XML output from my SSRS report but I need it in the 2nd screenshot shown just below it.  I have also attached the 2 different XML samples.

For example;
» change <Report xsl:schemaLocation...> to <Bonaire> (hardcoded)
» change <table2> to <RevportHeader FileDate=...> (hardcoded)
» change <Detail Collection> to <RevportBody DataType="AccountData"> (hardcoded)
» change <Detail> to <AccountData> (hardcoded)
» change </Detail_Collection> to </RevportBody> (hardcoded)
» change </table2> to <RevportTrailer DataType="AccountData" RecordCount="13"> (hardcoded except the record count, that would be dynamic based on the number of rows from the report)
» lastly change </Report> to </Bonaire>

User generated imageXML-SSRS-Output.xml
XML-Expected-Output.xml
ASKER CERTIFIED SOLUTION
Avatar of Russell Fox
Russell Fox
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of KANEDA 0149

ASKER

Darn... thanks Russell Fox!