Spam: Crystal Help Please!

Yahoo Archive
1
There is, and it is not selected.

I also tried to do a conditional format on the field but for some reason
Crystal does not show the summary fields for selection in the formula
builder.

I noticed also that my screen shot and attachment have been removed
before posting to the group.





________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Robert MacDonald
Sent: Wednesday, August 02, 2006 12:02 PM
To: vantage@yahoogroups.com
Subject: RE: Spam:[Vantage] Crystal Help Please!



Gerard,

Is there not a setting in Report Options to convert null to zero or not?

Robert MacDonald

Information Technology Manager

Ground Effects Ltd.

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Gerard Wadman
Sent: Wednesday, August 02, 2006 9:57 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Spam:[Vantage] Crystal Help Please!

Here is a screen shot of a crystal report that I built.

It's a cross tab report to track Cycle Count activity.

What we would like to do is suppress the count summary (which is in
gray). I know how to do that.

But we also want to format the adjustment sum to display a null value if
the count summary = 0 (zero)

No matter what I do the adjustment summary converts all nulls to display
zero.

TIA for any suggestions.

Gerard M Wadman

MCSE, MCP+I, A+, NET+

Sr. Network Systems Engineer

Scandius BioMedical Inc

11A Beaver Brook Road

Littleton, MA 01460

978/486-4088 x 124

866/486-4108 (fax)

http://www.scandius.com/ <http://www.scandius.com/>
<http://www.scandius.com/ <http://www.scandius.com/> >

This e-mail is for the use of the intended recipient(s) only. If you
have received this e-mail in error, please notify the sender immediately
and then delete it. If you are not the intended recipient, you must not
use, disclose or distribute this e-mail without the author's prior
permission. We have taken precautions to minimize the risk of
transmitting software viruses, but we advise you to carry out your own
virus checks on any attachment to this message. We do not accept
liability for any loss or damage caused by software viruses

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
2
Gerard,

Is there not a setting in Report Options to convert null to zero or not?



Robert MacDonald

Information Technology Manager

Ground Effects Ltd.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Gerard Wadman
Sent: Wednesday, August 02, 2006 9:57 AM
To: vantage@yahoogroups.com
Subject: Spam:[Vantage] Crystal Help Please!



Here is a screen shot of a crystal report that I built.

It's a cross tab report to track Cycle Count activity.

What we would like to do is suppress the count summary (which is in
gray). I know how to do that.

But we also want to format the adjustment sum to display a null value if
the count summary = 0 (zero)

No matter what I do the adjustment summary converts all nulls to display
zero.

TIA for any suggestions.

Gerard M Wadman

MCSE, MCP+I, A+, NET+

Sr. Network Systems Engineer

Scandius BioMedical Inc

11A Beaver Brook Road

Littleton, MA 01460

978/486-4088 x 124

866/486-4108 (fax)

http://www.scandius.com/ <http://www.scandius.com/>

This e-mail is for the use of the intended recipient(s) only. If you
have received this e-mail in error, please notify the sender immediately
and then delete it. If you are not the intended recipient, you must not
use, disclose or distribute this e-mail without the author's prior
permission. We have taken precautions to minimize the risk of
transmitting software viruses, but we advise you to carry out your own
virus checks on any attachment to this message. We do not accept
liability for any loss or damage caused by software viruses

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]