Adam,
You can't join on a calculated field in Crystal, but you can use them in
record selection formula's. So you could say Calculatedfield =
Vantage.field for instance and it may accomplish a similar thing.
Troy
-----Original Message-----
From: Adam Ellis [mailto:AELinuxGuy@...]
Sent: Saturday, November 01, 2003 12:12 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Next Operation
Amy - is this a Crystal or RB report? I have always yearned for
solutions like Patrick's to work inside of Crystal, but Crystal does not
allow joining on calculated fields :(. If you are in Crystal, the only
solution I've come up with is to stick a subreport in and pass the next
operation back to the main report with a shared variable.
AE
You can't join on a calculated field in Crystal, but you can use them in
record selection formula's. So you could say Calculatedfield =
Vantage.field for instance and it may accomplish a similar thing.
Troy
-----Original Message-----
From: Adam Ellis [mailto:AELinuxGuy@...]
Sent: Saturday, November 01, 2003 12:12 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Next Operation
Amy - is this a Crystal or RB report? I have always yearned for
solutions like Patrick's to work inside of Crystal, but Crystal does not
allow joining on calculated fields :(. If you are in Crystal, the only
solution I've come up with is to stick a subreport in and pass the next
operation back to the main report with a shared variable.
AE
On Fri, 2003-10-31 at 08:57, pjw@... wrote:
> Not a perfect solution but worth a try:
> create a calculated field adding 10 to the sequence number
> Add the joboperation table as an alias "joboper2", left outer join,
using
> the company, jobnumber, assebly sequence, and joboper2.operationsequence
to
> your calculated field.
>
> Patrick Winter
>
>
> -----Original Message-----
> From: Amy Creighton [mailto:acreighton@...]
> Sent: Thursday, October 30, 2003 7:38 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Next Operation
>
>
> Has anyone found a way to list "next operation" in a report when the
next
> operation is in the parent assembly? We want to basically show the life
of
> the part. Thank you.
>
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
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/links
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]