Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.