We are running BOE 4.1 SP6
We need to export a webi report into XML format. A sql script gathers the data
and in the script we are using the T_SQL command FOR XML to convert the result to XML.
In SQL Studio everythings work fine. I can copy the result, paste it in notepad, save it with the extension XML and it works.
When I schedule the WEBI report I use "plain text" as format , do not add the extension, but in the filename I add manually ".xml".
This also works correct. When I open the file I see XML, but the only problem that the file size is limited to 65kb. The data is truncated. How can I increase the file size?