?
Solved

Crystal Reports Chart Top N not working

Posted on 2014-04-08
3
Medium Priority
?
481 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
[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
3 Comments
 
LVL 101

Accepted Solution

by:
mlmcc earned 1500 total points
ID: 39987800
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 35

Expert Comment

by:James0628
ID: 39988346
mlmcc,

 FWIW, you might want to add the CR zone.

 James
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 39988596
Topic changed to Crystal Reports

mlmcc
TA
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

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 brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses
Course of the Month13 days, 14 hours left to enroll

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