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:
As like above tables i want the following detalis in the report look like
ACCNUM FIXED RECURRING SHORT TERM
can u give solution how to format like above in the desktop intelligence .
i will really appreciate u r solution.
Harry van der Kolk replied
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")