How to Link Reports in Business Objects
Business Objects is an advanced analytical tool from global business technology leader SAP. It provides business intelligence that includes comprehensive reporting capabilities that help executives make more informed decisions. The "openDocument" feature allows users to create contextual links between Crystal reports, OLAP Intelligence reports and Web Intelligence documents, notes SAP. Once these links have been created, users follow the resulting navigational paths embedded in the linked documents. This feature enables users to invoke Business Objects and Web Intelligence documents from Crystal Reports and vice versa.
Instructions
-
-
1
Create hyperlinks in Crystal reports using "openDocument." Select the Hyperlink tab of the Format Editor field. Open the source report in Crystal reports. Right-click the field in which you want to insert the "openDocument" link and select Format from the shortcut menu. In the Format Editor, select the Hyperlink tab. Select a website on the Internet. In the "Hyperlink information" area, leave the Website Address field empty and click the Format Formula Editor button. Enter the "openDocument" link in the following format:
"http://[openDocument parameters]"+{Article_lookup.Family_name}
Where [openDocument parameters] are described in OpenDocument parameters, and the {Article_lookup.Family_name} enables the report to pass context-dependent data.
Test the link in a browser window before inserting it into a report or document. Click "Save and Close" to leave the Formula Workshop. Click "OK" in the Formula Editor to save the link.
-
2
Create hyperlinks in OLAP Intelligence reports using "openDocument." Open the source report in the OLAP Intelligence designer. In the Tools menu, select "Action Manager" Click "New" to create a new action. Enter an action name. Select the area to which the action (link) will apply. Enter the openDocument link using the parameters and syntax described in this document. Test the link in a browser window before inserting it into a report or document. Click "OK" to save the link. Close the Action Manager dialog box. Create an Analysis Button on the source report. Right-click the Analysis Button. In the drop-down menu, select "Properties" and then "Edit." Select "Launch an Action." Select the action that corresponds to the "openDocument" link. Click "OK."
-
-
3
Define objects in a universe that will allow Business Objects and Web Intelligence users to create reports whose returned values include links to other reports and documents. When these reports are exported to the repository, SAP explains, users can click returned values displayed as hyperlinks to open another related document stored in the document domain of the repository.You create these links using the "openDocument" function in the definition of an object in Designer.
-
1
Tips & Warnings
For complete information on creating links in Web Intelligence reports, see the "Building Reports Using the Web Intelligence Java Report Panel" guide, advises SAP. For more details on other functions, such as using the the Select statement, creating link objects, and using link objects in InfoView, refer to the "Designer's Guide."
References
Resources
- Photo Credit business image by NL shop from Fotolia.com