johnmac0000
asked on
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
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
ASKER
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.
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.
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.
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.
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
I"ll check my chart options to see what the deal is with suppression of 0.00
ASKER
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. :(
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.
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.
What is the DATAFIELD that is being used to REPRESENT the BARS of the chart?
ASKER
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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
Looks like a BAR Color formatting ..."thing" going on now....
In preview mode you can right click the bar and choose to format it .
One of the options is bar color.
mlmcc
One of the options is bar color.
mlmcc
ASKER
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
Design-View.jpg
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.
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.
RIGHT CLICK on the BAR to format color
You must be previewing the chart in the designer.
mlmcc
mlmcc
ASKER
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.
ASKER
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.
None that I know of.
You can change the width and spacing but it applies to all risers and gaps.
mlmcc
You can change the width and spacing but it applies to all risers and gaps.
mlmcc
ASKER
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.
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.
Without seeing the actual report I don't know. There are several ways of setting the colors.
mlmcc
mlmcc
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..???