How to produce a report of unpredicted number of charts

[lucky7456969]

Say I can make sub-reports and datasets of a certain number

by pre-creating them. But what if I can't predict how many number of charts are needed in advance

Say the user will input a range of dates, for example, from january 2011 to feburary 2013

or june 2012 to November 2013, there can be a product breakdown for each month

So how can I make such reports?

Thanks

Jack

 

[nicolaifriis]

1) Create a chart in a sub-report taking year/month as input parameter

2) Put the sub-report in the detail band of the main report

3) Write a SQL in the main report that returns one row for each month/year. For example a group by on year,month in your data or be creative where to get the dates :)

4) Use the year and month fields as input to the sub-report

You will now get one chart for each row (year/month) in the detail band.