Promote a report column to a hierarchy


1. Overview

This article shows you how to promote or replace a column with a full hierarchy in a report or scorecard.

2. Walkthrough

First, create a new report from the main menu.

Drag the ProductID column from the [Sales].[SalesOrderDetail] table to the report grouping area (drop a column or hierarchy here...).

Also drag the ProductID column to the report body area; it will appear as a data label.

Initial report design
Initial report design

If you switch to View mode now, the report will display a list of product IDs which isn't very useful.

To promote this column to a hierarchy, simply drag a Product hierarchy from the Explore window and drop it onto the ProductID column in the grouping area.

Replace column with a hierarchy
Replace column with a hierarchy

Switch to View mode to see the report. Observe that the data label displays product names instead of IDs.

View the report
View the report

3. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri