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