Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

report format

Hi,

I have the following sample tables

ACCOUNT Table :

ACCNUM ACCTYPE ADDRESS

A101 FIXED ADD1

A102 RECURRING ADD2

A103 FIXED ADD3

A104 RECURRING ADD4

A105 SHORT TERM ADD5

A106 SHORT TERM ADD6

ACCOUNT DETAILS TABLE:

ACCNUM BALANCE

A101 23456

A102 12345

A103 34567

A104 12237

A105 45767

A106 56789

As like above tables i want the following detalis in the report look like

ACCNUM FIXED RECURRING SHORT TERM

A101 23456

A102 12345

A103 34567

A104 12237

A105 45767

A106 56789

can u give solution how to format like above in the desktop intelligence .

i will really appreciate u r solution.

regards

sekhar

Former Member
Former Member replied

Sekhar,

That shouldn't be much of a problem. Assuming you have a universe where the join between the 2 tables are defined or you use a free standing SQL where you defined the join yourself.

Now you have 2 solutions:

1. create a crosstab with ACCNUM for the rows and ACCTYPE for the columns and put the BALANCE in the body of the crosstab

2. create a table where you add for each of the ACCTYPE columns the following formula (eg. for column FIXED)

=<BALANCE> where (ACCTYPE = "FIXED")

Regards,

Harry

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question