Yet Another Excel Worksheet Question

[cgriefer]

Hey all...

Currently have a report that works fine... we're ordering by a particular column and grouping in the JRXML and the Excel file shows 3 tabs. Let's say for the sake of argument, it's broken down as:

Tab 1: "Dogs"
Tab 2: "Cats"
Tab 3: "Birds"

Awesome. Works a treat. 

We'd like to potentially show a 4th tab that has all of the records, not grouped. So each record would appear once (in either Tab 1 or Tab 2 or Tab 3), and then a second time in the 4th "All Animals" tab. 

Can this be done?

Thanks!
Charlie

[jo.jasmine]

Yes. Let Tab 4 be a another subreport (new jasper report) with the same query without groupby.

Then combine the subreport to the mainreport and make it to display at tab 4.