cancel
Showing results for 
Search instead for 
Did you mean: 

report format

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

Dear Harry,

As specified i worked out but in case of crosstab it was not working because of if acctype amount is not there it will not showing as column when have data then only it is fine,in second case it was good in this case it was working with fine but all the accnum are showing when no data exist for acctype.

Thankful for given solution

Regards,

sekhar

Answers (0)