A report that Outputs as XML

• sonny.powsey

  SSC Veteran

  Points: 277

  More actions

  September 28, 2011 at 3:36 am

  #244594

  I hope this is the right the forum, as this is more a reporting services thing,

  Basically I want a report to output as xml,

  so when that when run the report is run

  I get an xml file output to my browser

• Yuri55

  SSCrazy Eights

  Points: 8449

  More actions

  September 28, 2011 at 8:45 am

  #1387819

  You can Export report into XML file after it was created

• sonny.powsey

  SSC Veteran

  Points: 277

  More actions

  September 28, 2011 at 9:07 am

  #1387840

  I am trying to "render" the report as xml

  i have tried doing this

  http://sqlserver/reportserver?%2fReports%2fMyreport&ref=21599fh&rs%%5Bb%5D3aFormat=XML%5B/b%5D

  but I get a dialoge asking me if i want to open or save the xml fil

  not quite what i wanted but closer than i was earlier

• sonny.powsey

  SSC Veteran

  Points: 277

  More actions

  September 28, 2011 at 9:34 am

  #1387860

  adding this on the end is working slightly better

  [Code]

  &rs:Command=render%20&rs:format%20=xml

  [/code]