61: Report Builder - What was run yesterday

Yahoo Archive
1
Thanks. I will try it!

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of pjw@...
Sent: Monday, June 20, 2005 7:32 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 61: Report Builder - What was run yesterday.


Why the left outer joins?

LaborHead to LaborDtl using (Company, LaborHedSeq)
LaborDtl to JobOpr using (Company, JobNum, AssemblySeq, OprSeq

Filter your date on LaborHed.PayrollDate which is a index.

Build the report step by step previewing after each table added.
Add the table first as an inner join, then preview, change to outer join the
preview.
When it dies in performance you will know why.

Patrick Winter
sSc Specialty Screw Corporation
Vantage 6.10.514, Progress 9.1D08, Windows 2003 Server, Crystal 8.5.3.975


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Juliet Martin
Sent: Thursday, June 16, 2005 5:18 PM
To: vantage@yahoogroups.com
Subject: [Vantage] 61: Report Builder - What was run yesterday.

I am trying to write a report to see what was run in a certain department
the day before. I have tried the following two joins:

LaborHead - LaborDtl (innerjoin) Company, EmpNum LaborDtl - JobOper
(leftouter) Company, Maching JobNum, AsmSeq, OprSeq
****************************************************************************
**************
LaborDtl - JobOper (leftouter) Company, Maching JobNum, AsmSeq, OprSeq

All of these are filtering on Company on the Master Table, Date Range, and
WC

This report runs for hours. Does anyone have a better solution or spot my
problem?

Thanks!



Juliet Martin
Information Manager
Rosenboom Machine & Tool, Inc.
Sheldon, IA 51201
712-324-4854 x1217



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 write a report to see what was run in a certain department the day before. I have tried the following two joins:

LaborHead - LaborDtl (innerjoin) Company, EmpNum
LaborDtl - JobOper (leftouter) Company, Maching JobNum, AsmSeq, OprSeq
******************************************************************************************
LaborDtl - JobOper (leftouter) Company, Maching JobNum, AsmSeq, OprSeq

All of these are filtering on Company on the Master Table, Date Range, and WC

This report runs for hours. Does anyone have a better solution or spot my problem?

Thanks!



Juliet Martin
Information Manager
Rosenboom Machine & Tool, Inc.
Sheldon, IA 51201
712-324-4854 x1217
3
One thing I frequently do with Labor Reports is add an additional filter on the detail sequence number to be greater than the first one at some designated starting point (usually first one of the year). It means running one report filtered on date to find the "seed" sequence and then using this early in the filter - also means using all index fields related to that sequence number in the linking if possible.

Will speed the report many times over.

-Todd C.

-----Original Message-----
From: Juliet Martin [mailto:jmartin@...]
Sent: Thursday, June 16, 2005 5:18 PM
To: vantage@yahoogroups.com
Subject: [Vantage] 61: Report Builder - What was run yesterday.


I am trying to write a report to see what was run in a certain department the day before. I have tried the following two joins:

LaborHead - LaborDtl (innerjoin) Company, EmpNum
LaborDtl - JobOper (leftouter) Company, Maching JobNum, AsmSeq, OprSeq
******************************************************************************************
LaborDtl - JobOper (leftouter) Company, Maching JobNum, AsmSeq, OprSeq

All of these are filtering on Company on the Master Table, Date Range, and WC

This report runs for hours. Does anyone have a better solution or spot my problem?

Thanks!



Juliet Martin
Information Manager
Rosenboom Machine & Tool, Inc.
Sheldon, IA 51201
712-324-4854 x1217



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


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* 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]
4
Funny. I was searching through the archives looking for your previous message on the same thing. I am glad you resent this. I am doing that now.

Thanks!

JM

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Todd Caughey
Sent: Friday, June 17, 2005 8:09 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 61: Report Builder - What was run yesterday.


