Databases Reference
In-Depth Information
Displaying data with sparklines, maps, data
bars, and indicators
Using dashboards to display data so that decision makers can easily get a good
picture of what is happening very quickly has become very popular. For example,
during election time most of the television networks come up with a dashboard,
a map of a state or states to display how a particular party is doing.
The various gadgets, some of them in this chapter and the others in the previous
edition, serves the purpose of highlighting information so that you can very quickly
review the status of a particular entity.
Data bars are graphical elements you add to display data that makes it more attractive
and appealing. You can use them very effectively in tables; they can represent multiple
data points but in the hands-on exercise you will be implementing only one.
Hands-on exercise 5.8 - creating a report and
highlighting data with data bars
Following are the steps to highlight data with data bars:
1.
Launch Report Builder to create a blank report.
2.
Add a data source connecting to the SQL Server 2012
Northwind
database
making an embedded connection.
3.
Create an embedded dataset by running the following SQL statement
in the
Query
window:
SELECT OrderID, Sum (UnitPrice*Quantity) as 'Total amount'
FROM [Order Details]
WHERE OrderID <= '10262'
GROUP BY OrderID
The
Dataset1
(default name) will be added with two fields:
OrderID
and
Total_amount
.
4. Insert a table on to the design pane. A 3 x 2 table will be inserted.
5. Drag fields from
Dataset1
and place them in the first two cells.
Search WWH ::
Custom Search