presentation of data in transpose format

[Former Member]

Post Author: ksmanyam

CA Forum: Crystal Reports

hi All

i required ahelp in Crystal 8.5 the Data Stored in a oracle table is in the following format

Acno

Year

Apr

may

Jun

Jul

Aug

Sep

Oct

Nov

Dec

1

2000

20

20

20

20

20

20

20

20

20

1

2001

20

20

20

20

20

20

20

20

20

2

2003

20

20

20

20

20

20

20

20

20

3

2000

20

20

20

20

20

20

20

20

20

4

2007

20

20

20

20

20

20

20

20

20

3

2001

20

20

20

20

20

20

20

20

20

3

2002

20

20

20

20

20

20

20

20

20

3

2003

20

20

20

20

20

20

20

20

20

And I want to present data in crystal reports in following format using acno as parameter field

acno

3

2000

2001

2002

2003

Apr

20

20

20

20

may

20

20

20

20

Jun

20

20

20

20

Jul

20

20

20

20

Aug

20

20

20

20

Sep

20

20

20

20

Oct

20

20

20

20

Nov

20

20

20

20

Dec

20

20

20

20

thanks in advance

[Former Member]

Post Author: amr_foci

CA Forum: Crystal Reports

it looks like Cross-Tab table,, try to insert a corss tab report , and you can do it

good luck