One thing I frequently do with Labor Reports is add an additional filter on the detail sequence number to be greater than the first one at some designated starting point (usually first one of the year). It means running one report filtered on date to find the "seed" sequence and then using this early in the filter - also means using all index fields related to that sequence number in the linking if possible.

Will speed the report many times over.

-Todd C.

-----Original Message-----
From: Juliet Martin [mailto:jmartin@...]
Sent: Thursday, June 16, 2005 5:18 PM
To: vantage@yahoogroups.com
Subject: [Vantage] 61: Report Builder - What was run yesterday.


I am trying to write a report to see what was run in a certain department the day before. I have tried the following two joins:

LaborHead - LaborDtl (innerjoin) Company, EmpNum
LaborDtl - JobOper (leftouter) Company, Maching JobNum, AsmSeq, OprSeq
******************************************************************************************
LaborDtl - JobOper (leftouter) Company, Maching JobNum, AsmSeq, OprSeq

All of these are filtering on Company on the Master Table, Date Range, and WC

This report runs for hours. Does anyone have a better solution or spot my problem?

Thanks!



Juliet Martin
Information Manager
Rosenboom Machine & Tool, Inc.
Sheldon, IA 51201
712-324-4854 x1217
5
As it happens I am working on benchmarks now for a presentation at the User-4-User conference in Chicago in August on data dictionay, table linking and report performance - mostly with RB but techniques should apply to Crystal too. One of the measures will be seeding the start point in large tables. So the technique was already in mind when I saw your post.
-Todd C.

-----Original Message-----
From: Juliet Martin [mailto:jmartin@...]
Sent: Friday, June 17, 2005 9:21 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 61: Report Builder - What was run yesterday.


Funny. I was searching through the archives looking for your previous message on the same thing. I am glad you resent this. I am doing that now.

Thanks!

JM

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Todd Caughey
Sent: Friday, June 17, 2005 8:09 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 61: Report Builder - What was run yesterday.


One thing I frequently do with Labor Reports is add an additional filter on the detail sequence number to be greater than the first one at some designated starting point (usually first one of the year). It means running one report filtered on date to find the "seed" sequence and then using this early in the filter - also means using all index fields related to that sequence number in the linking if possible.

Will speed the report many times over.

-Todd C.

-----Original Message-----
From: Juliet Martin [mailto:jmartin@...]
Sent: Thursday, June 16, 2005 5:18 PM
To: vantage@yahoogroups.com
Subject: [Vantage] 61: Report Builder - What was run yesterday.


I am trying to write a report to see what was run in a certain department the day before. I have tried the following two joins:

LaborHead - LaborDtl (innerjoin) Company, EmpNum
LaborDtl - JobOper (leftouter) Company, Maching JobNum, AsmSeq, OprSeq
******************************************************************************************
LaborDtl - JobOper (leftouter) Company, Maching JobNum, AsmSeq, OprSeq

All of these are filtering on Company on the Master Table, Date Range, and WC

This report runs for hours. Does anyone have a better solution or spot my problem?

Thanks!



Juliet Martin
Information Manager
Rosenboom Machine & Tool, Inc.
Sheldon, IA 51201
712-324-4854 x1217



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


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* 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]
6
Todd-

I made a new report only using laborhed and then filtered on yesterday's date. All of the laborhedseq #'s are ????? Same with the LaborDtl. Am I choosing the wrong field?

Thanks

JM

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Todd Caughey
Sent: Friday, June 17, 2005 9:31 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 61: Report Builder - What was run yesterday.


As it happens I am working on benchmarks now for a presentation at the User-4-User conference in Chicago in August on data dictionay, table linking and report performance - mostly with RB but techniques should apply to Crystal too. One of the measures will be seeding the start point in large tables. So the technique was already in mind when I saw your post.
-Todd C.

-----Original Message-----
From: Juliet Martin [mailto:jmartin@...]
Sent: Friday, June 17, 2005 9:21 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 61: Report Builder - What was run yesterday.


Funny. I was searching through the archives looking for your previous message on the same thing. I am glad you resent this. I am doing that now.

