Post reply

how to display XML data in reporting services

  • January 10, 2006 at 3:06 pm

    #112139

    I am writing a simple report in Reporting Services that displays data extracted from a single table. One of the table columns contains XML data, ie including tags, stored as a 'text' data type.

    The problem is that the data is displayed as plain text rather than formatted XML. I would like to be able to render the XML data in the same type of hierarchical view that can be seen when viewing XML data via IE - rather than being able to see all of the XML tags - so that it is readable.

    I have only been using reporting Services for about a week - so apologies for any newbie-like oversight! Any suggestions gratefully accepted - thanks.

  • January 11, 2006 at 10:28 am

    #614119

    Rather then the HTML view being your default rendered output for this report you might want to change it to have XML be your default output...


    Moe C

  • January 11, 2006 at 3:19 pm

    #614204

    Hi Moe and thanks for the reply.

    How is the default output type changed to XML for reports? Is this the same as exporting to XML via Report Manager?

    I have tried exporting the report to XML via Report Manager, but the XML tags are still visible. Note that the XML data is stored in the database table as 'raw XML' - i.e. these XML tags are not added by Report Manager during export. The result is an XML file with the original XML tagged data from the table visible in its 'raw' form, contained inside the XML tags created during export - i.e. only the XML tags created during export are interpreted by the browser, and the original XML data is interpreted as text...

    Thanks

  • January 11, 2006 at 3:37 pm

    #614208

    If the field in the db is set to text all Reporting services is going to do is pump out what ever text is in that field... but my guess is that you want the HTML rendered view with the XML to be outputed properly out on the page... try creating a subreport for that one field and have that render out in XML while the main report is rendered out in HTML... but i think still you will get the raw XML cause its stored as text... this is a tough one no doubt

     

    M.C


    Moe C

  • January 11, 2006 at 4:14 pm

    #614212

    Can the output format be configured in Report Designer or only in Report Manager (ie when exporting)? If configured in Report Designer, can the subreport be formatted differently from the parent report?

    I've spent a fair bit of time researching this on the net...as you say, its a tough one!

  • January 11, 2006 at 5:11 pm

    #614217

    http://msdn2.microsoft.com/en-us/library/ms186516.aspx 

    http://msdn.microsoft.com/msdnmag/issues/05/02/CustomRenderers/

    (read the part that says Rendering a Report Object section in green)

    I think you are in luck... let me know if this helps...


    Moe C

  • January 11, 2006 at 5:22 pm

    #614218

    On that textbox inside the the RDL file right click and hit properties... after that go to advance.. from there go to the data output tab...

     

    PS... IM me on MSN if you need any further assistance... thanks


    Moe C

  • January 12, 2006 at 11:22 am

    #614454

    So did the solution above work for you???


    Moe C

  • January 12, 2006 at 12:14 pm

    #614463

    I haven't been able to try out the solution yet, as i was busy with other work...but will try to check it out today. Thanks for your help with this - i'll let you know how i get on

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

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