Jump to content

Avoid repeated column in jr:table export to CSV


hariharanwebmail

Recommended Posts

Hi,

I am using a jr:table in my report. When I export my report to CSV I am have repeated headers.

But I would like to have the table column header only once in my CSV and then the data. And I dont want to ignore pagination.

I was able to completely avoid the table headers in CSV by using the solution mentioned at

http://stackoverflow.com/questions/14229157/exclude-column-header-but-keep-first-from-a-table-component-on-csv-export-in-j

But I would like to have atleast one header so the user knows what data he is looking at in the CSV.

The documented values for {suffix} in net.sf.jasperreports.export.{format}.exclude.origin.keep.first.{suffix}.{arbitrary_name} doesnot tell how to refer a table column header.

Please let me know if this is possible ...

Thanks

Hari

Link to comment
Share on other sites

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

i have same problem with you,  i using this guide http://stackoverflow.com/questions/14229157/exclude-column-header-but-ke... but the result is no header, to resolve this problem, i combined step by step in   the article with empty table, yes, you create empty table just contain your header and put into real table, and next step right click in your real table and click "bring to front",note: size width every column(real table and empty table) must be same, i know this way is vey pain full, but it's work very well, your report still have paging in browser but if you download in csv format is no paging and have just one header, like do you want

Link to comment
Share on other sites

  • 9 months later...

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...