Thanks!

JM

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Todd Caughey
Sent: Friday, June 17, 2005 8:09 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 61: Report Builder - What was run yesterday.


One thing I frequently do with Labor Reports is add an additional filter on the detail sequence number to be greater than the first one at some designated starting point (usually first one of the year). It means running one report filtered on date to find the "seed" sequence and then using this early in the filter - also means using all index fields related to that sequence number in the linking if possible.

Will speed the report many times over.

-Todd C.

-----Original Message-----
From: Juliet Martin [mailto:jmartin@...]
Sent: Thursday, June 16, 2005 5:18 PM
To: vantage@yahoogroups.com
Subject: [Vantage] 61: Report Builder - What was run yesterday.


I am trying to write a report to see what was run in a certain department the day before. I have tried the following two joins:

LaborHead - LaborDtl (innerjoin) Company, EmpNum
LaborDtl - JobOper (leftouter) Company, Maching JobNum, AsmSeq, OprSeq
******************************************************************************************
LaborDtl - JobOper (leftouter) Company, Maching JobNum, AsmSeq, OprSeq

All of these are filtering on Company on the Master Table, Date Range, and WC

This report runs for hours. Does anyone have a better solution or spot my problem?

Thanks!
7
Hi Todd I cannot make this conference could you email the presentation to me
off line. I would really appreciate it.

Thanks, in advance

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: Todd Caughey [mailto:caugheyt@...]
Sent: Friday, June 17, 2005 10:31 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 61: Report Builder - What was run yesterday.


As it happens I am working on benchmarks now for a presentation at the
User-4-User conference in Chicago in August on data dictionay, table linking
and report performance - mostly with RB but techniques should apply to
Crystal too. One of the measures will be seeding the start point in large
tables. So the technique was already in mind when I saw your post. -Todd C.

-----Original Message-----
From: Juliet Martin [mailto:jmartin@...]
Sent: Friday, June 17, 2005 9:21 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 61: Report Builder - What was run yesterday.


Funny. I was searching through the archives looking for your previous
message on the same thing. I am glad you resent this. I am doing that now.


Thanks!

JM

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
Todd Caughey
Sent: Friday, June 17, 2005 8:09 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 61: Report Builder - What was run yesterday.


One thing I frequently do with Labor Reports is add an additional filter on
the detail sequence number to be greater than the first one at some
designated starting point (usually first one of the year). It means running
one report filtered on date to find the "seed" sequence and then using this
early in the filter - also means using all index fields related to that
sequence number in the linking if possible.

Will speed the report many times over.

-Todd C.

-----Original Message-----
From: Juliet Martin [mailto:jmartin@...]
Sent: Thursday, June 16, 2005 5:18 PM
To: vantage@yahoogroups.com
Subject: [Vantage] 61: Report Builder - What was run yesterday.


I am trying to write a report to see what was run in a certain department
the day before. I have tried the following two joins:

LaborHead - LaborDtl (innerjoin) Company, EmpNum
LaborDtl - JobOper (leftouter) Company, Maching JobNum, AsmSeq, OprSeq
****************************************************************************
**************
LaborDtl - JobOper (leftouter) Company, Maching JobNum, AsmSeq, OprSeq

All of these are filtering on Company on the Master Table, Date Range, and
WC

This report runs for hours. Does anyone have a better solution or spot my
problem?

Thanks!



Juliet Martin
Information Manager
Rosenboom Machine & Tool, Inc.
Sheldon, IA 51201
712-324-4854 x1217



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


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* 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]



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
8
I'll need to coordinate that with Calvin since he's running "the show". I certainly don't have any problem with that but to be fair to attendees it would probably have to be after the conference some time. Another factor....I need to finish the benchmarking and the Powerpoint (in between all my regular job stuff) there is a lot of work left compiling the numbers because by my current methodology I try to make each "run" as even as possible (close RB, flush Mfgwk61, restart RB, etc....) - sort of a slow process.

