[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [Newsgroup Home]
[news.eclipse.birt] Dynamic sub-reports

Hello,

I would like to create a report that could be dynamically designed from a database. I have a list of first level sections and a list of sub-report linked to each section, both retrieved from a query. Each sub-report is generic and can be used for all first level sections. I can't use the drill down function because I generate a PDF document.

My first problem is that I can't link a true subreport template and choose what sub-report I would link depending on a parameter.
Then I tried to include all sub-reports ( from external libraries ) in the first level table and hide them to display only needed sub-reports. I have more than 50 different sub-reports but I only need to display 3 or 4 sub-reports in each section.
Unfortunately all sub-reports are computed even if they are set to not be visible. As I run quite big queries ( ~ 10 minutes each ), it's not acceptable to run all sub-reports.


Here is a sample of what I need :
________________________
Section 1
   - subreport A
   - subreport B
   - subreport C
   - subreport D
________________________
Section 2
   - subreport B
   - subreport D
   - subreport E
   - subreport F
   - subreport G
   - subreport H
   - subreport I
   - subreport J
________________________
Section 3
   - subreport A
   - subreport C
   - subreport E
   - subreport H
   - subreport J
________________________

..

Does anyone have any idea on how to do that ?

Thanks in advance.