Skip to Content
author's profile photo Former Member
Former Member

Cross tab & Line Graph – Data Sorting issue

Hi,

Want to display data in specific order in cross tab row & in graph as shown below

Account Name

Average

Median

In the same order data has been retrieved from the database but when it comes to Crystal report, its reordering the data in alphabetical order as shown below due to the order set in Group option

Example: 1

ABC

Average

Median

Example: 2

Average

Median

XYZ

Please note u201CAverageu201D & Medianu201D are constant but Account name will vary based on selection.

How this can be achieved? How Specific Order can be used in this case?

Please help... Itu2019s urgentu2026

Thanks,

ThakurS

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 Dec 28, 2011 at 06:09 PM

    Hi

    Under "chart expert" in "data" tab where you add the fields in chart you see "on change of" and "show" values..

    After adding the required on "change of fields" if you would highlight that field "group option" tab will get enabled where you will find the "sort order" drop down. There is an option "In Original Order" which will sort the fields as fetched from Database

    Same option is available in Cross-Tab

    Regards,

    Shantanu

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Abhilash Kumar

      Hi Abhilash,

      I have just given example for Account Name.

      Cross tab have only one row but the rows are generated dynamically based on data. So in this case it should display 3 rows as below

      Account Name

      Average

      Median

      Thanks,

      ThakurS

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.