nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Data is not exported to Excel properly

lrnrit

Hi all,

i am using cube in my report , It shows proper out put in HTML format but while expoting it to excel data gets courrupted (only few colums **** and rest goes missing).

It happenin mainly while using multiple group levels for defining columns.

Any help is Appreciated.

birt version is 3.7.2

excel emitter is (birt.report.engine.emitter.nativexls_1.0.0.201110041045)

lrnit

Find more posts tagged with

Comments

lrnrit

mwilliams

Can you recreate this issue, using the sample database or with a flat file of data, so I can see it?

Yaytay

<blockquote class='ipsBlockquote' data-author="'lrnrit'" data-cid="108827" data-time="1345819564" data-date="24 August 2012 - 07:46 AM">
i am using cube in my report , It shows proper out put in HTML format but while expoting it to excel data gets courrupted (only few colums **** and rest goes missing). </blockquote>
This often happens with the built in emitter if the extra columns wouldn't fit on the page size defined for the report - i.e. you ge the same columns output in Excel as you would in PDF. 
The easy way to check this with the built-in emitter is to make the page size huge (I think 10m wide is the limit). 
 
Alternatively, try a different emitter: <a class='bbc_url' href='http://www.spudsoft.co.uk/2011/10/the-spudsoft-birt-excel-emitters/'>http://www.spudsoft.co.uk/2011/10/the-spudsoft-birt-excel-emitters/</a> 
 
Jim