Databases Reference
In-Depth Information
Figure 13-5.
Selecting columns for display, using Column Groups
Figure 13-6.
Single row view, using Column Groups
Including Links
There are several ways to include links within a report: report link, column link, and a link created within
your query. To add a report link, you click Report Attributes and navigate to the Link region. From there,
you can either link to the single-row view, to a page within your application, or to a URL. Most reports
include an edit link that goes to a form based upon the main data, so a report link would be the logical
place to define that. One nice thing about report links is that they are always displayed within the report;
the column cannot be hidden using Select Columns.
Column links are a great way to link between reports. You edit the Column Attributes and scroll to
the Link region. Just as with the Report Link, you can link to a page or URL and pass column values from
your report as well as values within items in your application. I will add a derived column to my report
and use it to link to another report in the application—often referred to as a
drill-down
. Listing 13-4
shows the SQL generating the derived column.
