Skip to Content
0
Former Member
Nov 08, 2016 at 09:01 AM

Webi Export to xml

157 Views

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?