Jump to content
Changes to the Jaspersoft community edition download ×

CSV Export not formatting correctly


puneet.040289

Recommended Posts

Hi Team,

We have some static text like report name and run by in Page Header section then we have a table component in the Group Header section to display data in tabular format.

The export works fine in PDF format however with CSV we can see some extra blank columns getting generated like below:

Can you please help me to resolve this issue.

    Test Report    
       Run Date:########
 NameLoginFirst NameLast Name Number Date Country 
sfdsafdfreykxcfgtyjkurtgerq nrhyreiumk 13235622-Feb-08   

 

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Looks like you're getting some unwanted content in csv output, probably from a page header or title band - look at the 'exclude' optoins in the jasper config reference:

http://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.export.{format}.exclude.origin.{suffix}.{arbitrary_name}

You can exclude items on a per format basis by key (remove on a per element basis) or band (remove entire band) for a specific format. The documentation is a little lacking but a simple google search will get you what you're looking for -

    <property name="net.sf.jasperreports.export.csv.exclude.origin.band.pageHeader" value="pageHeader"/>

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...