| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | ms.custom | |
|---|---|---|---|---|---|---|---|---|---|
Align the data in a paginated report chart in a table or matrix |
Discover uses for paginated report sparklines and data bars in Report Builder. These small, simple charts convey information with the minimum amount of detail. |
kfollis |
kfollis |
09/25/2024 |
reporting-services |
report-design |
how-to |
|
[!INCLUDEssrs-appliesto] [!INCLUDE ssrs-appliesto-ssrs-rb] [!INCLUDE ssrs-appliesto-pbi-rb] [!INCLUDE ssrb-applies-to-ssdt-yes]
Sparklines and data bars are small, simple charts that convey information with little extraneous detail in a paginated report. In a paginated report, when you check this option, the values in your sparklines and data bars align across the different cells in the table or matrix. They align even if there are missing values in the data they're based on.
:::image type="content" source="../../reporting-services/report-design/media/rs-sparklinealigndata.gif" alt-text="Screenshot of sparklines and data bars in a table.":::
In this image, the column chart shows daily sales for each employee. For days that an employee has no sales, the chart leaves a blank and aligns subsequent days horizontally. It also aligns the charts vertically by making the sizes of the different charts relative to each other. For more information, see Sparklines and data bars (Report Builder).
-
Add a sparkline or data bar to a table or matrix.
-
Select the sparkline or data bar, and then choose Horizontal Axis Properties or Vertical Axis Properties.
-
On the Axis Options tab, check the Align axes in box, and then in the list box, select the group on which to align the axis.
-
Select OK.