Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Crystal Chart Zero Values

Posted on 2013-05-13
9
Medium Priority
?
506 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
7 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
Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

 

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 1200 total points
ID: 39165284
IN that case you can't exclude the 0 values.

mlmcc
0

Featured Post

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!

Question has a verified solution.

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

Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
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…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?

581 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