-Todd C.

-----Original Message-----
From: Frank Zeigafuse [mailto:fzeigafuse@...]
Sent: Friday, June 17, 2005 9:53 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 61: Report Builder - What was run yesterday.


Hi Todd I cannot make this conference could you email the presentation to me
off line. I would really appreciate it.

Thanks, in advance

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: Todd Caughey [mailto:caugheyt@...]
Sent: Friday, June 17, 2005 10:31 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 61: Report Builder - What was run yesterday.


As it happens I am working on benchmarks now for a presentation at the
User-4-User conference in Chicago in August on data dictionay, table linking
and report performance - mostly with RB but techniques should apply to
Crystal too. One of the measures will be seeding the start point in large
tables. So the technique was already in mind when I saw your post. -Todd C.

-----Original Message-----
From: Juliet Martin [mailto:jmartin@...]
Sent: Friday, June 17, 2005 9:21 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 61: Report Builder - What was run yesterday.


Funny. I was searching through the archives looking for your previous
message on the same thing. I am glad you resent this. I am doing that now.


Thanks!

JM

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
Todd Caughey
Sent: Friday, June 17, 2005 8:09 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 61: Report Builder - What was run yesterday.


One thing I frequently do with Labor Reports is add an additional filter on
the detail sequence number to be greater than the first one at some
designated starting point (usually first one of the year). It means running
one report filtered on date to find the "seed" sequence and then using this
early in the filter - also means using all index fields related to that
sequence number in the linking if possible.

Will speed the report many times over.

-Todd C.

-----Original Message-----
From: Juliet Martin [mailto:jmartin@...]
Sent: Thursday, June 16, 2005 5:18 PM
To: vantage@yahoogroups.com
Subject: [Vantage] 61: Report Builder - What was run yesterday.


I am trying to write a report to see what was run in a certain department
the day before. I have tried the following two joins:

LaborHead - LaborDtl (innerjoin) Company, EmpNum
LaborDtl - JobOper (leftouter) Company, Maching JobNum, AsmSeq, OprSeq
****************************************************************************
**************
LaborDtl - JobOper (leftouter) Company, Maching JobNum, AsmSeq, OprSeq

All of these are filtering on Company on the Master Table, Date Range, and
WC

This report runs for hours. Does anyone have a better solution or spot my
problem?

Thanks!



Juliet Martin
Information Manager
Rosenboom Machine & Tool, Inc.
Sheldon, IA 51201
712-324-4854 x1217



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


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* 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]



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


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* 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]
9
Why the left outer joins?

LaborHead to LaborDtl using (Company, LaborHedSeq)
LaborDtl to JobOpr using (Company, JobNum, AssemblySeq, OprSeq

Filter your date on LaborHed.PayrollDate which is a index.

Build the report step by step previewing after each table added.
Add the table first as an inner join, then preview, change to outer join the
preview.
When it dies in performance you will know why.

Patrick Winter
sSc Specialty Screw Corporation
Vantage 6.10.514, Progress 9.1D08, Windows 2003 Server, Crystal 8.5.3.975


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Juliet Martin
Sent: Thursday, June 16, 2005 5:18 PM
To: vantage@yahoogroups.com
Subject: [Vantage] 61: Report Builder - What was run yesterday.

I am trying to write a report to see what was run in a certain department
the day before. I have tried the following two joins:

LaborHead - LaborDtl (innerjoin) Company, EmpNum LaborDtl - JobOper
(leftouter) Company, Maching JobNum, AsmSeq, OprSeq
****************************************************************************
**************
LaborDtl - JobOper (leftouter) Company, Maching JobNum, AsmSeq, OprSeq

All of these are filtering on Company on the Master Table, Date Range, and
WC

This report runs for hours. Does anyone have a better solution or spot my
problem?

Thanks!



Juliet Martin
Information Manager
Rosenboom Machine & Tool, Inc.
Sheldon, IA 51201
712-324-4854 x1217



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