Print      Open PDF Version of Online Help

Administering Oracle CRM On Demand > Application Customization > Record Type Application Customization Page > Creating Homepage Custom Reports

Creating Homepage Custom Reports

You can use the Homepage Custom Report feature to add multiple reports, including both prebuilt and custom reports, to the record-type Homepages. This feature allows you to provide the most relevant information to different users. For example, you can configure the Service Request Homepage for a customer service representative to show a custom service-request report.

For some record types, standard reports are shown on the record-type Homepage by default. You can replace the standard reports with different reports, or you can add additional reports. You can also specify Homepage reports for record types where no report is shown on the record-type Homepage by default.

NOTE: For information about where reports and dashboards can be embedded in Oracle CRM On Demand, see About Embedding Reports and Dashboards in Oracle CRM On Demand.

To make a prebuilt or custom report available on a record-type Homepage, you first create a Homepage custom report record for the report. When you create or edit the Homepage layouts for a record type, any Homepage custom report records that you created for the record type are listed in the All Sections list in the Homepage Layout Wizard. You can then make a report available on a Homepage layout as follows:

• You can move the report to one of the lists of sections that are displayed by default in the Homepage layout, so that any user whose role has that layout automatically sees that report on their record-type Homepage.
• You can move the report to the list of Available sections in the Homepage layout, so that any user whose role has that layout and the Personalize Homepages privilege can add the report to his or her record-type Homepage.

For more information about customizing Homepages, see Creating Record Homepage Layouts. For information about creating custom reports for My Homepage, see Enabling Custom Reports in My Homepage.

About Privileges for Managing Homepage Custom Report Records

If your role has the appropriate privileges, you can create custom report records and add them to custom Homepage layouts for all record types. The following table shows the privileges required for the various tasks involved in making a custom report available on a Homepage.

Before you begin:

• The report that you want to enable in a Homepage must be stored under Shared Folders, in a folder to which you have access.
• If the Enable Language Translation Support for Web Applets check box is selected on the company profile, then you can create custom reports only if the language that is selected in the Translation Language field is the default language for the company.

To create a Homepage custom report

1. In the upper-right corner of any page, click the Admin global link.
2. In the Application Customization section, click the Application Customization link.
3. In the Record Type Setup section, click the link for the required record type.
4. In the Homepage Layout Management section, click record type Homepage Custom Report.
5. Click New Homepage Report.
6. On the Homepage Custom Report Detail page, complete the following fields.

   Field	Comments
   Name	Enter the name of the custom report.
   Mark for Translation	This check box is available only if the Enable Language Translation Support for Web Applets check box is selected on the company profile. When you create a custom report, the Mark for Translation check box is selected and read-only. Also, the Mark for Translation check box is read-only if you select any language other than the default language for the company in the Translation Field in the list of custom reports before you update an existing custom report. If you change the name of an existing custom report in the default language for the company, then use the Mark for Translation check box as follows: If you want the translated versions of the name to be replaced by the updated name, then select the Mark for Translation check box. If you want the translated versions of the name to remain unchanged, then do not select the Mark for Translations check box. For more information about translating custom report names, see Translating Web Applet and Custom Report Names.
   Height	Select Single or Double. If you set the height to Double, the report becomes twice the height of the other sections on the Homepage.
   Width	Select Single or Double. If you want the report to span the entire Homepage from left to right, set the width to Double. NOTE: Reports that have an HTML RowSpan attribute value of more than 2 sometimes span beyond the specified size.
   Execute Report Immediately	If you select this check box, the report will run automatically, and users will not have to click a link to update the report.
   Catalog	Select the catalog for the report that you want to embed.

7. Click the Lookup icon (magnifying glass), and then navigate to the report you require in Shared Folders.

   The Report Path field is automatically populated after you select the report.

8. In the Description field, enter a description for the homepage custom report.
9. Click Save.