Solved

Sort the chart based on a field not there in the Chart

Posted on 2009-05-11
2
234 Views
Last Modified: 2012-08-14
This is my sample data on which i am trying to create a graph
Field A                      Field B (Count)                     Field C(Order)
Answer1                      4                                           0
Answer2                      1                                           1
Answer3                      3                                           2
Answer4                      5                                           3

I have used a chart which displays Count(Field B ) on Y axis on Change of Field A on X Axis.
Right now i am able to sort the chart based on Field B.

Is it possible to sort the chart based on Field C?
I want to display the order of the count, same order as the Field C
0
Comment
Question by:vvuppuluri
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 6

Accepted Solution

by:
Dan3D earned 250 total points
ID: 24438229
If all else fails,  you could likely do this with our CRChart add-in.  Use the @SORT with value of 8 or 9 to key off the first series, then use @IS to hide the key series from showing up in the graph.

-Dan

DISCLAIMER: I work for the company, threedgraphics.com, that makes this product. This product costs money.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question