I need help with Record Selection in Crystal

Yahoo Archive
1
I hope it helped, did it work.

Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...

Visit www.one.org to see how the world can be changed one person at a time.



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
midwestsigncompany
Sent: Wednesday, January 04, 2006 8:46 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: I need help with Record Selection in Crystal


Frank -

Thank you for this formula help. I am still learning Crystal and
this type of help is FANTASTIC!

Teresa

--- In vantage@yahoogroups.com, "Frank Zeigafuse" <fzeigafuse@l...>
wrote:
>
> At first I thought this was easy :)
>
> But then I READ.
>
> Link jobhead to part-tran group on job number, then create a
formula called
> show
>
> If parttran.trantype <> MFG -STK
> then 1
> else 0
>
> Then add up this formula
>
>
> Go to the section detial and select suppress, then this is pseudo
code
>
> If "sum for the group show" > 1
> then defualtattribute
>
> Frank Zeigafuse
> Innovative Office Products
> General Manager
> Direct Phone: 610-559-6369
> Email: fzeigafuse@L...
>
> Visit www.one.org to see how the world can be changed one person
at a time.
>
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> midwestsigncompany
> Sent: Tuesday, January 03, 2006 4:52 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] I need help with Record Selection in Crystal
>
>
> I am trying to run a Crystal Report to show me all jobs that do
not
> have a part transacation of MFG-STK. I currently have a report
where I
> have gouped by job number and can see all the part transacations
for
> those jobs, but I am not real sure how to only see those jobs that
do
> not have a part transaction that is MFG-STK. I have tried to do a
> group record selectino formula of PartTran.TranType <> MFG-STK,
but it
> still returns the job number with all the other Part Tran Types
for
> that job. Any ideas would be helpful; I am stumped.
>
> Teresa Davis
> HR Manager/Systems Administrator
> Sign Productions
>
>
>
>
>
> 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
> Yahoo! Groups Links
>







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
Yahoo! Groups Links
2
I am trying to run a Crystal Report to show me all jobs that do not
have a part transacation of MFG-STK. I currently have a report where I
have gouped by job number and can see all the part transacations for
those jobs, but I am not real sure how to only see those jobs that do
not have a part transaction that is MFG-STK. I have tried to do a
group record selectino formula of PartTran.TranType <> MFG-STK, but it
still returns the job number with all the other Part Tran Types for
that job. Any ideas would be helpful; I am stumped.

Teresa Davis
HR Manager/Systems Administrator
Sign Productions
3
At first I thought this was easy :)

But then I READ.

Link jobhead to part-tran group on job number, then create a formula called
show

If parttran.trantype <> MFG -STK
then 1
else 0

Then add up this formula


Go to the section detial and select suppress, then this is pseudo code

If "sum for the group show" > 1
then defualtattribute

Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...

Visit www.one.org to see how the world can be changed one person at a time.



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
midwestsigncompany
Sent: Tuesday, January 03, 2006 4:52 PM
To: vantage@yahoogroups.com
Subject: [Vantage] I need help with Record Selection in Crystal


I am trying to run a Crystal Report to show me all jobs that do not
have a part transacation of MFG-STK. I currently have a report where I
have gouped by job number and can see all the part transacations for
those jobs, but I am not real sure how to only see those jobs that do
not have a part transaction that is MFG-STK. I have tried to do a
group record selectino formula of PartTran.TranType <> MFG-STK, but it
still returns the job number with all the other Part Tran Types for
that job. Any ideas would be helpful; I am stumped.

Teresa Davis
HR Manager/Systems Administrator
Sign Productions





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
Yahoo! Groups Links
4
Frank -

Thank you for this formula help. I am still learning Crystal and
this type of help is FANTASTIC!

Teresa

--- In vantage@yahoogroups.com, "Frank Zeigafuse" <fzeigafuse@l...>
wrote:
>
> At first I thought this was easy :)
>
> But then I READ.
>
> Link jobhead to part-tran group on job number, then create a
formula called
> show
>
> If parttran.trantype <> MFG -STK
> then 1
> else 0
>
> Then add up this formula
>
>
> Go to the section detial and select suppress, then this is pseudo
code
>
> If "sum for the group show" > 1
> then defualtattribute
>
> Frank Zeigafuse
> Innovative Office Products
> General Manager
> Direct Phone: 610-559-6369
> Email: fzeigafuse@L...
>
> Visit www.one.org to see how the world can be changed one person
at a time.
>
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> midwestsigncompany
> Sent: Tuesday, January 03, 2006 4:52 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] I need help with Record Selection in Crystal
>
>
> I am trying to run a Crystal Report to show me all jobs that do
not
> have a part transacation of MFG-STK. I currently have a report
where I
> have gouped by job number and can see all the part transacations
for
> those jobs, but I am not real sure how to only see those jobs that
do
> not have a part transaction that is MFG-STK. I have tried to do a
> group record selectino formula of PartTran.TranType <> MFG-STK,
but it
> still returns the job number with all the other Part Tran Types
for
> that job. Any ideas would be helpful; I am stumped.
>
> Teresa Davis
> HR Manager/Systems Administrator
> Sign Productions
>
>
>
>
>
> 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
> Yahoo! Groups Links
>