Download CA705 - Basics of Report Painter - Report Writer PDF

TitleCA705 - Basics of Report Painter - Report Writer
TagsTechnology Usability Information Technology Management Icon (Computing) Library (Computing)
File Size14.4 MB
Total Pages253
Table of Contents
                            toc
	Icons in Body Text
	Introduction to Report Painter/Report Writer
		Lesson:
			Overview of Reporting Tools and Applications in SAP System
			Uses of Report Painter
			Report Writer Components
				Exercise 1: Report Components
	Creating Reports Using Report Painter
		Lesson:
			Structure of Report Painter Reports
			Defining Rows and Columns
			Restricting Data in Reports
				Exercise 2: Components of a Report Painter Report
		Lesson:
			Using Report Groups
			Sorting Hierarchies
			Using Variables in Reports
			Defining Text
				Exercise 3: Building and Executing a Report With a Total Row
				Exercise 4: Using Hierarchies: Explode function
				Exercise 5: Using Hierarchies: Sequence (Sort)
	Row and Column Models
		Lesson:
			Defining Reports Using Row and Column Models
				Exercise 6: Building Row and Column Models
	Section and Horizontal Pages
		Lesson:
			Overview of Sections
			Calculating Formula Rows, Columns, and Key Figures
				Exercise 7: Working with Horizontal Pages
				Exercise 8: Working with Independent Sections
				Exercise 9: Using Cells in Column Formulas
				Exercise 10: Working with Dependent Sections and Cells
	Formatting Reports
		Lesson:
			Formatting Sections
			Using Standard Layouts
			Using Format Groups
			Section Layouts and Attributes
				Exercise 11: Section Layout and Attributes
				Exercise 12: Format Groups and Other Formatting Issues
	Variations and Extracts
		Lesson:
			Using Variations
			Creating Extracts
			Using Background Jobs
				Exercise 13: Variation
				Exercise 14: Extracts
				Exercise 15: Background Jobs
	Reports in a Live System
		Lesson:
			Online Settings and Connections
			Using the Report/Report Interface
			Assigning User and Report Groups to a Role
			Transporting Report Objects
				Exercise 16: Report/Report Interface
				Exercise 17: Send Reports as Mail
	Working with Sets
		Lesson:
			Basic Sets
			Single-Dimension Sets
				Exercise 18: Single-Dimension Sets
	Variables used in the report definition can be embedded in repor
                        
Document Text Contents
Page 127

I
n

t
e

r
n

a
l




U
s

e



S

A
P




P
a

r
t

n
e

r



O

n
l
y

I n
t e

r n
a

l U
s

e
S

A
P

P
a

r t n
e

r O
n

l y

CA705 Lesson: Defining Sections and Horizontal Pages

Solution 9: Using Cells in Column Formulas
Task:
The report required now is displayed below.

1. Create the report shown below and call it Z6##-002 (base it on Z6##-001).

Figure 57:

- Select cell needed for calculation

- Add the New Formula Column

- Check and Save the Report

- Assign the Report to the Report Group Z6##

- Execute the Report

a) Report→ Create

Library: Z##

Report: Z6##-002

Description: Cell in form. col.

Copy From

Report: Z6##-001

Continued on next page

2005/Q3 © 2005 SAP AG. All rights reserved. 119

Page 252

I
n

t
e

r
n

a
l




U
s

e



S

A
P




P
a

r
t

n
e

r



O

n
l
y

I n
t e

r n
a

l U
s

e
S

A
P

P
a

r t n
e

r O
n

l y

Index CA705

Texts, 44
V
Variables, 43
Variation, 159

Variation function, 159
W
WYSIWYG, 6

244 © 2005 SAP AG. All rights reserved. 2005/Q3

Similer Documents