bbharat Posted December 2, 2008 Share Posted December 2, 2008 Does anyone knw how to create new tab with data from the same dataset used by first tab in XL reports?I want the same XL report to have 2 tabs of data coming from the same dataset.Thanks for your help ! Link to comment Share on other sites More sharing options...
bbharat Posted December 8, 2008 Author Share Posted December 8, 2008 any clues on this?Just wanna know if its possible to create multiple tabs in xls format report? Link to comment Share on other sites More sharing options...
C-Box Posted December 9, 2008 Share Posted December 9, 2008 Hi, Don't understand right - do you mean to export the report to XLS with multiple Sheets!?!??!?!?then you you should take a look at the JRSingleSheetXlsSaveContributor.Otherwise please describe a bit more in detail. hthC-Box Link to comment Share on other sites More sharing options...
bbharat Posted December 9, 2008 Author Share Posted December 9, 2008 Yes sir. I have one report template with various fields including a subreport.Now what I want is when I render this report, subreport should go to a new sheet in the same XLS report.So one XLS report with 2 sheets/tabs.thanks Link to comment Share on other sites More sharing options...
mtaylor Posted December 9, 2008 Share Posted December 9, 2008 Similar issue here:I have a master report that contains a subreport.Would like to display the subreport contents in one sheet, and the master report contents in another. Link to comment Share on other sites More sharing options...
rwchogue Posted December 9, 2008 Share Posted December 9, 2008 There is a Custom Property setting called "net.sf.jasperreports.export.xls.one.page.per.sheet". This will work as long as you long as you check the "Ignore Pagination" box under Report Properties. Link to comment Share on other sites More sharing options...
C-Box Posted December 10, 2008 Share Posted December 10, 2008 bbharatWrote: Yes sir. I have one report template with various fields including a subreport. Now what I want is when I render this report, subreport should go to a new sheet in the same XLS report. So one XLS report with 2 sheets/tabs. thanks Well, if you want to separate Master and SubReport in XLS file you'll need to change your layout in a matter that SubReport will start at a new page.(try to use a PageBreakElement within title, or use "TitleAtNewPage" attribute of SubReport) If you've reached that, you can use the mentioned JRSingleSheetXlsSaveContributor to export the report to XLS with each page as a new (excel)sheet/tab.But be aware, that if MasterReport has two pages, you'll get two (excel)sheets/tabs for that and also per SubReport-Page.A clear separating "Master- SubReport to Sheet" XLS-Export (where each single report has just one (excel)sheet) doesn't exist. (IMHO) regards from GermanyC-Box Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now