• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 377
  • Last Modified:

Hide a group base on a formula Crystal XI

I have a group called polid an it is giving me the following result

Polid           Formula

25    --------- 0
25 ----------- 1
25 ----------- 0
25 ----------  0

30 ----------- 0
30 ------------ 0
30 ------------  0

My question is: How can I hide those group that at least have  a 1 in to the formula field like the first one. in this case the report should looks like this:

Polid           Formula

30 ----------- 0
30 ------------ 0
30 ------------  0

Thanks
0
amedexitt
Asked:
amedexitt
1 Solution
 
frodomanCommented:
The generic answer is to use the Section Expert and set a conditional expression formula to do it:

({@YourFormula} > 0)

However, this is entirely dependent on what exactly is involved in your formula.  If the formula is using print-time calculations, then you aren't going to be able to suppress based on it at all.  There may or may not be feasible workarounds but if you can provide more details it'll be easier to discuss in specific terms.

frodoman
0
 
AHMKC1Commented:
if your Formula data  are always 0 or 1 or always number then
sub total it and set formula to supress group and detail section if sub total is greater  than 0
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now