How to make multiple reports with one report file?

[prileep1699955918]

Hi,

I am working on iReport 3.0.

Here I need to export my report to XLS format. In XLS output file the report should have multiple tabs(sheets).

But I cant figure out how to make using iReport.

For eg. I need to show all purchases and sales for a shop. All the purchases should be in the first page and all the sales should be listed in next page. Ie, When I export the report to XLS format, it should diplay all purchase information in first worksheet(tab) and sale information in second tab.

 

If you still not understood what I meant here, I would explain in another way also.

In Business Objects - Web intelligents there is a new report option, so with the same result set I can have multiple reports in a single file. If I export that to XLS it will show each report in each tab.

If you still need explanation with few sample files, please let me know.

 

Thanks

Prileep Mathan

[prileep1699955918]

Please let me know, if it is really not possible to do in iReport.

[marall80]

did  you find out the solution ?

tell me please

[Srikanth Kattam]

Hi,

It is very much doable in Ireport in just 2 steps:

1. Display All purchases related information in the first page and All sales related information in a new page.

I.e. use sub report for Sales related information and place it in main report's summary band. Now enable the main report property "Summary on a new Page" to 'True'.

With this, the Sales related data will always start from a new page of an executed report.

2. Now apply the following property to get this data in separate tabs of XLS:

net.sf.jasperreports.export.xls.one.page.per.sheet = "true".

 

let me know in case of any concerns.

 

Regards,

Srikanth Kattam