Progresso SSRS Render
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:
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.
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.