Hi SunSystems Community!
I’m trying to generate an XML file output from a report similar to Account Listing (FTAL1) using an XSL transformation.
Here’s what I’ve done:
- Set the XSL Transformation file under Report Properties
- Set runXSLTransformation and outputToFileSystem parameters to True
- Stored the .xsl file in the same folder in Report Manager as the main report
When I run the report, no output file is created.
Using the exact same setup on a different report (for example, a payment document or sales invoice) works perfectly—the transformed file is generated as expected.
Further testing showed that the transformed output is produced for FTAL1 if the report is executed via a Control Desk process.
Could anyone clarify this behaviour?
- Is this a known limitation or the way Report Manager handles the Transformed Output?
- Is there any workaround to enable XSL transformation output when running the report directly?
Running it via Control Desk isn’t ideal, as it’s already a heavy report and adding that layer slows things down even more. Also, the data extracted by Control Desk is completely unrelated to what’s in the report, yet that’s the only way I can get the transformed output to generate.
Any insights or suggestions would be appreciated.