Solved

Crystal Chart Zero Values

Posted on 2013-05-13
9
499 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 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

739 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