Home Forums Reporting Services Reporting Services how to: make a multiple chart report, each chart to show different views of the same dataset?<!-- 864 --><!-- 864 --> RE: how to: make a multiple chart report, each chart to show different views of the same dataset?<!-- 864 --><!-- 864 --><!-- 864 -->

  • Since you are returning everything in one data set you need to use filters on the tablii. Here's an article on filters that should get you started.

    For data region 1 you do want a table type control.

    For data regions 2-4 I'd use a matrix and I'd fill out my data set so that it always contains all 12 months with either NULL or 0 in the numeric columns depending on what the business wants to see.