Solved

Crystal Chart Zero Values

Posted on 2013-05-13
9
501 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
[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
  • 3
  • 3
9 Comments
 
LVL 101

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
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 

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 101

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 101

Accepted Solution

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

mlmcc
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
How to increase the row limit in Jasper Server.
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

630 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