Crystal Summary 'Count'

Yahoo Archive
1
Jeff,



I believe you can correct this with a "distinct count" instead of a
"count".

Give it a shot, it has worked for me in the past.



Ron Flynn

803.407



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of jplehr
Sent: Friday, September 18, 2009 3:56 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Summary 'Count'





Vantage 8.03.408A

I have two columns in my Crystal Report. I inserted a Summary for each.
The first column has data populated on each line and my summary is a
'Count'. Works fine. The second column only has data when it meets
certain criteria. My 'Count' of this column still counts every line.
This summary should be less so I can then divide the two to get my
percentage. Is there a way to stop it from counting the empty lines?

Not sure if that made any sense, but it is well past beer'30.

Thanks for any help.

Jeff





[Non-text portions of this message have been removed]
2
Vantage 8.03.408A

I have two columns in my Crystal Report. I inserted a Summary for each. The first column has data populated on each line and my summary is a 'Count'. Works fine. The second column only has data when it meets certain criteria. My 'Count' of this column still counts every line. This summary should be less so I can then divide the two to get my percentage. Is there a way to stop it from counting the empty lines?

Not sure if that made any sense, but it is well past beer'30.

Thanks for any help.

Jeff
3
i got lazy once and put in a formula where if field is null then 0 else 1 and summed for the total. worked as good as a count.


BILL R. KING
J&B Industrial Services
(806).776.4409 Office
(254).592.4397 Cell



________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of jplehr
Sent: Friday, September 18, 2009 3:56 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Summary 'Count'



Vantage 8.03.408A

I have two columns in my Crystal Report. I inserted a Summary for each. The first column has data populated on each line and my summary is a 'Count'. Works fine. The second column only has data when it meets certain criteria. My 'Count' of this column still counts every line. This summary should be less so I can then divide the two to get my percentage. Is there a way to stop it from counting the empty lines?

Not sure if that made any sense, but it is well past beer'30.

Thanks for any help.

Jeff




________________________________
The information contained in this message is intended solely for the individual to whom it is specifically and originally addressed. This message and its contents may contain confidential or privileged information. If you are not the intended recipient, you are hereby notified that any disclosure or distribution, or taking any action in reliance on the contents of this information, is strictly prohibited.
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 cannot accept liability for any loss or damage caused by software viruses.

This message (including any attachments) is intended only for
the use of the individual or entity to which it is addressed and
may contain information that is non-public, proprietary,
privileged, confidential, and exempt from disclosure under
applicable law or may constitute as attorney work product.
If you are not the intended recipient, you are hereby notified
that any use, dissemination, distribution, or copying of this
communication is strictly prohibited. If you have received this
communication in error, notify us immediately by telephone and
(i) destroy this message if a facsimile or (ii) delete this message
immediately if this is an electronic communication.

Thank you.


[Non-text portions of this message have been removed]
4
Do a running total and evaluate based on your second column formula then it will only count those fields
Sent from my Verizon Wireless BlackBerry

-----Original Message-----
From: "jplehr" <jlehr@...>

Date: Fri, 18 Sep 2009 20:56:10
To: <vantage@yahoogroups.com>
Subject: [Vantage] Crystal Summary 'Count'


Vantage 8.03.408A

I have two columns in my Crystal Report. I inserted a Summary for each. The first column has data populated on each line and my summary is a 'Count'. Works fine. The second column only has data when it meets certain criteria. My 'Count' of this column still counts every line. This summary should be less so I can then divide the two to get my percentage. Is there a way to stop it from counting the empty lines?

Not sure if that made any sense, but it is well past beer'30.

Thanks for any help.

Jeff




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