Solved

Crystal Reports Chart Top N not working

Posted on 2014-04-08
3
457 Views
Last Modified: 2014-04-09
I have a Crystal Reports line chart with the percentage of calls per day that went to voicemail.  I've got a line for each of our 15 clients.  The chart is way too cluttered and I'd like to take the top 7 and put it on one chart and take the bottom 8 and put them on another chart.  When I choose Top N is 7, the chart gives me 13 clients instead of 7.  When I choose the Bottom 8, it gives me the same 13 clients.  How do I split this into two charts?
0
Comment
Question by:altosax
  • 2
3 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
Comment Utility
Do you care which go each chart?

Is ther some value associated with the clients perhaps the name where you can do something like

If Left({ClientName},1 <= 'M') then
    1
Else
    2

Group on that formula and put the chart in the group header or footer

mlmcc
0
 
LVL 34

Expert Comment

by:James0628
Comment Utility
mlmcc,

 FWIW, you might want to add the CR zone.

 James
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
Topic changed to Crystal Reports

mlmcc
TA
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

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. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

772 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now