Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

presentation of data in transpose format

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

Not what you were looking for? View more on this topic or Ask a question