Chapter 12. Making a Difference – Reports with Hyperlinks and Sparklines

In this chapter we will see how to create and configure Hyperlinks. Hyperlinks give us great flexibility in designing our reports, as they let us drill down (see Detail section). Using Hyperlinks, we can create a network of reports and also re-use reports.

Here we will also see a very interesting object that we can add to our reports, which will present specific information graphically: the sparkline.

In this chapter we will do the following:

  • Create and configure a Hyperlink on a text-field object
  • Create and configure a Hyperlink on each portion of a pie chart
  • Create and configure a bar-type sparkline
  • Create and configure a line-type sparkline

Finally, we propose that you modify the report we create in this chapter and add a pie-type sparkline.

Starting practice

In this chapter we will copy a report we created earlier and modify it step-by-step so that it ends up looking like the following screenshot:

Starting practice

This report will have the feature that, when we click on the name of a country, a new report will open with more detailed information about that country. We will also configure the pie chart so that when we click on one of its areas, a report will open with more information about the selected item.

In the report detail, we will add two sparklines that will analyze the payment history tendency of each client.

First we will talk about hyperlinks, then about sparklines.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset