Solved

# Crystal Reports 11 create report that detects if value is missing

Posted on 2014-07-22
121 Views
Please see the attached,  I need to write a report that will look at the table (similar to the one attached) and only print out the job and suffix that are missing the operation  50

in this very basic example, the report needs to show one line

E7112      1
0
Question by:vikingitguy
• 2

LVL 3

Author Comment

ID: 40211973
to clarify,  there are thousands of Job numbers,  and each job has at least 1 subjob..... every subjob should have an operation 50,  I am looking for all jobs and subjobs that are missing the operation 50.... I hope that helps
0

LVL 100

Assisted Solution

mlmcc earned 250 total points
ID: 40212155
Is a subjob the same as the suffix?

You will need to do this either through suppression using a count of the operation 50 or SQL to eliminate the jpbs that have a 50.

I don't see the attachment.

mlmcc
0

LVL 3

Author Comment

ID: 40212291
yes, the subjob is the same as the suffix.   could you clarify about suppression using a count of the operation?
examp1.xls
0

LVL 34

Accepted Solution

James0628 earned 250 total points
ID: 40213814
Group the report on Job.

Create a formula similar to the following.  Let's call the formula count_50.

if {Operation field} = 50 then
1
else
0

Go to Report > Selection Formulas > Group and enter a formula like this:

Sum ({@count_50}, {Job field}) > 0

What that does is use group selection to select the groups (jobs) that have at least 1 Operation 50 record.

Be aware that group selection is really suppression.  The report is still reading the records for all of the other jobs (so it knows which ones to show).  It just won't display the other jobs, although if you're using the group tree, they will be listed in the tree.  The point is, if you have CR do any summaries, it will include all of the other jobs too, because it's still reading those other records.  If you need any totals for only the jobs that include Operation 50, you'll have to create those another way (probably using formulas and variables).

James
0

## Featured Post

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.