I have a similar kind of requirement , where the user wants the excel report output in multiple tabs.I really dont know even if it's feasible using oracle reports builder.If anyone out there perfromed similar kind of operation or got any idea how it can be done please share it. Thanks in advance.
it cannot be done in Reports, but there are free solutions for PL/SQL available.
This is possible by creating XML output. You have to use the Microsoft Excel specific tags in places to create Excels with multiple tab.
I have a small demo where I have used 2 queries one from DEPT table other from the EMP table. I am unable to attach the files here in this forum, but if anybody is interested, I can share the RDF file and the process document.
Email me firstname.lastname@example.org