Solved

Crystal Reports 11 create report that detects if value is missing

Posted on 2014-07-22
6
125 Views
Last Modified: 2015-02-06
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
Comment
Question by:vikingitguy
[X]
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
  • 2
6 Comments
 
LVL 3

Author Comment

by:vikingitguy
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

by:mlmcc
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

by:vikingitguy
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 35

Accepted Solution

by:
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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

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 …
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…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

734 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