?
Solved

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

Posted on 2009-05-11
2
Medium Priority
?
237 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 1000 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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

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 …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

800 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