Report help

system · June 30, 2005, 2:39pm

Thanks Sarah and Bob. It's working now.

Cliff

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of sarah.vareschi@...
Sent: Thursday, June 30, 2005 9:51 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report help

You will need to join on more than just company and job# - add
assemblyseq
and oprseq joins into it and that should fix it...

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of
Cliff Drumeller
Sent: Thursday, June 30, 2005 12:48 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Report help

Hey All

An Opportunity - I have two simple report builder reports pictured
below. The first is a single table pull from JobOper. The second is a
single table pull from LaborDtl. I'm trying to combine the two by
joining on company and job number. Result is a mushroom cloud. It turns
a 3 page report into a nineteen page report with data from whenever the
job started not the required day.

Has anyone succeeded in creating something close and could give me a
hand. The result would be an excellent report if I could get it to work.

Help Please

Cliff Drumeller
IT Manager
Mass Precision Sheetmetal, Inc.
408 954 0200 ex 217
408 314 7420 cell

[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/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

* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .

________________________________

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

system · May 21, 2001, 3:51pm

Ok if you can follow this email and understand what I am looking for you are
probably a step ahead of me. One of our engineers is requesting a report
that shows for a part, the purchased components, and if there are any
assemblies, the purchased components for that assembly, and a total of
subcontract cost and production hours for these. If this makes any sense to
anyone and you want to throw some suggestions my way.. I know Report Builder
well but this just doesnt sound fun.

Thanks.
Greg

system · May 21, 2001, 3:55pm

Sounds like you'll need crystal for this report because RB cant handle
subreports and it sounds like you will have to generate them.

Oleg Tumarkin
Systems Administrator

-----Original Message-----
From: Greg Gillette [SMTP:ggillette@...]
Sent: Monday, May 21, 2001 2:54 PM
To: 'vantage@egroups.com'
Subject: [Vantage] Report help

Ok if you can follow this email and understand what I am looking for you
are
probably a step ahead of me. One of our engineers is requesting a report
that shows for a part, the purchased components, and if there are any
assemblies, the purchased components for that assembly, and a total of
subcontract cost and production hours for these. If this makes any sense
to
anyone and you want to throw some suggestions my way.. I know Report
Builder
well but this just doesnt sound fun.

Thanks.
Greg

To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to: http://groups.yahoo.c
om/group/vantage/files/. Note: You must have already linked your email
address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

system · August 1, 2001, 11:22am

I am trying to get a report to give the following.

Makeoeverjob# and the Original job#

How would I do about doing this. The job#'s are different. Is there a
way to reference the original job# so that I can print out what the
mjob# is and what the original job# was.

Thanks

STeve

system · August 1, 2001, 11:54am

Does your 'makeoverjob#' utilize your original job#? When we do a makeover
job (which we call a 'Rework' job), we use the job# of the original job with
an 'R' at the end of it, so it is simple to get the original job from that.

-----Original Message-----
From: sbeals@... [mailto:sbeals@...]
Sent: Wednesday, August 01, 2001 10:58 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Report help

I am trying to get a report to give the following.

Makeoeverjob# and the Original job#

How would I do about doing this. The job#'s are different. Is there a
way to reference the original job# so that I can print out what the
mjob# is and what the original job# was.

Thanks

STeve

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 http://docs.yahoo.com/info/terms/

system · August 1, 2001, 12:27pm

No, it is given a new job#, but starts with an M. For example,
M0005554 is a job#, just like 000855 is one. I'm trying to find a
way to see if M0005554 is a makeover job for 000855.

--- In vantage@y..., sarah.vareschi@n... wrote:
> Does your 'makeoverjob#' utilize your original job#? When we do a
makeover
> job (which we call a 'Rework' job), we use the job# of the original
job with
> an 'R' at the end of it, so it is simple to get the original job
from that.
>
>
> -----Original Message-----
> From: sbeals@b... [mailto:sbeals@b...]
> Sent: Wednesday, August 01, 2001 10:58 AM
> To: vantage@y...
> Subject: [Vantage] Report help
>
>
> I am trying to get a report to give the following.
>
> Makeoeverjob# and the Original job#
>
> How would I do about doing this. The job#'s are different. Is there
a
> way to reference the original job# so that I can print out what the
> mjob# is and what the original job# was.
>
> Thanks
>
> STeve
>
>
>
> 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
http://docs.yahoo.com/info/terms/

system · August 1, 2001, 1:11pm

You could use a VBForm in the Job Head, and maintain the OriginalJob# there.
Then, that field would be available in you vantage database and also in any
reports. However, this would require a user to maintain another field.

-----Original Message-----
From: sbeals@... [mailto:sbeals@...]
Sent: Wednesday, August 01, 2001 11:56 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Report help

No, it is given a new job#, but starts with an M. For example,
M0005554 is a job#, just like 000855 is one. I'm trying to find a
way to see if M0005554 is a makeover job for 000855.

--- In vantage@y..., sarah.vareschi@n... wrote:
> Does your 'makeoverjob#' utilize your original job#? When we do a
makeover
> job (which we call a 'Rework' job), we use the job# of the original
job with
> an 'R' at the end of it, so it is simple to get the original job
from that.
>
>
> -----Original Message-----
> From: sbeals@b... [mailto:sbeals@b...]
> Sent: Wednesday, August 01, 2001 10:58 AM
> To: vantage@y...
> Subject: [Vantage] Report help
>
>
> I am trying to get a report to give the following.
>
> Makeoeverjob# and the Original job#
>
> How would I do about doing this. The job#'s are different. Is there
a
> way to reference the original job# so that I can print out what the
> mjob# is and what the original job# was.
>
> Thanks
>
> STeve
>
>
>
> 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
http://docs.yahoo.com/info/terms/

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 http://docs.yahoo.com/info/terms/

system · August 1, 2001, 1:19pm

Using a User Defined field on the makover job's header for the original job
number (or a VB form field) might be the only way to make a link. Or, make
an comment entry such as MO:xxxxxx and parse for "MO:". Or, maybe a project
ID identical to the original job could be entered on the makeover job header
(not sure what impact project codes have sinc we don't use them). With
these you could write reports to link to the original job using an aliased
second link to the various job tables. Just some top of head thoughts. We
use the original job number with an R prefix.
-Todd C.

-----Original Message-----
From: sbeals@... [mailto:sbeals@...]
Sent: Wednesday, August 01, 2001 10:56 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Report help

No, it is given a new job#, but starts with an M. For example,
M0005554 is a job#, just like 000855 is one. I'm trying to find a
way to see if M0005554 is a makeover job for 000855.

--- In vantage@y..., sarah.vareschi@n... wrote:
> Does your 'makeoverjob#' utilize your original job#? When we do a
makeover
> job (which we call a 'Rework' job), we use the job# of the original
job with
> an 'R' at the end of it, so it is simple to get the original job
from that.
>
>
> -----Original Message-----
> From: sbeals@b... [mailto:sbeals@b...]
> Sent: Wednesday, August 01, 2001 10:58 AM
> To: vantage@y...
> Subject: [Vantage] Report help
>
>
> I am trying to get a report to give the following.
>
> Makeoeverjob# and the Original job#
>
> How would I do about doing this. The job#'s are different. Is there
a
> way to reference the original job# so that I can print out what the
> mjob# is and what the original job# was.
>
> Thanks
>
> STeve
>
>
>
> 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/.
<http://groups.yahoo.com/group/vantage/files/.>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/ <http://docs.yahoo.com/info/terms/>

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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .

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

system · June 30, 2005, 12:48pm

Hey All

An Opportunity - I have two simple report builder reports pictured
below. The first is a single table pull from JobOper. The second is a
single table pull from LaborDtl. I'm trying to combine the two by
joining on company and job number. Result is a mushroom cloud. It turns
a 3 page report into a nineteen page report with data from whenever the
job started not the required day.

Has anyone succeeded in creating something close and could give me a
hand. The result would be an excellent report if I could get it to work.

Help Please

Cliff Drumeller
IT Manager
Mass Precision Sheetmetal, Inc.
408 954 0200 ex 217
408 314 7420 cell

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

system · June 30, 2005, 12:51pm

You will need to join on more than just company and job# - add assemblyseq
and oprseq joins into it and that should fix it...

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Cliff Drumeller
Sent: Thursday, June 30, 2005 12:48 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Report help

Hey All

An Opportunity - I have two simple report builder reports pictured
below. The first is a single table pull from JobOper. The second is a
single table pull from LaborDtl. I'm trying to combine the two by
joining on company and job number. Result is a mushroom cloud. It turns
a 3 page report into a nineteen page report with data from whenever the
job started not the required day.

Has anyone succeeded in creating something close and could give me a
hand. The result would be an excellent report if I could get it to work.

Help Please

Cliff Drumeller
IT Manager
Mass Precision Sheetmetal, Inc.
408 954 0200 ex 217
408 314 7420 cell

[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/links
Yahoo! Groups Links

Topic		Replies	Views
FW: Report help Yahoo Archive	0	372	June 30, 2005
RB report Yahoo Archive	14	892	June 18, 2002
Report Builder? Yahoo Archive	5	305	June 25, 2007
Report Builder Help! Yahoo Archive	4	285	November 2, 2001
BAQ Report Query Question Yahoo Archive	5	359	February 4, 2009

Report help

Related Topics