Charts, Hyperlinks, and Drill-Downs
[ 232 ]
21. Add in any formatting that you feel might spruce up the look of your report.
We discussed various formatting options in Chapter 8.
22. Select the OrderDate Grouping's Header Row. It is the one with the
OrderDate in silver in the previous figure. Select the Bookmark tab under
the Property Editor. Use the following expression for the bookmark:
importPackage(java.text);
var dateFormater = new SimpleDateFormat("yyyy-MM");
row["EMPLOYEENUMBER"] + dateFormater.format(row["ORDERDATE"]);
Chapter 9
[ 233 ]
23. Double-click on the Chart to enter the Chart Editor. Select the Format
Chart tab.
24. Select Series|Value (Y) Series, and click on the Interactivity button. Select
Mouse Click as Event, and Hyperlink as Action.
25. Click on the Edit base URL... button. In the Hyperlink Dialog, select Internal
Bookmark as the type. Select the following from the drop-down:
importPackage(java.text);
var dateFormater = new SimpleDateFormat("yyyy-MM");
row["EMPLOYEENUMBER"] + dateFormater.format(row["ORDERDATE"]);
26. Click OK, Save, and Run the report.
Now, when you click on any of the different colored sections of the Bar Chart, it will
bring you to the detail section within your own report with the grouped date section.
Summary
In this chapter, we have seen how to create several different Chart types.
Pages:
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184