Skip to Content
0
Former Member
May 20, 2008 at 05:08 AM

presentation of data in transpose format

16 Views

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