Search results

Databar

Data bars are small, simple charts which can be used for showing trends and changes in data over time, especially over many periods. They convey a lot of information in a little space, often used in table and matrices.

Add databar to the report

  1. The databar report item is listed in the item panel under the KPI category. Databar item in item panel
  2. Drag and drop the databar report item into the design area or inside tablix cell from the item panel. Drag and drop databar report item into design area
  3. After dropping the databar item in the design area or inside tablix cell, the respective item properties will be listed in the properties panel. Databar item with properties view

Create data

To present data in the databar, create a dataset and bind data to it. In this designing section, the following dataset query is used for dataset creation.

SELECT PC.Name AS ProdCat, PS.Name AS SubCat, DATEPART(yy, SOH.OrderDate) AS OrderYear, 'Q' + DATENAME(qq, SOH.OrderDate) AS OrderQtr,SUM(SOD.UnitPrice * SOD.OrderQty) AS Sales
FROM Production.ProductSubcategory PS INNER JOIN
Sales.SalesOrderHeader SOH INNER JOIN
Sales.SalesOrderDetail SOD ON SOH.SalesOrderID = SOD.SalesOrderID INNER JOIN
Production.Product P ON SOD.ProductID = P.ProductID ON PS.ProductSubcategoryID = P.ProductSubcategoryID INNER JOIN
Production.ProductCategory PC ON PS.ProductCategoryID = PC.ProductCategoryID
GROUP BY DATEPART(yy, SOH.OrderDate), PC.Name, PS.Name, 'Q' + DATENAME(qq, SOH.OrderDate), PS.ProductSubcategoryID

Refer Create Data section and create dataset using the above query. AdventuresWorks database is used here.

Assign data

Databar needs a minimum of 1 value element to showcase data. The measure or expression field that you would like to analyze can be dropped into Y Values section. The dimension that you would like to categorize the measure, can be dropped onto Columns section. If you would like to categorize based on a series, then the respective dimension can be dropped onto Rows section in addition.

To configure data into databar follow the below steps:

  1. To bind data to a databar report item, focus on that report item.
  2. Click Properties icon in the configuration panel, the property pane opens. Now, switch to DATA tab. Chart properties pane
  3. The available data in the report will be listed in the drop-down, choose a data in the drop-down list. Choose the dataset for chart
  4. The numeric columns and numeric expressions are listed under the Measures section; other type of columns and dimension expressions are listed under the Dimensions section. Measures and dimensions
  5. Drag and Drop Measure Element: Select and drag the numeric column (measure element) or the numeric expression column from the Measure section and drop it in the Y Values section. Add a Y-value field Now, the report item design will look like below: Preview after adding y-value field
  6. Aggregate Options: Click the Settings icon (highlighted below) to open the aggregation type drop-down list. Aggregate settings icon You can set the aggregation type by which you can compute the selected column. Aggregate menu list
  7. Drag and Drop Dimension Element: Select and drag the dimension element from the Dimensions section to measure against any of the selected numeric column(s) in Y Value(s) section, and drop into the Column(s) section.
    Add dimension field Now, the report item design will look like below: Preview after adding dimension field
  8. Grouping: You can group the added column element with another column, by adding the respective dimension element into Row(s) section. Achieve grouping by row values Now, the report item design will look like below. Preview of row value grouping

Properties

Refer to the Properties panel section before proceeding with the following properties.

General Settings

Name property

Name

Name property can be used to provide an unique name to the databar item in the report.

Basic Settings

Chart Basic settings

Note: The properties under basic setting will be enabled in the chart properties panel, after assigning the data to the chart.

Chart Type

Supported databar types will be listed in the Chart Type property dropdown, you can switch the required databar type based on the data.

Chart Types

Choose Series

You can add multiple series to the chart and the available series will be listed in the Choose Series drop-down. To customize the series appearance choose the required series name in the drop-down.

Choose series

Show Marker

Data markers are used to provide information about the data point to the user. You can add a shape and label to adorn each data point. To set/reset marker properties, refer Show Marker property.

The marker properties will be applied to the selected series in the Choose Series drop-down.

Show Data Label

Data label can be added to a chart series by using the Show Data Label property. The labels appear at the top of the data point, by default. To set/reset data label properties, refer Show Data Label property.

Chart data label

The data label properties will be applied to the selected series in the Choose Series drop-down.

Enable Smart Label

Smart labels manage overlapping of labels even when a large number of labels are placed in close vicinity. To set/reset smart label properties, refer Enable Smart Label property.

Chart smart label

To apply smart label properties, enable Data Label for chart data region.

Series Border

Series border properties can be used to customize the chart series border in the design.

Format chart series border

In the below design, border color, width and style properties are applied to the chart series.

Chart series border design

The series border properties will be applied to the selected series in the Choose Series drop-down.

You can also set properties based on dynamic values, by using the Expressions. Refer Set Expression and Reset Expression section to open set/reset expression menu in properties panel.

Dynamic chart series border

Series Color

Series Color property can be used to customize the series colors in the chart area. If the chart has multiple series, you can differentiate the series using this property.

Choose series in the Choose Series drop-down and choose color in Series Color property palette. Now, the selected color will be applied to the respective series in the chart design.

Chart series color

You can also apply series color based on dynamic values, by using the Expressions. Refer Set Expressions and Reset Expressions section to open set/reset expression menu in properties panel.

Link To

You can configure Hyperlink or a Report path in the chart series to create an interactive report. Refer Linking section to set or reset link property for chart series.

Link To property

Appearance

The border style, color, width and background color properties can be used to style the chart and customize its appearance in the report design. These properties are listed under the Appearance category in the properties panel.

Chart appearance

Chart Area

Chart Area properties such as border width, color, and background color can be used to customize the area of the chart design. These properties are listed under Chart Area category.

Chart Area

Page break

The page break property can be used to control the amount of information on each page when you preview the report. Follow the below steps to apply page break property for databar report item.

  1. The Break Location property specifies where the page break should occur. Choose any Break Location type in the drop-down. Break location
  2. To restart the page numbering on each page, enable Page Number Reset property checkbox. Reset page number
  3. The PageName property specifies a page id for the new page that the page break causes. You can specify a static text or dynamic expression to this property.

Position

Position property is used to set the width, height, left and top position of the databar in the report design. To handle these properties using properties panel refer Position section.

Chart postion

Visibility

The visibility property is used to conditionally show or hide the databar report item on report preview or export action. To set visibility of databar item using properties panel, refer to the Visibility section.

Chart visibility

Miscellaneous

Custom Attributes

This property can be used to set the values for chart custom properties. To assign values for custom properties using properties panel refer Custom Properties section.

Set expression

An expression can be set to few properties of the databar report item to process the property values based on expressions. To set expressions to the databar report item properties, refer to the Set Expression section.

Reset expression

To Reset the expression applied to a property, refer to the Reset Expression section.

Advanced properties

A few properties of the databar report item contains nested properties. To open and handle the nested properties, refer to the Advanced Properties section.