Nevron Vision for SQL Server Reporting Services
The Chart Visual Interface

At report design time, Nevron Chart for Reporting Services appears as a report item in the Report Items section of the Toolbox. It is represented by this icon:

Adorner Panels and Drag and Drop

When you drag and drop the chart in the report design surface, it will initially display an empty chart with three adorner panels - for the chart values, categories and series data groupings:

You can drop fields from the report data set on these adorner panels. You will typically drop measurement fields in the values adorner panel and dimension fields in the categories adorner panel.

All charting types will require you to drop at least one value and one category field.

You can drop fields by which values are grouped in the series adorner panel. With minor exceptions (such as the Grid and Mesh surface charting types) this operation is optional. The Chart Data Model topic explains in detail the meaning of the values, categories and series data groupings in the context of Nevron Chart for Reporting Services.

Lets assume that we have a simple data set with the following fields: company, region, sales and and profit. If you drop the company in the categories adorner panel and the sales and profit fields in the values adorner panel the chart report item will look like this:

For each field that you drop the chart will create a certain type of data grouping, depending on the adorner panel on which you dropped that field. Each data grouping is represented by a card in the respective data grouping adorner panel.

The category and series data grouping cards are identical. Their header is the name of the data grouping. Nevron Chart for Reporting Services will automatically construct an unique name for the data grouping (see the Category and Series Data Grouping for more info about automatic data grouping naming). The items in a category/series data grouping card are the expressions on which you group data. By default when you drag and drop a field in the category/series adorner panels the created data grouping will have only one grouping expression - by the field value.

In the example, for the dropped company field, the category data grouping has a name: nChart1_company and a single group expression: =Fields!company.Value.

Values data groupings represent chart series. Depending on whether there are any series data groupings, a single values data grouping produces one or more chart series. The header of the values data grouping cards is the label of the values data grouping. The items in the values data grouping card are the [data series:expression] pairs that the current charting type supports for this values data grouping. It is important to know that the expression is stored in the data cell associated with values data grouping (see The Chart Data Model topic for more info). The [data series:expression] pairs will be automatically updated when you change the charting type. Located in the left-top corner is an icon, which provides you with a hint about the chart series type, which is currently used to display the values data grouping.

In the example, for the dropped sales field, the values data grouping has a static label sales, it is represented by a bar series, the Value of each bar is obtained from the result of the =Sum(Fields!sales.Value) expression (for each evaluated data cell) and the Label string for the bars is not specified.

You can drop fields on existing card items to replace the expression used by this item.
Chart Report Item Properties

If no card is selected in the adorner panels, you can show the chart report item properties dialog by right clicking on the report item and choosing the Properties command.

The Chart Properties Dialog is constructed by hierarchically organized tabs and has a preview of the chart located on top. Changes to the actual chart report item are not applied until you press the Apply or OK buttons located at the right bottom side of the dialog.

The Chart Properties Dialog consists of the following major tabs:

Category/Series Data Grouping Properties

The property editors of the category and series data groupings are identical. They can be shown in two ways:

The category/series data groupings editor is illustrated by the following image:

See the Category and Series Data Grouping topic for a complete description of the settings.

Values Data Grouping Properties

The values data grouping editor can be shown in two ways:

The values data groupings editor is illustrated by the following image:

See the Values Data Groupings topic for a complete description of the settings.

See Also

 

 


©2016. Nevron Software LLC.

Send Feedback