Detail grouping organizes data from a data set in groups by a detail grouping value. Applying a detail grouping to a sparkline helps to visualize data more clearly – the sparkline value is displayed as a set of sparklines grouped by a detail grouping value, thus providing more detail on the trend of the analyzed data.
Before adding a sparkline to your report, you must connect your report to a data source (e.g. ReelsDataSource.rdsx) and a data set (e.g. Media). The sample data source ReelsDataSource.rdsx is included with this installation.
- From the toolbox, drag a Table item onto the body of your report.
- With the table selected:
- Set the DataSetName property to Media.
- Right-click the table handle to the left of the Detail row and select Insert Row Below or Insert Row Above from the menu. As a result, another Detail row will be added to the table.
- Hover your mouse over the Textbox located in the Detail row column to make the Field Selection Adorner appear. Click on this adorner to display a list of available fields from the Media data set, select MediaTypeName from this context menu.
 |
Note: This automatically places an expression in the detail row and simultaneously places a static label Media Type Name in the header row of the same column. |
- To optionally display the label Media Type Name in bold and at the center of the page:
- Select the Header row by clicking the table handle to the left of the row.
- In the Report Formatting tool bar, click the Bold and Justify Center buttons.
3. From the toolbox, drag a Sparkline item to the second detail row of the table on your report.
4. With the sparkline selected:
- Set the Sparkline Type property to Line (by default).
- Set the DataSetName property to a data set (e.g. Media).
- Set the SeriesValue property by selecting <Expression...>. In the Expression Editor under Fields, expand the Fields (Media) node and select a numeric field from the connected data set (e.g. =Fields!ExtPrice.Value). Click the OK button to accept the change.
- Set the LineColor property to Gray.
- Set the MarkerColor property to Blue.
5. To apply the detail grouping to your sparkline, right-click the Table item and go to Properties/Detail
grouping.
6. On the Detail Grouping page under Group on, select an expression from the drop-down list by which
to group the data (e.g. =Fields!MediaTypeName.Value).
7. Click the Accept button to accept the change.
8. Go to the Preview tab to view the sparkline you have added to your report.
This set of sparklines displays the movies sales grouped by media type.
