Analytics > Designing an Analysis > Getting Started with Analytics Reports > Changing the Appearance of Reports in Analytics
Changing the Appearance of Reports in Analytics
When setting up or updating reports, you can change the visual appearance of reports, known as cosmetic formatting. You can apply cosmetic formatting, copy and paste cosmetic formatting attributes, and save a formatted report to use as a style template.
Depending on the item you are formatting, the dialog box displays different options, such as font, cell, and border controls, background color, additional formatting options such as cell padding, and custom CSS style options for HTML.
You can change the appearance of:
- Columns and sections, such as background color and borders
- Columns in tables
- Size of titles
You can copy the range of cosmetic formatting attributes that you apply to an item, such as a column in a table, and paste them to an item of the same type, such as another column in the table or a column in a different table. You can also restore the default appearance. To do this, use the icons at the top right of the dialog boxes.
Views that support copying and pasting include the table, pivot table, and chart views.
About Saving Reports as Style Templates
After you have customized the cosmetic appearance of a report and saved it, you can use it as a template. This allows you to apply the formatting from the saved report to new or existing reports.
Views that support the use of a saved report as a template include the table, pivot table, and chart views.
This topic contains information about performing the following tasks:
- Formatting the visual appearance of a report
- Copying and pasting a formatting attribute
- Restoring the default appearance of an attribute
- Using a saved report as a template
To format the visual appearance of a report
- In Oracle CRM On Demand, click the Analytics tab.
- On the Home page, click Catalog and locate an analysis.
- Open the analysis.
- Select the report that you want to work with, then click OK.
- In the Build and View Analyses page, open the cosmetic format dialog box by doing one of the following:
- In Step 1, click the Column Properties button, and then click the Style tab in the Column Properties dialog box.
- In Step 2, open the Edit Format dialog box by doing one of the following:
- For Title or Table, click the Format View button.
- In the pivot table view, click the Pivot Table View Properties button and then the Set alternate format button.
NOTE: In the table view, you can also click the format column button and use the Value Format tab. In the pivot table view, you can also click the section properties button and use the Section Properties tab.
The cosmetic format dialog box appears.
- [글꼴] 영역에서 적용할 글꼴 패밀리, 크기, 색, 스타일(굵게 등) 및 기타 효과(밑줄 등)를 선택합니다.
참고: 일부 항목에서는 이 옵션을 사용하지 못할 수도 있습니다.
- [셀] 영역에서 정렬 및 배경색을 설정합니다.
참고: 수평 정렬의 경우 텍스트 데이터에 가장 많이 사용되는 맞춤은 왼쪽 맞춤입니다. 숫자 데이터에 가장 많이 사용되는 맞춤은 오른쪽 맞춤입니다.
수직 정렬은 열이 다른 열의 여러 행만큼 확장될 경우에만 효과가 나타납니다.
- [테두리] 영역에서 셀 테두리의 위치, 색 그리고 스타일을 선택합니다.
팁: 위치 드롭다운 리스트 근처에서 위쪽, 아래쪽, 왼쪽, 오른쪽 테두리를 클릭하여 사용자 지정 테두리를 선택하거나 선택 취소할 수 있습니다.
- 셀 안의 간격 서식을 지정하려면 [추가 서식 옵션]을 클릭하고 셀 내용의 너비 및 높이 값과 셀 내용의 위쪽, 아래쪽, 왼쪽 및 오른쪽 간격을 지정합니다.
값은 픽셀 단위로 지정합니다.
- Oracle CRM On Demand 스타일시트에 지정된 스타일 및 클래스 요소를 재정의하려면 [사용자 지정 CSS 스타일 옵션] 영역에서 옵션을 선택합니다.
- 사용할 설정을 클릭합니다.
- 클래스, 스타일 또는 스타일 시트의 위치를 지정합니다.
참고: 고급 스타일 서식 옵션은 CSS 사용 방법을 알고 있는 사용자를 위한 것입니다.
- [확인]을 클릭합니다.
To copy and paste a formatting attribute
- In the Build and View Analysis page, go to the item whose formatting you want to copy, such as a row, column, or table cell.
- Open the Cosmetic Formatting dialog box, click the Copy Formatting button, then click Cancel to close the Cosmetic Formatting dialog box.
- Go to the item to which you want to paste the formatting.
- Open the cosmetic formatting dialog box, click the paste formatting button, then click OK to apply your changes.
To restore the default appearance
- Open the Cosmetic Formatting dialog box for the item, and then click the Clear Formatting button.
For some types of views, when you add the view, you can use a saved report as a template, as described in the following procedure.
To use a saved report as a template
- In the Build and View Analysis page, go to Step 2 Create Layout.
- Click Add View, and select the view that you want.
- Click the Import View Formatting From Another Analysis button, which is near the top of the workspace:

Note: You can import formatting from reports that have formats from Step 2 (Creating Layouts). Formatting from Step 1 (Defining Criteria) cannot be imported.
- In the Import Saved Format dialog box, navigate to the saved report, and click OK.
- Click either the Saved Results link or the Preview Analyses button.
|