Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
XLS file is too large to open. Other options? CSV?
Migrateduser
Greetings,
I am using BIRT Report Engine 4.2 API to invoke the engine and generate reports from my web application. PDFs and XLS generate fine, however, the XLS file sizes are too large to open. (20-50MB) The reports can contain up to 60,000 rows of data, and I am assuming because of formatting- the resulting XLS are large, and therefore hard to open.
My first attempted fix was to simply create a plain grid, insert data without any formatting on the designer, and generate, but the resulting XLS files are still the same size.
Is there a way to configure the report or emitter to drop all formatting for XLS types? I am not truly sure why the XLS are so large anyways. I open them up in notepad and it contains serious amounts of hex values.
Is there a replacement emitter for 4.2 to generate cleaner and more efficent XLS files? (I haven't been able to implement any 3rd party emitters in 4.2 for using in the report engine API, perhaps there are better instructions out there I can't find?)
Ideally, I could simply install a CSV emitter and just be done with it, however I cannot seem to get the CSV emitter plugin working either for 4.2. The state of this contest project is unknown anyways.
What is the best option and approach to take? I also saw in BIRT there are CSV data extraction methods but that appears to only extract the data of a result set and not the entire contents of the report. Is that true, is this a possibility?
What is the best route to take my report and obtain a useable XLS or CSV file?
Thanks, Brian
Find more posts tagged with
Comments
There are no comments yet