[Serco] Progresso SSRS Render

[bcdobbs]

Hi,

I was wondering if anyone who has made the switch to Progresso can confirm/try something for me.

If you write a simple table report (ideally with no parameters) in SSRS can you pass an URL parameter to have it render direct to XML?

Eg something along the lines of:

http://myserver/ReportServer?MyRepor...&rs:Format=XML

I have a few automatic routines set up in excel that currently run straight via an SQL connection into Facility, but my understanding is that a direct SQL query to a hosted Progresso install won't be an option.

Kind regards

Ben

[SkywOrca]

I believe so, not tested this myself but this link would seem to suggest that you can simply include "&rs:Format=XML" to the parameter list and it will export the report directly to xml.

Edit: This link contains a host of useful URL access parameters, for reference. Note this is for SQL 2012, and Progresso currently runs on 2008R2, but the list should be largely correct.