How to create Drill Down in Reports

[csharbel]

Hi

 

Can any of you tell me how we can create drill down in reports. That is clicking on one band in a report should open another report showing some detail pertaining to the band by passing some information to the opened report.

 

Regards,

Sharbel

[marianela]

I have the same question... Please can anyone help us??

Any help (an example, a tutorial...something) will be apreciate....

 

Regards....

Nelita ;)

[kgentile1010]

I did see some posts about creating a link on the row where you want to drill down -- the link will call a servlet (that you write). The servlet takes parameter information and then runs a new jasper report showing the next level for the drill down.

 

you can use Jasper Intelligence.

 

I also found an open source product OpenReports. This product supports drilldown. I'm looking at that for a solution.

 

http://www.oreports.com/

 

If you find anything else, please let me know.

 

thanks

 

Kim

[kgentile1010]

OK, so openreports works, but with overhead. Same with Jasper Intelligence, works, but you need to run a server. We're working on trying out the servlet solution, so let me know how it goes if you try it. I'll post here when we're done and let you know if it works.

[kgentile1010]

Hi,

 

So, we decided this was too much work to build and support using Jasper Reports. The final answer is you really need to build a tree control on top of the html (maybe using ajax).

 

So, at this point for the drill down/tree control we're looking for other solutions that aren't Jasper.

 

Sorry we didn't get something going here. :(