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
Solved

CR COUNTING DATA WITH CONDITION

Posted on 2013-06-24
6
231 Views
Last Modified: 2013-06-24
Hi All,

I have a report.
I want to counting string data, the counting plus 1 if there is data (not blank).
I want to do it at group footer.

How could I do it ?

Thank you.
0
Comment
Question by:emi_sastra
  • 3
  • 2
6 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 39271154
It depends on what you mean by 'not blank'.

Using Insert Summary and a Count on the relevant field will ignore Null values, so you will get a true count of fields with non-null data.
However if your data could contain fields that just contain spaces or other non-printable characters then Count will not ignore those.
0
 
LVL 1

Author Comment

by:emi_sastra
ID: 39271166
Hi  peter57r,

Since its type is string.  
What I mean blank is empty string ("").

Thank you.
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 39271297
Try this

Create a formula

If IsNull({YourField}) OR {YourField} = "" then
    0
Else
    1

You can then summarize that to get the count of non-null/blank fields

mlmcc
0
Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

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.

 
LVL 77

Expert Comment

by:peter57r
ID: 39271367
I would expect empty strings to be ignored in a Count summary.

Are you saying they are being included in your total?

Are you using the built-in summary functions (Insert>Summary) or have you created your own formula field?
0
 
LVL 1

Author Comment

by:emi_sastra
ID: 39271536
-I would expect empty strings to be ignored in a Count summary.
Yes

-Are you saying they are being included in your total?
No

-Are you using the built-in summary functions (Insert>Summary) or have you created your own formula field?
I use builtin functions

Thank you.
0
 
LVL 1

Author Closing Comment

by:emi_sastra
ID: 39273294
Hi mlmcc,

It works.

Thank you very much for your help.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

856 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