Can one report generate dynamic number of charts?

  • I have a parameterized report that has office staff choose different "semesters" from a multi-value drop down, with the intention of displaying in multiple charts. Ive been looking for a way to have each multi-value parameter that the user chooses generate a separate chart.

    For example, user 1 chooses semesters 1, 3, and 5, thus generating a report with 3 separate charts.

    User 2 chooses only semesters 2 and 4, thus generating the report with just 2 charts. Each chart can easily have over 20 attributes, so I dont want to "stack" the parameters all on the same chart.

    Is this possible short of creating several reports in advance and somehow using the sub-reports control?

    Thanks in advance to any and all that even read this, let alone share some insight. 😀

  • You should be able to use the list report item and then drag the chart into the list item. The parameters would be feeding a dataset that would then be used as the source for the list and then the chart embedded in the list would get the necessary value from the list and the list will generate the number of reports based on the number of items in the datasource.

    ----------------------------------------------------------------------------------------
    Dan English - http://denglishbi.wordpress.com

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply