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.
Last edited by SkywOrca; 18th February 2013 at 04:27 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)