Solved

Crystal Chart Zero Values

Posted on 2013-05-13
9
487 Views
Last Modified: 2013-08-16
Dear All,

I am plotting a crystal chart using a formula.

Example:

If {Table1_.SalesQty}<=8 then {Table1_.SalesQty} else 0

I would like to suppress the zero values in my chart. Please let me know how to set minimum values to the Y axis, so that zero values can be suppressed.

Thanks
Som
0
Comment
Question by:reachsoma
  • 3
  • 3
9 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 39163580
WHy not just filter them out of the report?

ANother idea would be to group based on the formula
If {Table1_.SalesQty}<=8 then 1 else 0

You could then suppress the grou 0 chart

mlmcc
0
 

Author Comment

by:reachsoma
ID: 39163734
Thanks for your response.

I can't filter these records as it going to affect other report area. I am using the SAP BEx query, so dont want to define any new conditional key figure at query level.

I would like to plot a line chart for last 12 months ( say Apr- May) and not sure how grouping will help in this case.

Thanks
Som
0
 
LVL 77

Expert Comment

by:peter57r
ID: 39163811
If you cannot exclude the values form the main report, and the grouping is not acceptable, then I think your only option is to use a subreport to contain your chart.  You can then exclude the unwanted values from the subreport using a record selection rule.
0
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

 

Author Comment

by:reachsoma
ID: 39164868
Please let me know more details on the grouping approach. I will try to implement this.

Thanks
Som
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 39164935
Create the formula I posted above.
Create a group on it
Put the chart in the group header or footer

mlmcc
0
 

Author Comment

by:reachsoma
ID: 39165039
I have four series in my chart. For only one series i am getting zero values.
If i try for conditional grouping on one series, other 3 series values are affecting. It excludes values from the other series based on the group and not displaying the all months data points.

Regards
Som
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 300 total points
ID: 39165284
IN that case you can't exclude the 0 values.

mlmcc
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

708 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

15 Experts available now in Live!

Get 1:1 Help Now