4. Use the following Hyperlink, and set the Target to Self:
"javascript:alert('" + row["SALES"] + "');"
Chapter 9
[ 215 ]
When we go back to preview the report, we can click on any of the slices, and have
our pop-up alert telling us the actual values behind the percentages. We can also see
that our values have changed to percentages, and our pie chart slices have
been exploded.
Charts, Hyperlinks, and Drill-Downs
[ 216 ]
Gauge Chart
With the next Chart??”the Gauge Chart??”we will expand on the interactivity a bit,
and demonstrate how Drill-Downs work. We want the user to be able to click on a
Chart, and have it pull up an external report with the details for a particular user.
This is called a Drill-Down.
The following Chart will demonstrate an employee's sales versus a target amount
per month??”let's say 3000, on a 5000 dollar scale. This will be broken up and grouped
monthly in the query statement. When the user clicks on the chart, it will bring them
to the detail report that we created in the last chapter for Employee sales.
1. Create a new report called Employee_Sales_Gauge.rptdesign for the Classic
Cars - With Library project.
2. From the ClassicCarsLibrary.rptlibrary, drag the Data Source dsClassicCars
over to the Report Design.
3. Create a new Data Set called employeeSales using the following query:
select
CLASSICMODELS.
Pages:
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176