[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1088
  • Last Modified:

How can I remove 0 from series risers?

I have a chart in Crystal Reports that displays 0.00 data labels in between the series risers.  I have searched through the Chart Expert, Series Option, Axis and many places I no longer remember.  I cannot find out how to shut those 0.00s off.  In the Preview, I can click on the 0.00 data label to select it, right click on the 0.00 and select Format Data Label to untick the box for Display data label, however, I have to do this for each chart (sometimes there are more than 20) and it will not save the change.  I cannot even find the data label in the Design view.
I've tried removing fields from values from the Data tab in Chart Expert.  That only removes the risers I do want.

Zero-risers.jpg
0
johnmac0000
Asked:
johnmac0000
  • 9
  • 8
  • 5
2 Solutions
 
MIKESoftware Solutions ConsultantCommented:
There must be a literal "data-point" for "0.00"

By chance is this chart based on a CROSSTAB...? If so, have you tried SUPPRESSING ZEROS...???

If it is NOT based on a Crosstab,...have you tried basing your Chart on the Crosstab and SUPPRESSING ZEROS..???
0
 
johnmac0000Author Commented:
I did not create the report.  It is something I inherited.  How would I tell if it is based on a crosstab?  There is nothing in the details section of the report.

The zeros are in between the risers.  I have removed the values listed in the Data tab of Chart Expert.  They were set to Max.  
0
 
MIKESoftware Solutions ConsultantCommented:
Can you post the SQL QUERY from the report here? SO that I can see what the data is.

At least that is where i would start...by looking at the data to see WHY Zeros are appearing. I don't think they should be appearing..but I suspect that they are actually appearing in the data.

You may be able to adjust the SQL to NOT pull in NULLS or zeros...or whatever it is that is causing this...too early to tell.

0
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.

 
MIKESoftware Solutions ConsultantCommented:
oh wait..I think I see....actually..I think you'll need the ZERO...because on occassion your chart may report on NEGATIVE or below ZERO numbers.

I"ll check my chart options to see what the deal is with suppression of 0.00
0
 
johnmac0000Author Commented:
Thanks.  We do report zero and negative numbers (especially right now with the way the stock market is bouncing).  Zero is a legitamate value, however, they seem to be in the wrong place.  :(  
0
 
MIKESoftware Solutions ConsultantCommented:
Well it appears that the Chart is trying to report on a SECTION or PIECE of data.

The RED and the BLUE represent SOMETHING or SOMEONE...so there is a SOMETHING that is showing a ZERO balance or status.

You need to figure out what this is in order to move to the next step of having it NOT show. It is reporting a ZERO for someone.
0
 
MIKESoftware Solutions ConsultantCommented:
What is the DATAFIELD that is being used to REPRESENT the BARS of the chart?
0
 
johnmac0000Author Commented:
The attached files show the data elements being used by the risers in the chart.  I know those are the data elements because I removed them from the Show Values list to see what would happen.  

The thing I do not understand is why the zeros are showing up between the risers.  There does not appear to be a field associated with that spot.  

I have moved things out of the way to look under them and removed any section suppression.  
Investment-Return-Data.jpg
Investment-Risk-Data.jpg
0
 
MIKESoftware Solutions ConsultantCommented:
Hum....whew...thought I was losing it...but I think you labeled the Chart Experts incorrectly.

Ok...so it looks like the ALLOWANCE is showing ZERO...on the Investment Return Chart...and also the ALLOWANCE on the Investment Risk chart is showing ZERO.

Either take them out of the CHART ...or figure out WHY they don't contain any amounts....????

the ALLOWANCE field is your problem...
0
 
mlmccCommented:
Agree.  The only way to remove the 0 values is for them not to appear in the dataset.

mlmcc
0
 
johnmac0000Author Commented:
That was my first assumption when I looked at that list.  The problem is when I remove the allowance from the list the columns do not appear correctly.  The first image shows the chart right after removing allowance.  As you can see, the data labels are still there which led me to believe that the risers had to be there as well.  

The second image shows the risers after I formatted them with the color changed from white to peacock blue (maybe it's robins egg blue).  

I need to get the three sets of bar charts to be evenly spaced with one red one blue for each set.
Allowance-Removed.jpg
Allowance-Removed-but-Risers-for.jpg
0
 
MIKESoftware Solutions ConsultantCommented:
Looks like a BAR Color formatting ..."thing" going on now....
0
 
mlmccCommented:
In preview mode you can right click the bar and choose to format it .
One of the options is bar color.

mlmcc
0
 
johnmac0000Author Commented:
In the design view, I cannot see what is making the bars red or blue.  (Did I tell you I am very new to Crystal?)  All I see are three blue columns.  


Design-View.jpg
0
 
MIKESoftware Solutions ConsultantCommented:
You may still need to research the VARIANCE field being zero. You said you inherited this report and so someone wanted to see that field in the chart.

If requirements have changed that is good, but I'd ask the report requestor / user if they need to see VARIANCE in the chart or not..... it could be a DATA Integrity issue.
0
 
MIKESoftware Solutions ConsultantCommented:
RIGHT CLICK on the BAR to format color
0
 
mlmccCommented:
You must be previewing the chart in the designer.

mlmcc
0
 
johnmac0000Author Commented:
I am certain that this was always an issue and that is why the risers were filled with white so they would not show up.  Could it be that the allowance field was used as a spacer?  The data labels associated with them were originally white.  I only discovered them when these guys decided to change the color.  Before that, the zeros did not appear.  
0
 
johnmac0000Author Commented:
Is there another way to get the same sort of separation between the risers without having that additional data element in the set?  The other thing I have noticed is that the risers do not show the blue red, blue red pattern if the allowance is removed.  In both charts, allowance somehow causes the bars to display the required colors while acting as a spacer.  I tried removing allowance and changing the risers in the preview mode and saving the report.  When I reopen it, the risers revert back.  
0
 
mlmccCommented:
None that I know of.

You can change the width and spacing but it applies to all risers and gaps.

mlmcc
0
 
johnmac0000Author Commented:
Here is what I found....

In the Formula Fields list in the report, there was an item named Null.  Just for grins I decided to replace Allowance with that field.  Doggone if it didn't serve the same function as the Allowance field.  The columns were in the right place and were the right colors.  The Null field was a Formula Field with nothing in it.

I am convinced that they were using the Allowance field just as a spacer to keep the required distance between the columns and to keep the colors straight.  Although, I still do not understand why the colors changed when the separation was removed.  I also do not understand why the columns are only blue in the design view or why changing them to red only effects the first two columns.  
0
 
mlmccCommented:
Without seeing the actual report I don't know.  There are several ways of setting the colors.

mlmcc
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 9
  • 8
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now