Crystal Reports Ideas?

You may want to look at Joboper.subcontract; it is a logical field that
would help you with flagging the operation that is contracted.

I just did a quick check on this formatting - pretty slick. It is in my
toolbox now for future customers - just hope they aren't color blind! :)

Bruce

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Rob Bucek
Sent: Wednesday, August 05, 2009 3:01 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports Ideas?

I should also add you may want to put in some additional logic so that
the condition does not cross job numbers... verify that the previous and
next opcode belong to the same job...



Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of melissa hietala
Sent: Wednesday, August 05, 2009 2:34 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Reports Ideas?





For a particular job, I have a listing of operations pulled into a
crystal report. What I need to do is for a particular operation, is if
there is a subcontract operation that immediately proceeds the operation
or a subcontract operation that immediately follows the operation, I
need to flag the operation. Hope this makes sense, any thoughts on how
this can be accomplished?

Thanks,
Dustin Biniek
UMC, Inc.
DustinB@... <mailto:DustinB%40ultramc.com>

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





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



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

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





[Non-text portions of this message have been removed]
For a particular job, I have a listing of operations pulled into a crystal report. What I need to do is for a particular operation, is if there is a subcontract operation that immediately proceeds the operation or a subcontract operation that immediately follows the operation, I need to flag the operation. Hope this makes sense, any thoughts on how this can be accomplished?

Thanks,
 Dustin Biniek
UMC, Inc.
DustinB@...




[Non-text portions of this message have been removed]
Heres a rough hack that I know does work. Depending on how you want to
identify your subcontract operation, we use an operation code of "OTS"
this simple crystal formula in the format section under background color
would do the trick. You can apply the logic in how you see best with
what you are trying to attempt.



if previous({joboper.opcode}) = "OTS" then crgreen else

if next ({joboper.opcode}) = "OTS" then crgreen else crnocolor



Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of melissa hietala
Sent: Wednesday, August 05, 2009 2:34 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Reports Ideas?





For a particular job, I have a listing of operations pulled into a
crystal report. What I need to do is for a particular operation, is if
there is a subcontract operation that immediately proceeds the operation
or a subcontract operation that immediately follows the operation, I
need to flag the operation. Hope this makes sense, any thoughts on how
this can be accomplished?

Thanks,
Dustin Biniek
UMC, Inc.
DustinB@... <mailto:DustinB%40ultramc.com>

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





[Non-text portions of this message have been removed]
I should also add you may want to put in some additional logic so that
the condition does not cross job numbers... verify that the previous and
next opcode belong to the same job...



Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of melissa hietala
Sent: Wednesday, August 05, 2009 2:34 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Reports Ideas?





For a particular job, I have a listing of operations pulled into a
crystal report. What I need to do is for a particular operation, is if
there is a subcontract operation that immediately proceeds the operation
or a subcontract operation that immediately follows the operation, I
need to flag the operation. Hope this makes sense, any thoughts on how
this can be accomplished?

Thanks,
Dustin Biniek
UMC, Inc.
DustinB@... <mailto:DustinB%40ultramc.com>

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





[Non-text portions of this message have been removed]
Thanks Rob. This should get my headed in the right direction.

Dustin Biniek




________________________________
From: Rob Bucek <rbucek@...>
To: vantage@yahoogroups.com
Sent: Wednesday, August 5, 2009 3:00:58 PM
Subject: RE: [Vantage] Crystal Reports Ideas?

Â
I should also add you may want to put in some additional logic so that
the condition does not cross job numbers... verify that the previous and
next opcode belong to the same job...

Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg com/>

(Click the logo to view our site) <http://www.dsmfg com/>

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of melissa hietala
Sent: Wednesday, August 05, 2009 2:34 PM
To: vantage@yahoogroups .com
Subject: [Vantage] Crystal Reports Ideas?

For a particular job, I have a listing of operations pulled into a
crystal report. What I need to do is for a particular operation, is if
there is a subcontract operation that immediately proceeds the operation
or a subcontract operation that immediately follows the operation, I
need to flag the operation. Hope this makes sense, any thoughts on how
this can be accomplished?

Thanks,
Dustin Biniek
UMC, Inc.
DustinB@ultramc. com <mailto:DustinB% 40ultramc. com>

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

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







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