Dynamically Subreport Generation

[raysefo]

Hi,

 

Is it possible to have dynamically subreports according to a parameter?

 

I mean, if parameter is 1 then 1 subreport generated if 2 then 2 subreports generated and so on...

 

thanks

[svenn]

Is the content of the subreport dynamic or static?

[raysefo]

static data

[svenn]

This example is for Oracle. If your not using Oracle you will have to determine the equvalant table or in the end you can use any table in your database. Just make sure that it has enough records for this to work.

 

Put the following query in your subreport

 

SELECT ROWNUM

FROM ALL_OBJECTS

WHERE ROWNUM <= $P{number of loops}

 

Number of loops will control how many times your static text will appear in your report.

[raysefo]

how about dynamic data?

[svenn]

You have to experiment. I thing it would be possible. I've only done it with static text.