Crystal Reports  

Another Report Object Option

The Another Report Object option in the Hyperlink tab of the Format Editor lets you define a hyperlink path for linking objects in the same or different reports. If you are defining a hyperlink path to a different report, that report must be managed in BusinessObjects Enterprise. The CyrstalReportPartsViewer control displays only the objects you specify. Like the Report Part Drilldown Option, all destination objects must be from the same report section.

The Another Report Object option can also be used by the DHTML page viewer for navigation purposes.

Work Flow

Because the Another Report Object option allows you to create hyperlinks between objects in different reports managed in BusinessObjects Enterprise, it requires more set up on the Hyperlink tab. This is an overview of the steps you have to complete to set up your hyperlink successfully.

To create a Report Part Drilldown hyperlink

  1. Open your source and target reports.

    Your source report is the report you copy an object from; the target report is the report you add the hyperlink information to.

    When you view your target report in the Report Part Viewer, you first see its home object. When you drill down on that object, you go to the destination object you selected in the source report.

  2. In your source report, click the intended destination object and copy its name listed in the Name field of the Properties window (for example: Text1, Field1, Graph1, and so on)
  3. In your target report, right-click the intended home object and choose Format from its shortcut menu.
  4. In the Format Editor, click the Hyperlink tab, and then select the Another Report Object option.
  5. In the "Hyperlink information" area, click Paste Link.
    Note   The Paste Link button is unavailable if you have not copied a destination object as shown in step 2.
  6. The program pastes the identifying information from the destination object you selected in the source report into the appropriate fields.

    The Paste Link button includes a list of options that you can use when pasting a link to the destination object. Depending on the type of link you are creating (for example, a link to a specific data context rather than a link to a generic data context), you may see these options:

    • Context Report Part

      This is the default option; it is selected when you click Paste Link without viewing the other list options. Use this option to paste a link that includes the most complete data context that the program can determine. For more information, see Context Report Part Option Scenarios.

    • Design View Report Part

      Use this option to paste a link that includes a generic data context (that is, a data context that does not point to a specific record). Use this option when you want a broad data context, or when data is not yet present in your source report.

    • Preview Report Part

      Use this option to paste a link that includes a specific data context (that is, a data context that points to a specific record). Use this option when you want a narrow data context, or when data is present in your source report.

      Note   If you choose the Design View Report Part option (or if you choose the Context Report Part option for an object copied from a report's Design view) and your source and target reports have different data structures, you'll see the Report Part Map Fields dialog box. Each field in the Unmapped Fields area represents a group in your source report. Use this dialog box to map these groups to fields in your target report. When you've mapped all the groups, the OK button is available, and you can proceed.
  7. If you want to add other fields from the same section of the link to report, click the Object Name field and move the cursor to the end of the existing text. Enter a semi-colon (;) and then the name of the field(s).
  8. You can broaden your Data Context by using an asterisk (*) to represent all records in a group.

    For example, if your Data Context is /USA/CA/Changing Gears (which will show only that specific detail record), you could change it to /USA/CA/* to show all detail records within that group.

    Tip   If your report has a group selection formula, check the data context for your destination object to ensure it contains the correct child index.
  9. Click OK.

    You have established a hyperlink from your home object to a destination object or objects. In the Report Part Viewer, you would see the home object first, and when you clicked it for drill down, you would see the destination object(s).

See Also

Report Parts Overview | Data Context Formats