[news.eclipse.birt] Re: Dynamic sub-reports

[Jason Weathersby <jasonweathersby@xxxxxxxxxx>]

Manu,

Drill through does support pdf.  In the hyperlink builder look at step 5.

Another option is to drop the subreports instead of hiding them.  If you 
drop them they will not be executed.  You will need to do this in the 
beforeFactory event.  Just name each one and in the beforeFactory event 
drop them like:

reportContext.getDesignHandle().findElement("mysubtable").drop();

Jason


Manu D. wrote:
> 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.