Report Solution Patterns and Recipes - Professional SQL Server 2005 Reporting Services - page 296

Figure 7-30 shows the rendered report with some region sections drilled open. I've clicked the pie icon
next to the Southwest region to synchronize the chart and view sales trend details for the Southwest
region. Again, note the background color fill behind the scorecard indicator images using the technique I
mentioned earlier.

Figure 7-30

Using Charts and Data Ranges in Detail Rows
Reporting Services doesn't support the placement of charts and some other embedded report items in
table detail rows. Working around this limitation is very easy and simply requires that a group be defined
at the detail row level. You can either delete the detail row or resize it. Detail-level items are placed in
the header row rather than the detail row. The following two sparkline chart examples will demonstrate
this technique.

What you'll need:

❑ A table presenting a columnar set of values.

❑ A chart item embedded into a table group header cell.