Questions regarding table element in Jaspersoft Studio

[pfiesta]

Hi!

I have some questions regarding the table element in Jaspersoft Studio.

1. Which band in the main report do you usually put the table element? In my case, I used the table element to show all the data so that the user can sort the columns by themselves. I tried putting it in the detail band, and it bomb out my report. Right now, I did it on the summary band.

2. How do you export data from the table element to an excel/csv file without the repeating headers? When I was exporting the report to an excel file, my excel file was empty. So I tried exporting it to a csv file, and although the data is there, the columns are kinda messed up, and it is repeating.

It would be awesome if there is a solution for this.

Thanks!

Philip