Output of SSRS in XML format

Question

Post reply

Output of SSRS in XML format

jbalbo

SSCertifiable

Points: 7580
More actions
May 6, 2013 at 12:50 pm

#293597

Hi,
I got my sp TO WORK.. FINANLLY...
Now I wanted to schedule the report to run and email in XML format....
I want the remove some of below
and change the name of the tags from say Detail_Name to Name
Thanks
<?xml version="1.0" encoding="utf-8" ?>
- <Report xsi:schemaLocation="XML_test http://ucrpt01/ReportServer?%2FTest%2FXML_test&rs%3AFormat=XML&rs%3ASnapshot%3Aisnull=True&rc%3ASchema=True" Name="XML_test" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="XML_test">
<table1 />
</Report>

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Ray M SSC-Insane Points: 21093 More actions · Answer 1

Check out the DataElementName Property for each text box.

They are set to Auto by Default, Change the name here.

Nevermind, Didn't read your question. Hold Please

No I was right, Clicking on the Table, you can set this property.

By changing the names of the Row Groups it will change the element names.

and by changing this property on each textbox will control the element name.

jbalbo SSCertifiable Points: 7580 More actions · Answer 2

Hi Ray

Sorry I really didn't work it correctly

What I really want is just the data on the output

with tags

with no other stuff.......

If I could get it vertical even better(I Think)

etc..

Ray M SSC-Insane Points: 21093 More actions · Answer 3

jbalbo (5/6/2013)
Hi Ray
Sorry I really didn't work it correctly
What I really want is just the data on the output
with tags
<name>joe</name>
with no other stuff.......
If I could get it vertical even better(I Think)
<name>joe</name>
<name>mary</name>
etc..

Click off the report (In the Yellow) then look at that property and change the DataElement Style from Auto to Element

jbalbo SSCertifiable Points: 7580 More actions · Answer 4

I don't seem to have that option...

I RC > report Properties .. I have PAge Setup, Code References and Variables

Ray M SSC-Insane Points: 21093 More actions · Answer 5

In the properties Pane.

Left Click any part of the Yellow.

Look at the properties pane.

The Data only Section.

See image.

That will make all items element centric.

and you can control individual items by clicking on the Textbox they come from and change from Auto to Attribute, or Element.

jbalbo SSCertifiable Points: 7580 More actions · Answer 6

Thanks Ray...

I feel dumb.. I never use the property window........

I'm going to be back with more dumb questions about this.... soon

While I'm here is there a way to surpress the top line?

<?xml version="1.0" encoding="utf-8" ?>

- <Report xsi:schemaLocation="XML_test http://reportserver?%2FXML_test&rs%3AFormat=XML&rc%3ASchema=True" Name="XML_test" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="XML_test">

Thanks again

jbalbo SSCertifiable Points: 7580 More actions · Answer 7

jbalbo

SSCertifiable

Points: 7580

May 6, 2013 at 3:11 pm

#1612784

Can I Rename the <Detail> section?

Thanks

Ray M SSC-Insane Points: 21093 More actions · Answer 8

Yeah,

See image.

In the row groups section, RightClick -> Group Properties. Change the name to what you want.

davoscollective SSCertifiable Points: 6355 More actions · Answer 9

While I'm here is there a way to surpress the top line?
<?xml version="1.0" encoding="utf-8" ?>
- <Report xsi:schemaLocation="XML_test http://reportserver?%2FXML_test&rs%3AFormat=XML&rc%3ASchema=True" Name="XML_test" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="XML_test">

I don't think you should remove that.

Those lines are required as part of the XML standard.

The first part is declaring that the document is supposed to conform to the XML 1.0 standard. (whether it actually conforms or not is a separate issue).

The second part informs any XML parsing/reading application what schema to use to interpret the XML.

XML as a format is essentially designed so that you can make up your own tags. However, that requires an XML schema document that describes what all the tags are and how to interpret them, i.e. how to read the XML file.

All of this depends on what you plan to do with the XML file. If you are planning to send it to another application that will import it into another system then I would suggest you leave it. You also shouldn't worry about the formatting (you mentioned having the records "vertical") because an XML importer shouldn't care about that.

If on the other hand you are sending this to a person for them to read then I suggest XML is not the right format. It's not particularly friendly for humans to read.