Crystal reports suppress using a where statement

Use a global variable. Create it in the report/group header with a
formula of "global BooleanVar foundsub = false", add another formula
field in the detail line that does "... if {subcontract check...} then
foundsub := true" and then do a conditional suppress of the detail
section based on that field. The global variable will be set once the
first subcontract line is encountered, and because it's global, remain
that was for all future detail lines.



Brian.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of michael.hutcheson@...
Sent: Monday, May 16, 2011 8:54 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal reports suppress using a where statement





Hello,

I have the below data in a report (dates in dd/mm/yy), grouped by job:

Job: 123
OP SEQ Desc Type: Date
20 Stamping 01/02/11
30 CNC 01/03/11
40 Hand Dress 01/04/11
50 Machining Sub Contract 01/05/11
60 Inspection 01/06/11

What statement would I use to only show Op Seq's 20,30,40 and 50? I.e.
Hide anything after the sub contract. Basically I want to say if the
date is greater than an op that is a sub contract, then suppress - but
how do I actually write this?

Regards,

Michael





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

I have the below data in a report (dates in dd/mm/yy), grouped by job:

Job: 123
OP SEQ Desc Type: Date
20 Stamping 01/02/11
30 CNC 01/03/11
40 Hand Dress 01/04/11
50 Machining Sub Contract 01/05/11
60 Inspection 01/06/11


What statement would I use to only show Op Seq's 20,30,40 and 50? I.e. Hide anything after the sub contract. Basically I want to say if the date is greater than an op that is a sub contract, then suppress - but how do I actually write this?

Regards,

Michael
You could try using a running total.

Basically the idea would be to create RTotal variable which increments
when Type=Sub Contract (you could just use the Count function), and
which resets at the change of the group. You could then conditionally
suppress the detail lines if your RTotal variable isn't zero.

-bws

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of michael.hutcheson@...
Sent: Monday, May 16, 2011 8:54 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal reports suppress using a where statement

Hello,

I have the below data in a report (dates in dd/mm/yy), grouped by job:

Job: 123
OP SEQ Desc Type: Date
20 Stamping 01/02/11
30 CNC 01/03/11
40 Hand Dress 01/04/11
50 Machining Sub Contract 01/05/11
60 Inspection 01/06/11


What statement would I use to only show Op Seq's 20,30,40 and 50? I.e.
Hide anything after the sub contract. Basically I want to say if the
date is greater than an op that is a sub contract, then suppress - but
how do I actually write this?

Regards,

Michael



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links