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.
» 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>