Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    May 20, 2008 at 06:59 AM

    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

    Add comment
    10|10000 characters needed characters exceeded