How do I use set_rptopt to output a specifc report to xml or csv. I can use $spool but this means creating a new report.
Have you had any luck with that? We're on PROIV 6.1 and I'm trying to use SET_RPTOPT to dynamically change the output of a report to excel (whether it be via XML or CSV it doesn't matter).
I kinda get it right if I change the Spooler options to Output Type "XML - to Screen" Client File "report.xls" but cannot get it to work using SET_RPTOPT. ProIV sent me the following code: SET_RPTOPT("CRT:OUTFMT=XEIZ", "11", "transform.xslt", "document.xls")” but no luck.
Another way might be use the Output Type "Screen with Delimited Output" but I also can't even get that to work smoothly using the Spooler Options let alone using SET_RPTOPT. The little documentation on SET_RPTOPT doesn't really help either.