Avatar of KANEDA 0149
KANEDA 0149
Flag 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>

Example screenshot of XML filesXML-SSRS-Output.xml
XML-Expected-Output.xml
SSRSXML

Avatar of undefined
Last Comment
KANEDA 0149

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Russell Fox

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
KANEDA 0149

ASKER
Darn... thanks Russell Fox!
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck