Skip to Content
0
Former Member
Apr 27, 2009 at 06:03 AM

report format

31 Views

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