Crystal Sub-Reporting

At 08:55 AM 6/17/2004, you wrote:
>does anyone know why this makes a performance difference, in a single
>company db?

The indexes in Vantage are all multiple fields strung together, starting
with Company. If you know all the indexed fields you get a direct and
nearly instantaneous hit. If you know one or more of the left-most fields,
you can at least narrow down the search. But a field at the end of the
index does no good.

It's like a phone book, with its "Last name*First Name" index -- You can go
right to "Smith, Joe", or only scan a few pages for "Smith". But "Joe" by
it self requires scanning the whole book.

-Wayne Cox
Twenty Three -- Information Technology Consulting
828-685-2338



[Non-text portions of this message have been removed]
Dear All,
I'm having a problem with a Crystal Sub-report link which I hope/pray some
genius might be able to help me with.

I've set up a sub-report within our Job Traveller document to retrieve data
from the actual database JopOper table rather than the .dbf version which
(as usual) doesn't provide certain fields that we want.
I've created 3 formula fields in the main report to convert JobOper.dbf
fields (Job Number, AssySeq & OpSeq) to the same format as the actual
database. I create the sub-report and link to our database via ODBC using
these 3 fields.

The sub-report works and retrieves the data we require OK, the trouble is it
takes FOREVER. When you refresh the report you can see the sub-report
churning it's way through the data and then accessing the database. Takes
about 7 minutes to produce the traveller!!

I've used this approach before on other forms and the performance is fine.
Any bright ideas, anybody?
Regards,
Richard
Richard Bailey
Dudley Industries
W:+44(0)1253 738311
M:+44(0)7836 550360
Mailto: rbailey@...
Richard,
Throw a hard coded filter in the sub report for your company ID and job
open. You will find the report runs in no time.
Good luck,
Aaron Hoyt
Hittite Microwave

-----Original Message-----
From: Richard Bailey [mailto:rbailey@...]
Sent: Thursday, June 17, 2004 5:15 AM
To: vantage@yahoogroups.com
Subject: [SPAM] - [Vantage] Crystal Sub-Reporting - Email found in
subject


Dear All,
I'm having a problem with a Crystal Sub-report link which I hope/pray
some
genius might be able to help me with.

I've set up a sub-report within our Job Traveller document to retrieve
data
from the actual database JopOper table rather than the .dbf version
which
(as usual) doesn't provide certain fields that we want.
I've created 3 formula fields in the main report to convert JobOper.dbf
fields (Job Number, AssySeq & OpSeq) to the same format as the actual
database. I create the sub-report and link to our database via ODBC
using
these 3 fields.

The sub-report works and retrieves the data we require OK, the trouble
is it
takes FOREVER. When you refresh the report you can see the sub-report
churning it's way through the data and then accessing the database.
Takes
about 7 minutes to produce the traveller!!

I've used this approach before on other forms and the performance is
fine.
Any bright ideas, anybody?
Regards,
Richard
Richard Bailey
Dudley Industries
W:+44(0)1253 738311
M:+44(0)7836 550360
Mailto: rbailey@...



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 Sponsor

ADVERTISEMENT

<http://us.ard.yahoo.com/SIG=129ctss4r/M=295196.4901138.6071305.3001176/
D=groups/S=1705007183:HM/EXP=1087550932/A=2128215/R=0/SIG=10se96mf6/*htt
p://companion.yahoo.com> click here

<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=480131611>


_____

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



********************************************************************************************************************

This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual
or entity to which they are addressed. If you have received this e-mail in error please notify the system manager.

This e-mail message has been swept for the presence of computer viruses.

WARNING: All e-mail sent to this address will be received by the HMC network and is subject to archival and review
by someone other than the recipient.

********************************************************************************************************************





[Non-text portions of this message have been removed]
Sorry to appear such a dummy (rarely stopped me before, I know). Presumably
I use the Edit Selection Formula Records within the sub-report? Current
settings are,

{JobOper.JobNum} = {?Pm-@CalcJob}
and
{JobOper.AssemblySeq} = {?Pm-@CalcAssy}
and
{JobOper.OprSeq} = {?Pm-@CalcOpSeq}
and
{JobOper.Company} = {?Pm-JOBOPER.COMPANYID}

How can I hard code a filter for Open Jobs?
-----Original Message-----
From: Aaron Hoyt [mailto:hoyt@...]
Sent: 17 June 2004 11:35
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Sub-Reporting


Richard,
Throw a hard coded filter in the sub report for your company ID and job
open. You will find the report runs in no time.
Good luck,
Aaron Hoyt
Hittite Microwave

-----Original Message-----
From: Richard Bailey [mailto:rbailey@...]
Sent: Thursday, June 17, 2004 5:15 AM
To: vantage@yahoogroups.com
Subject: [SPAM] - [Vantage] Crystal Sub-Reporting - Email found in
subject


Dear All,
I'm having a problem with a Crystal Sub-report link which I hope/pray
some
genius might be able to help me with.

I've set up a sub-report within our Job Traveller document to retrieve
data
from the actual database JopOper table rather than the .dbf version
which
(as usual) doesn't provide certain fields that we want.
I've created 3 formula fields in the main report to convert JobOper.dbf
fields (Job Number, AssySeq & OpSeq) to the same format as the actual
database. I create the sub-report and link to our database via ODBC
using
these 3 fields.

The sub-report works and retrieves the data we require OK, the trouble
is it
takes FOREVER. When you refresh the report you can see the sub-report
churning it's way through the data and then accessing the database.
Takes
about 7 minutes to produce the traveller!!

I've used this approach before on other forms and the performance is
fine.
Any bright ideas, anybody?
Regards,
Richard
Richard Bailey
Dudley Industries
W:+44(0)1253 738311
M:+44(0)7836 550360
Mailto: rbailey@...



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 Sponsor

ADVERTISEMENT

<http://us.ard.yahoo.com/SIG=129ctss4r/M=295196.4901138.6071305.3001176/
D=groups/S=1705007183:HM/EXP=1087550932/A=2128215/R=0/SIG=10se96mf6/*htt
p://companion.yahoo.com> click here

<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=480131611>


_____

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




****************************************************************************
****************************************

This e-mail and any files transmitted with it are confidential and
intended solely for the use of the individual
or entity to which they are addressed. If you have received this e-mail in
error please notify the system manager.

This e-mail message has been swept for the presence of computer viruses.

WARNING: All e-mail sent to this address will be received by the HMC
network and is subject to archival and review
by someone other than the recipient.


****************************************************************************
****************************************





[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 Sponsor
ADVERTISEMENT





----------------------------------------------------------------------------
--
Yahoo! Groups Links

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

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



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

Change the
{JobOper.Company} = {?Pm-JOBOPER.COMPANYID}
from the "?Pm" (paramater filter)
To
{JobOper.Company} = "HMC"
(if your ID was HMC).

This will turbo charge your report. Ignore passing the company ID
unless you use multi company.
Good luck,
Aaron


-----Original Message-----
From: Richard Bailey [mailto:rbailey@...]
Sent: Thursday, June 17, 2004 7:37 AM
To: vantage@yahoogroups.com
Subject: [SPAM] - RE: [Vantage] Crystal Sub-Reporting - Email found in
subject


Sorry to appear such a dummy (rarely stopped me before, I know).
Presumably
I use the Edit Selection Formula Records within the sub-report? Current
settings are,

{JobOper.JobNum} = {?Pm-@CalcJob}
and
{JobOper.AssemblySeq} = {?Pm-@CalcAssy}
and
{JobOper.OprSeq} = {?Pm-@CalcOpSeq}
and
{JobOper.Company} = {?Pm-JOBOPER.COMPANYID}

How can I hard code a filter for Open Jobs?
-----Original Message-----
From: Aaron Hoyt [mailto:hoyt@...]
Sent: 17 June 2004 11:35
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Sub-Reporting


Richard,
Throw a hard coded filter in the sub report for your company ID and
job
open. You will find the report runs in no time.
Good luck,
Aaron Hoyt
Hittite Microwave

-----Original Message-----
From: Richard Bailey [mailto:rbailey@...]
Sent: Thursday, June 17, 2004 5:15 AM
To: vantage@yahoogroups.com
Subject: [SPAM] - [Vantage] Crystal Sub-Reporting - Email found in
subject


Dear All,
I'm having a problem with a Crystal Sub-report link which I hope/pray
some
genius might be able to help me with.

I've set up a sub-report within our Job Traveller document to retrieve
data
from the actual database JopOper table rather than the .dbf version
which
(as usual) doesn't provide certain fields that we want.
I've created 3 formula fields in the main report to convert
JobOper.dbf
fields (Job Number, AssySeq & OpSeq) to the same format as the actual
database. I create the sub-report and link to our database via ODBC
using
these 3 fields.

The sub-report works and retrieves the data we require OK, the trouble
is it
takes FOREVER. When you refresh the report you can see the sub-report
churning it's way through the data and then accessing the database.
Takes
about 7 minutes to produce the traveller!!

I've used this approach before on other forms and the performance is
fine.
Any bright ideas, anybody?
Regards,
Richard
Richard Bailey
Dudley Industries
W:+44(0)1253 738311
M:+44(0)7836 550360
Mailto: rbailey@...



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 Sponsor

ADVERTISEMENT


<http://us.ard.yahoo.com/SIG=129ctss4r/M=295196.4901138.6071305.3001176/

D=groups/S=1705007183:HM/EXP=1087550932/A=2128215/R=0/SIG=10se96mf6/*htt
p://companion.yahoo.com> click here


<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=480131611>


_____

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




************************************************************************
****
****************************************

This e-mail and any files transmitted with it are confidential and
intended solely for the use of the individual
or entity to which they are addressed. If you have received this
e-mail in
error please notify the system manager.

This e-mail message has been swept for the presence of computer
viruses.

WARNING: All e-mail sent to this address will be received by the HMC
network and is subject to archival and review
by someone other than the recipient.


************************************************************************
****
****************************************





[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 Sponsor
ADVERTISEMENT





------------------------------------------------------------------------
----
--
Yahoo! Groups Links

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

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.



[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 Sponsor
ADVERTISEMENT






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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

********************************************************************************************************************

This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual
or entity to which they are addressed. If you have received this e-mail in error please notify the system manager.

This e-mail message has been swept for the presence of computer viruses.

WARNING: All e-mail sent to this address will be received by the HMC network and is subject to archival and review
by someone other than the recipient.

********************************************************************************************************************
does anyone know why this makes a performance difference, in a single
company db?



Frank Zeigafuse

Innovative Office Products

General Manager

Direct Phone: 610-559-6369

Email: fzeigafuse@...



-----Original Message-----
From: Aaron Hoyt [mailto:hoyt@...]
Sent: Thursday, June 17, 2004 8:43 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Sub-Reporting


Richard,

Change the
{JobOper.Company} = {?Pm-JOBOPER.COMPANYID}
from the "?Pm" (paramater filter)
To
{JobOper.Company} = "HMC"
(if your ID was HMC).

This will turbo charge your report. Ignore passing the company ID
unless you use multi company.
Good luck,
Aaron


-----Original Message-----
From: Richard Bailey [mailto:rbailey@...]
Sent: Thursday, June 17, 2004 7:37 AM
To: vantage@yahoogroups.com
Subject: [SPAM] - RE: [Vantage] Crystal Sub-Reporting - Email found in
subject


Sorry to appear such a dummy (rarely stopped me before, I know).
Presumably
I use the Edit Selection Formula Records within the sub-report? Current
settings are,

{JobOper.JobNum} = {?Pm-@CalcJob}
and
{JobOper.AssemblySeq} = {?Pm-@CalcAssy}
and
{JobOper.OprSeq} = {?Pm-@CalcOpSeq}
and
{JobOper.Company} = {?Pm-JOBOPER.COMPANYID}

How can I hard code a filter for Open Jobs?
-----Original Message-----
From: Aaron Hoyt [mailto:hoyt@...]
Sent: 17 June 2004 11:35
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Sub-Reporting


Richard,
Throw a hard coded filter in the sub report for your company ID and
job
open. You will find the report runs in no time.
Good luck,
Aaron Hoyt
Hittite Microwave

-----Original Message-----
From: Richard Bailey [mailto:rbailey@...]
Sent: Thursday, June 17, 2004 5:15 AM
To: vantage@yahoogroups.com
Subject: [SPAM] - [Vantage] Crystal Sub-Reporting - Email found in
subject


Dear All,
I'm having a problem with a Crystal Sub-report link which I hope/pray
some
genius might be able to help me with.

I've set up a sub-report within our Job Traveller document to retrieve
data
from the actual database JopOper table rather than the .dbf version
which
(as usual) doesn't provide certain fields that we want.
I've created 3 formula fields in the main report to convert
JobOper.dbf
fields (Job Number, AssySeq & OpSeq) to the same format as the actual
database. I create the sub-report and link to our database via ODBC
using
these 3 fields.

The sub-report works and retrieves the data we require OK, the trouble
is it
takes FOREVER. When you refresh the report you can see the sub-report
churning it's way through the data and then accessing the database.
Takes
about 7 minutes to produce the traveller!!

I've used this approach before on other forms and the performance is
fine.
Any bright ideas, anybody?
Regards,
Richard
Richard Bailey
Dudley Industries
W:+44(0)1253 738311
M:+44(0)7836 550360
Mailto: rbailey@...



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 Sponsor

ADVERTISEMENT


<http://us.ard.yahoo.com/SIG=129ctss4r/M=295196.4901138.6071305.3001176/

D=groups/S=1705007183:HM/EXP=1087550932/A=2128215/R=0/SIG=10se96mf6/*htt
p://companion.yahoo.com> click here


<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=480131611>


_____

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




************************************************************************
****
****************************************

This e-mail and any files transmitted with it are confidential and
intended solely for the use of the individual
or entity to which they are addressed. If you have received this
e-mail in
error please notify the system manager.

This e-mail message has been swept for the presence of computer
viruses.

WARNING: All e-mail sent to this address will be received by the HMC
network and is subject to archival and review
by someone other than the recipient.


************************************************************************
****
****************************************





[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 Sponsor
ADVERTISEMENT





------------------------------------------------------------------------
----
--
Yahoo! Groups Links

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

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.



[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 Sponsor
ADVERTISEMENT






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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

****************************************************************************
****************************************

This e-mail and any files transmitted with it are confidential and intended
solely for the use of the individual
or entity to which they are addressed. If you have received this e-mail in
error please notify the system manager.

This e-mail message has been swept for the presence of computer viruses.

WARNING: All e-mail sent to this address will be received by the HMC network
and is subject to archival and review
by someone other than the recipient.

****************************************************************************
****************************************





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 Sponsor

ADVERTISEMENT

<http://us.ard.yahoo.com/SIG=129gocs5h/M=298184.5022502.6152625.3001176/D=gr
oups/S=1705007183:HM/EXP=1087562761/A=2164339/R=0/SIG=11e2d64in/*http://www.
netflix.com/Default?mqso=60183348> click here

<http://us.adserver.yahoo.com/l?M=298184.5022502.6152625.3001176/D=groups/S=
:HM/A=2164339/rand=814362587>


_____

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



<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the views of the sender and not necessarily the views of the company. The email and any files transmitted with it are confidential to the intended recipient at the e-mail address to which it has been addressed. It may not be disclosed or used by any other than that addressee, nor may it be copied in any way. If received in error, please delete and notify the sender via e-mail or sales@... quoting the name of the sender. Messages sent via this medium may be subject to delays, non-delivery and unauthorized alteration. This e-mail has been prepared using information believed by the author to be reliable and accurate. Unless expressly stated otherwise, this e-mail does not form part of a legally binding contract or agreement between recipient and Innovative Office Products, Inc.

Warning: Although Innovative Office Products, Inc. has taken reasonable precautions to ensure no viruses are present in this email, we cannot accept responsibility for any loss or damage arising from the use of this email or attachments. It is, therefore, your responsibility to scan attachments (if any).



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

It allows the efficient use of indexes.

Aaron

-----Original Message-----
From: Frank Zeigafuse [mailto:fzeigafuse@...]
Sent: Thursday, June 17, 2004 8:56 AM
To: vantage@yahoogroups.com
Subject: [SPAM] - RE: [Vantage] Crystal Sub-Reporting - Email found in
subject


does anyone know why this makes a performance difference, in a single
company db?



Frank Zeigafuse

Innovative Office Products

General Manager

Direct Phone: 610-559-6369

Email: fzeigafuse@...



-----Original Message-----
From: Aaron Hoyt [mailto:hoyt@...]
Sent: Thursday, June 17, 2004 8:43 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Sub-Reporting


Richard,

Change the
{JobOper.Company} = {?Pm-JOBOPER.COMPANYID}
from the "?Pm" (paramater filter)
To
{JobOper.Company} = "HMC"
(if your ID was HMC).

This will turbo charge your report. Ignore passing the company ID
unless you use multi company.
Good luck,
Aaron


-----Original Message-----
From: Richard Bailey [mailto:rbailey@...]
Sent: Thursday, June 17, 2004 7:37 AM
To: vantage@yahoogroups.com
Subject: [SPAM] - RE: [Vantage] Crystal Sub-Reporting - Email found in
subject


Sorry to appear such a dummy (rarely stopped me before, I know).
Presumably
I use the Edit Selection Formula Records within the sub-report? Current
settings are,

{JobOper.JobNum} = {?Pm-@CalcJob}
and
{JobOper.AssemblySeq} = {?Pm-@CalcAssy}
and
{JobOper.OprSeq} = {?Pm-@CalcOpSeq}
and
{JobOper.Company} = {?Pm-JOBOPER.COMPANYID}

How can I hard code a filter for Open Jobs?
-----Original Message-----
From: Aaron Hoyt [mailto:hoyt@...]
Sent: 17 June 2004 11:35
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Sub-Reporting


Richard,
Throw a hard coded filter in the sub report for your company ID and
job
open. You will find the report runs in no time.
Good luck,
Aaron Hoyt
Hittite Microwave

-----Original Message-----
From: Richard Bailey [mailto:rbailey@...]
Sent: Thursday, June 17, 2004 5:15 AM
To: vantage@yahoogroups.com
Subject: [SPAM] - [Vantage] Crystal Sub-Reporting - Email found in
subject


Dear All,
I'm having a problem with a Crystal Sub-report link which I hope/pray
some
genius might be able to help me with.

I've set up a sub-report within our Job Traveller document to retrieve
data
from the actual database JopOper table rather than the .dbf version
which
(as usual) doesn't provide certain fields that we want.
I've created 3 formula fields in the main report to convert
JobOper.dbf
fields (Job Number, AssySeq & OpSeq) to the same format as the actual
database. I create the sub-report and link to our database via ODBC
using
these 3 fields.

The sub-report works and retrieves the data we require OK, the trouble
is it
takes FOREVER. When you refresh the report you can see the sub-report
churning it's way through the data and then accessing the database.
Takes
about 7 minutes to produce the traveller!!

I've used this approach before on other forms and the performance is
fine.
Any bright ideas, anybody?
Regards,
Richard
Richard Bailey
Dudley Industries
W:+44(0)1253 738311
M:+44(0)7836 550360
Mailto: rbailey@...



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 Sponsor

ADVERTISEMENT


<http://us.ard.yahoo.com/SIG=129ctss4r/M=295196.4901138.6071305.3001176/

D=groups/S=1705007183:HM/EXP=1087550932/A=2128215/R=0/SIG=10se96mf6/*htt
p://companion.yahoo.com> click here


<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=480131611>


_____

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




************************************************************************
****
****************************************

This e-mail and any files transmitted with it are confidential and
intended solely for the use of the individual
or entity to which they are addressed. If you have received this
e-mail in
error please notify the system manager.

This e-mail message has been swept for the presence of computer
viruses.

WARNING: All e-mail sent to this address will be received by the HMC
network and is subject to archival and review
by someone other than the recipient.


************************************************************************
****
****************************************





[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 Sponsor
ADVERTISEMENT





------------------------------------------------------------------------
----
--
Yahoo! Groups Links

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

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.



[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 Sponsor
ADVERTISEMENT






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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

************************************************************************
****
****************************************

This e-mail and any files transmitted with it are confidential and
intended
solely for the use of the individual
or entity to which they are addressed. If you have received this e-mail
in
error please notify the system manager.

This e-mail message has been swept for the presence of computer viruses.


WARNING: All e-mail sent to this address will be received by the HMC
network
and is subject to archival and review
by someone other than the recipient.

************************************************************************
****
****************************************





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 Sponsor

ADVERTISEMENT

<http://us.ard.yahoo.com/SIG=129gocs5h/M=298184.5022502.6152625.3001176/
D=gr
oups/S=1705007183:HM/EXP=1087562761/A=2164339/R=0/SIG=11e2d64in/*http://
www.
netflix.com/Default?mqso=60183348> click here

<http://us.adserver.yahoo.com/l?M=298184.5022502.6152625.3001176/D=group
s/S=
:HM/A=2164339/rand=814362587>


_____

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



<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and
keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the
views of the sender and not necessarily the views of the company. The
email and any files transmitted with it are confidential to the intended
recipient at the e-mail address to which it has been addressed. It may
not be disclosed or used by any other than that addressee, nor may it be
copied in any way. If received in error, please delete and notify the
sender via e-mail or sales@... quoting the name of the sender.
Messages sent via this medium may be subject to delays, non-delivery and
unauthorized alteration. This e-mail has been prepared using information
believed by the author to be reliable and accurate. Unless expressly
stated otherwise, this e-mail does not form part of a legally binding
contract or agreement between recipient and Innovative Office Products,
Inc.

Warning: Although Innovative Office Products, Inc. has taken reasonable
precautions to ensure no viruses are present in this email, we cannot
accept responsibility for any loss or damage arising from the use of
this email or attachments. It is, therefore, your responsibility to scan
attachments (if any).



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

ADVERTISEMENT

<http://us.ard.yahoo.com/SIG=129pqsp8c/M=295196.4901138.6071305.3001176/
D=groups/S=1705007183:HM/EXP=1087563341/A=2128215/R=0/SIG=10se96mf6/*htt
p://companion.yahoo.com> click here

<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=610800263>


_____

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



********************************************************************************************************************

This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual
or entity to which they are addressed. If you have received this e-mail in error please notify the system manager.

This e-mail message has been swept for the presence of computer viruses.

WARNING: All e-mail sent to this address will be received by the HMC network and is subject to archival and review
by someone other than the recipient.

********************************************************************************************************************





[Non-text portions of this message have been removed]
Working on the pragmatic approach (and also as we're only single company) I
don't really care!
It has however cracked my problem. Hard coding the company id and using the
JobOper.JobComplete flag gives an almost instantaneous response.
Thank you Aaron (and all other interested parties) for all your help and
advice.
Regards
Richard
-----Original Message-----
From: Frank Zeigafuse [mailto:fzeigafuse@...]
Sent: 17 June 2004 13:56
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Sub-Reporting


does anyone know why this makes a performance difference, in a single
company db?



Frank Zeigafuse

Innovative Office Products

General Manager

Direct Phone: 610-559-6369

Email: fzeigafuse@...



-----Original Message-----
From: Aaron Hoyt [mailto:hoyt@...]
Sent: Thursday, June 17, 2004 8:43 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Sub-Reporting


Richard,

Change the
{JobOper.Company} = {?Pm-JOBOPER.COMPANYID}
from the "?Pm" (paramater filter)
To
{JobOper.Company} = "HMC"
(if your ID was HMC).

This will turbo charge your report. Ignore passing the company ID
unless you use multi company.
Good luck,
Aaron


-----Original Message-----
From: Richard Bailey [mailto:rbailey@...]
Sent: Thursday, June 17, 2004 7:37 AM
To: vantage@yahoogroups.com
Subject: [SPAM] - RE: [Vantage] Crystal Sub-Reporting - Email found in
subject


Sorry to appear such a dummy (rarely stopped me before, I know).
Presumably
I use the Edit Selection Formula Records within the sub-report? Current
settings are,

{JobOper.JobNum} = {?Pm-@CalcJob}
and
{JobOper.AssemblySeq} = {?Pm-@CalcAssy}
and
{JobOper.OprSeq} = {?Pm-@CalcOpSeq}
and
{JobOper.Company} = {?Pm-JOBOPER.COMPANYID}

How can I hard code a filter for Open Jobs?
-----Original Message-----
From: Aaron Hoyt [mailto:hoyt@...]
Sent: 17 June 2004 11:35
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Sub-Reporting


Richard,
Throw a hard coded filter in the sub report for your company ID and
job
open. You will find the report runs in no time.
Good luck,
Aaron Hoyt
Hittite Microwave

-----Original Message-----
From: Richard Bailey [mailto:rbailey@...]
Sent: Thursday, June 17, 2004 5:15 AM
To: vantage@yahoogroups.com
Subject: [SPAM] - [Vantage] Crystal Sub-Reporting - Email found in
subject


Dear All,
I'm having a problem with a Crystal Sub-report link which I hope/pray
some
genius might be able to help me with.

I've set up a sub-report within our Job Traveller document to retrieve
data
from the actual database JopOper table rather than the .dbf version
which
(as usual) doesn't provide certain fields that we want.
I've created 3 formula fields in the main report to convert
JobOper.dbf
fields (Job Number, AssySeq & OpSeq) to the same format as the actual
database. I create the sub-report and link to our database via ODBC
using
these 3 fields.

The sub-report works and retrieves the data we require OK, the trouble
is it
takes FOREVER. When you refresh the report you can see the sub-report
churning it's way through the data and then accessing the database.
Takes
about 7 minutes to produce the traveller!!

I've used this approach before on other forms and the performance is
fine.
Any bright ideas, anybody?
Regards,
Richard
Richard Bailey
Dudley Industries
W:+44(0)1253 738311
M:+44(0)7836 550360
Mailto: rbailey@...



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 Sponsor

ADVERTISEMENT


<http://us.ard.yahoo.com/SIG=129ctss4r/M=295196.4901138.6071305.3001176/

D=groups/S=1705007183:HM/EXP=1087550932/A=2128215/R=0/SIG=10se96mf6/*htt
p://companion.yahoo.com> click here


<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=480131611>


_____

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




************************************************************************
****
****************************************

This e-mail and any files transmitted with it are confidential and
intended solely for the use of the individual
or entity to which they are addressed. If you have received this
e-mail in
error please notify the system manager.

This e-mail message has been swept for the presence of computer
viruses.

WARNING: All e-mail sent to this address will be received by the HMC
network and is subject to archival and review
by someone other than the recipient.


************************************************************************
****
****************************************





[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 Sponsor
ADVERTISEMENT





------------------------------------------------------------------------
----
--
Yahoo! Groups Links

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

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.



[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 Sponsor
ADVERTISEMENT






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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


****************************************************************************
****************************************

This e-mail and any files transmitted with it are confidential and
intended
solely for the use of the individual
or entity to which they are addressed. If you have received this e-mail in
error please notify the system manager.

This e-mail message has been swept for the presence of computer viruses.

WARNING: All e-mail sent to this address will be received by the HMC
network
and is subject to archival and review
by someone other than the recipient.


****************************************************************************
****************************************





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 Sponsor

ADVERTISEMENT


<http://us.ard.yahoo.com/SIG=129gocs5h/M=298184.5022502.6152625.3001176/D=gr

oups/S=1705007183:HM/EXP=1087562761/A=2164339/R=0/SIG=11e2d64in/*http://www.
netflix.com/Default?mqso=60183348> click here


<http://us.adserver.yahoo.com/l?M=298184.5022502.6152625.3001176/D=groups/S=
:HM/A=2164339/rand=814362587>


_____

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



<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and
keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the
views of the sender and not necessarily the views of the company. The email
and any files transmitted with it are confidential to the intended recipient
at the e-mail address to which it has been addressed. It may not be
disclosed or used by any other than that addressee, nor may it be copied in
any way. If received in error, please delete and notify the sender via
e-mail or sales@... quoting the name of the sender. Messages sen t
via this medium may be subject to delays, non-delivery and unauthorized
alteration. This e-mail has been prepared using information believed by the
author to be reliable and accurate. Unless expressly stated otherwise, this
e-mail does not form part of a legally binding contract or agreement between
recipient and Innovative Office Products, Inc.

Warning: Although Innovative Office Products, Inc. has taken reasonable
precautions to ensure no viruses are present in this email, we cannot accept
responsibility for any loss or damage arising from the use of this email or
attachments. It is, therefore, your responsibility to scan attachments (if
any).



[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 Sponsor
ADVERTISEMENT





----------------------------------------------------------------------------
--
Yahoo! Groups Links

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

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



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

Now to blow your mind. Try adding this to any and all reports that use
ODBC and to Report Builder reports. Watch your reporting time drop.
Good luck, glad I could be of assistance.

Aaron

-----Original Message-----
From: Richard Bailey [mailto:rbailey@...]
Sent: Thursday, June 17, 2004 9:06 AM
To: vantage@yahoogroups.com
Subject: [SPAM] - RE: [Vantage] Crystal Sub-Reporting - Email found in
subject


Working on the pragmatic approach (and also as we're only single
company) I
don't really care!
It has however cracked my problem. Hard coding the company id and using
the
JobOper.JobComplete flag gives an almost instantaneous response.
Thank you Aaron (and all other interested parties) for all your help and
advice.
Regards
Richard
-----Original Message-----
From: Frank Zeigafuse [mailto:fzeigafuse@...]
Sent: 17 June 2004 13:56
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Sub-Reporting


does anyone know why this makes a performance difference, in a single
company db?



Frank Zeigafuse

Innovative Office Products

General Manager

Direct Phone: 610-559-6369

Email: fzeigafuse@...



-----Original Message-----
From: Aaron Hoyt [mailto:hoyt@...]
Sent: Thursday, June 17, 2004 8:43 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Sub-Reporting


Richard,

Change the
{JobOper.Company} = {?Pm-JOBOPER.COMPANYID}
from the "?Pm" (paramater filter)
To
{JobOper.Company} = "HMC"
(if your ID was HMC).

This will turbo charge your report. Ignore passing the company ID
unless you use multi company.
Good luck,
Aaron


-----Original Message-----
From: Richard Bailey [mailto:rbailey@...]
Sent: Thursday, June 17, 2004 7:37 AM
To: vantage@yahoogroups.com
Subject: [SPAM] - RE: [Vantage] Crystal Sub-Reporting - Email found in
subject


Sorry to appear such a dummy (rarely stopped me before, I know).
Presumably
I use the Edit Selection Formula Records within the sub-report?
Current
settings are,

{JobOper.JobNum} = {?Pm-@CalcJob}
and
{JobOper.AssemblySeq} = {?Pm-@CalcAssy}
and
{JobOper.OprSeq} = {?Pm-@CalcOpSeq}
and
{JobOper.Company} = {?Pm-JOBOPER.COMPANYID}

How can I hard code a filter for Open Jobs?
-----Original Message-----
From: Aaron Hoyt [mailto:hoyt@...]
Sent: 17 June 2004 11:35
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Sub-Reporting


Richard,
Throw a hard coded filter in the sub report for your company ID and
job
open. You will find the report runs in no time.
Good luck,
Aaron Hoyt
Hittite Microwave

-----Original Message-----
From: Richard Bailey [mailto:rbailey@...]
Sent: Thursday, June 17, 2004 5:15 AM
To: vantage@yahoogroups.com
Subject: [SPAM] - [Vantage] Crystal Sub-Reporting - Email found in
subject


Dear All,
I'm having a problem with a Crystal Sub-report link which I
hope/pray
some
genius might be able to help me with.

I've set up a sub-report within our Job Traveller document to
retrieve
data
from the actual database JopOper table rather than the .dbf version
which
(as usual) doesn't provide certain fields that we want.
I've created 3 formula fields in the main report to convert
JobOper.dbf
fields (Job Number, AssySeq & OpSeq) to the same format as the
actual
database. I create the sub-report and link to our database via ODBC
using
these 3 fields.

The sub-report works and retrieves the data we require OK, the
trouble
is it
takes FOREVER. When you refresh the report you can see the
sub-report
churning it's way through the data and then accessing the database.
Takes
about 7 minutes to produce the traveller!!

I've used this approach before on other forms and the performance is
fine.
Any bright ideas, anybody?
Regards,
Richard
Richard Bailey
Dudley Industries
W:+44(0)1253 738311
M:+44(0)7836 550360
Mailto: rbailey@...



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 Sponsor

ADVERTISEMENT



<http://us.ard.yahoo.com/SIG=129ctss4r/M=295196.4901138.6071305.3001176/


D=groups/S=1705007183:HM/EXP=1087550932/A=2128215/R=0/SIG=10se96mf6/*htt
p://companion.yahoo.com> click here



<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=480131611>


_____

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





************************************************************************
****
****************************************

This e-mail and any files transmitted with it are confidential and
intended solely for the use of the individual
or entity to which they are addressed. If you have received this
e-mail in
error please notify the system manager.

This e-mail message has been swept for the presence of computer
viruses.

WARNING: All e-mail sent to this address will be received by the HMC
network and is subject to archival and review
by someone other than the recipient.



************************************************************************
****
****************************************





[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 Sponsor
ADVERTISEMENT






------------------------------------------------------------------------
----
--
Yahoo! Groups Links

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

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.



[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 Sponsor
ADVERTISEMENT






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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


************************************************************************
****
****************************************

This e-mail and any files transmitted with it are confidential and
intended
solely for the use of the individual
or entity to which they are addressed. If you have received this
e-mail in
error please notify the system manager.

This e-mail message has been swept for the presence of computer
viruses.

WARNING: All e-mail sent to this address will be received by the HMC
network
and is subject to archival and review
by someone other than the recipient.


************************************************************************
****
****************************************





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 Sponsor

ADVERTISEMENT


<http://us.ard.yahoo.com/SIG=129gocs5h/M=298184.5022502.6152625.3001176/
D=gr

oups/S=1705007183:HM/EXP=1087562761/A=2164339/R=0/SIG=11e2d64in/*http://
www.
netflix.com/Default?mqso=60183348> click here


<http://us.adserver.yahoo.com/l?M=298184.5022502.6152625.3001176/D=group
s/S=
:HM/A=2164339/rand=814362587>


_____

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



<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and
keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the
views of the sender and not necessarily the views of the company. The
email
and any files transmitted with it are confidential to the intended
recipient
at the e-mail address to which it has been addressed. It may not be
disclosed or used by any other than that addressee, nor may it be copied
in
any way. If received in error, please delete and notify the sender via
e-mail or sales@... quoting the name of the sender. Messages sen
t
via this medium may be subject to delays, non-delivery and unauthorized
alteration. This e-mail has been prepared using information believed by
the
author to be reliable and accurate. Unless expressly stated otherwise,
this
e-mail does not form part of a legally binding contract or agreement
between
recipient and Innovative Office Products, Inc.

Warning: Although Innovative Office Products, Inc. has taken
reasonable
precautions to ensure no viruses are present in this email, we cannot
accept
responsibility for any loss or damage arising from the use of this email
or
attachments. It is, therefore, your responsibility to scan attachments
(if
any).



[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 Sponsor
ADVERTISEMENT





------------------------------------------------------------------------
----
--
Yahoo! Groups Links

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

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.



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

ADVERTISEMENT

<http://us.ard.yahoo.com/SIG=129aqac8c/M=295196.4901138.6071305.3001176/
D=groups/S=1705007183:HM/EXP=1087565126/A=2128215/R=0/SIG=10se96mf6/*htt
p://companion.yahoo.com> click here

<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=680865787>


_____

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



********************************************************************************************************************

This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual
or entity to which they are addressed. If you have received this e-mail in error please notify the system manager.

This e-mail message has been swept for the presence of computer viruses.

WARNING: All e-mail sent to this address will be received by the HMC network and is subject to archival and review
by someone other than the recipient.

********************************************************************************************************************





[Non-text portions of this message have been removed]
I may aid in selecting the proper database index.


Patrick Winter


-----Original Message-----
From: Aaron Hoyt [mailto:hoyt@...]
Sent: Thursday, June 17, 2004 8:28 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Sub-Reporting

Richard,

Now to blow your mind. Try adding this to any and all reports that use ODBC
and to Report Builder reports. Watch your reporting time drop.
Good luck, glad I could be of assistance.

Aaron

-----Original Message-----
From: Richard Bailey [mailto:rbailey@...]
Sent: Thursday, June 17, 2004 9:06 AM
To: vantage@yahoogroups.com
Subject: [SPAM] - RE: [Vantage] Crystal Sub-Reporting - Email found in
subject


Working on the pragmatic approach (and also as we're only single
company) I
don't really care!
It has however cracked my problem. Hard coding the company id and using
the
JobOper.JobComplete flag gives an almost instantaneous response.
Thank you Aaron (and all other interested parties) for all your help and
advice.
Regards
Richard
-----Original Message-----
From: Frank Zeigafuse [mailto:fzeigafuse@...]
Sent: 17 June 2004 13:56
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Sub-Reporting


does anyone know why this makes a performance difference, in a single
company db?



Frank Zeigafuse

Innovative Office Products

General Manager

Direct Phone: 610-559-6369

Email: fzeigafuse@...



-----Original Message-----
From: Aaron Hoyt [mailto:hoyt@...]
Sent: Thursday, June 17, 2004 8:43 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Sub-Reporting


Richard,

Change the
{JobOper.Company} = {?Pm-JOBOPER.COMPANYID}
from the "?Pm" (paramater filter)
To
{JobOper.Company} = "HMC"
(if your ID was HMC).

This will turbo charge your report. Ignore passing the company ID
unless you use multi company.
Good luck,
Aaron


-----Original Message-----
From: Richard Bailey [mailto:rbailey@...]
Sent: Thursday, June 17, 2004 7:37 AM
To: vantage@yahoogroups.com
Subject: [SPAM] - RE: [Vantage] Crystal Sub-Reporting - Email found in
subject


Sorry to appear such a dummy (rarely stopped me before, I know).
Presumably
I use the Edit Selection Formula Records within the sub-report?
Current
settings are,

{JobOper.JobNum} = {?Pm-@CalcJob}
and
{JobOper.AssemblySeq} = {?Pm-@CalcAssy}
and
{JobOper.OprSeq} = {?Pm-@CalcOpSeq}
and
{JobOper.Company} = {?Pm-JOBOPER.COMPANYID}

How can I hard code a filter for Open Jobs?
-----Original Message-----
From: Aaron Hoyt [mailto:hoyt@...]
Sent: 17 June 2004 11:35
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Sub-Reporting


Richard,
Throw a hard coded filter in the sub report for your company ID and
job
open. You will find the report runs in no time.
Good luck,
Aaron Hoyt
Hittite Microwave

-----Original Message-----
From: Richard Bailey [mailto:rbailey@...]
Sent: Thursday, June 17, 2004 5:15 AM
To: vantage@yahoogroups.com
Subject: [SPAM] - [Vantage] Crystal Sub-Reporting - Email found in
subject


Dear All,
I'm having a problem with a Crystal Sub-report link which I
hope/pray
some
genius might be able to help me with.

I've set up a sub-report within our Job Traveller document to
retrieve
data
from the actual database JopOper table rather than the .dbf version
which
(as usual) doesn't provide certain fields that we want.
I've created 3 formula fields in the main report to convert
JobOper.dbf
fields (Job Number, AssySeq & OpSeq) to the same format as the
actual
database. I create the sub-report and link to our database via ODBC
using
these 3 fields.

The sub-report works and retrieves the data we require OK, the
trouble
is it
takes FOREVER. When you refresh the report you can see the
sub-report
churning it's way through the data and then accessing the database.
Takes
about 7 minutes to produce the traveller!!

I've used this approach before on other forms and the performance is
fine.
Any bright ideas, anybody?
Regards,
Richard
Richard Bailey
Dudley Industries
W:+44(0)1253 738311
M:+44(0)7836 550360
Mailto: rbailey@...



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 Sponsor

ADVERTISEMENT



<http://us.ard.yahoo.com/SIG=129ctss4r/M=295196.4901138.6071305.3001176/


D=groups/S=1705007183:HM/EXP=1087550932/A=2128215/R=0/SIG=10se96mf6/*htt
p://companion.yahoo.com> click here



<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=480131611>


_____

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





************************************************************************
****
****************************************

This e-mail and any files transmitted with it are confidential and
intended solely for the use of the individual
or entity to which they are addressed. If you have received this
e-mail in
error please notify the system manager.

This e-mail message has been swept for the presence of computer
viruses.

WARNING: All e-mail sent to this address will be received by the HMC
network and is subject to archival and review
by someone other than the recipient.



************************************************************************
****
****************************************





[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 Sponsor
ADVERTISEMENT






------------------------------------------------------------------------
----
--
Yahoo! Groups Links

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

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.



[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 Sponsor
ADVERTISEMENT






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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


************************************************************************
****
****************************************

This e-mail and any files transmitted with it are confidential and
intended
solely for the use of the individual
or entity to which they are addressed. If you have received this
e-mail in
error please notify the system manager.

This e-mail message has been swept for the presence of computer
viruses.

WARNING: All e-mail sent to this address will be received by the HMC
network
and is subject to archival and review
by someone other than the recipient.


************************************************************************
****
****************************************





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 Sponsor

ADVERTISEMENT


<http://us.ard.yahoo.com/SIG=129gocs5h/M=298184.5022502.6152625.3001176/
D=gr

oups/S=1705007183:HM/EXP=1087562761/A=2164339/R=0/SIG=11e2d64in/*http://
www.
netflix.com/Default?mqso=60183348> click here


<http://us.adserver.yahoo.com/l?M=298184.5022502.6152625.3001176/D=group
s/S=
:HM/A=2164339/rand=814362587>


_____

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



<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and
keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the
views of the sender and not necessarily the views of the company. The
email
and any files transmitted with it are confidential to the intended
recipient
at the e-mail address to which it has been addressed. It may not be
disclosed or used by any other than that addressee, nor may it be copied
in
any way. If received in error, please delete and notify the sender via
e-mail or sales@... quoting the name of the sender. Messages sen
t
via this medium may be subject to delays, non-delivery and unauthorized
alteration. This e-mail has been prepared using information believed by
the
author to be reliable and accurate. Unless expressly stated otherwise,
this
e-mail does not form part of a legally binding contract or agreement
between
recipient and Innovative Office Products, Inc.

Warning: Although Innovative Office Products, Inc. has taken
reasonable
precautions to ensure no viruses are present in this email, we cannot
accept
responsibility for any loss or damage arising from the use of this email
or
attachments. It is, therefore, your responsibility to scan attachments
(if
any).



[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 Sponsor
ADVERTISEMENT





------------------------------------------------------------------------
----
--
Yahoo! Groups Links

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

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.



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

ADVERTISEMENT

<http://us.ard.yahoo.com/SIG=129aqac8c/M=295196.4901138.6071305.3001176/
D=groups/S=1705007183:HM/EXP=1087565126/A=2128215/R=0/SIG=10se96mf6/*htt
p://companion.yahoo.com> click here

<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=680865787>


_____

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



****************************************************************************
****************************************

This e-mail and any files transmitted with it are confidential and intended
solely for the use of the individual
or entity to which they are addressed. If you have received this e-mail in
error please notify the system manager.

This e-mail message has been swept for the presence of computer viruses.

WARNING: All e-mail sent to this address will be received by the HMC network
and is subject to archival and review
by someone other than the recipient.

****************************************************************************
****************************************





[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
ok, thanks I used to add it not really believing in it, but I stopped. I
guess I should add it again.



Frank Zeigafuse

Innovative Office Products

General Manager

Direct Phone: 610-559-6369

Email: fzeigafuse@...



-----Original Message-----
From: Aaron Hoyt [mailto:hoyt@...]
Sent: Thursday, June 17, 2004 9:14 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Sub-Reporting


Frank,

It allows the efficient use of indexes.

Aaron

-----Original Message-----
From: Frank Zeigafuse [mailto:fzeigafuse@...]
Sent: Thursday, June 17, 2004 8:56 AM
To: vantage@yahoogroups.com
Subject: [SPAM] - RE: [Vantage] Crystal Sub-Reporting - Email found in
subject


does anyone know why this makes a performance difference, in a single
company db?



Frank Zeigafuse

Innovative Office Products

General Manager

Direct Phone: 610-559-6369

Email: fzeigafuse@...



-----Original Message-----
From: Aaron Hoyt [mailto:hoyt@...]
Sent: Thursday, June 17, 2004 8:43 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Sub-Reporting


Richard,

Change the
{JobOper.Company} = {?Pm-JOBOPER.COMPANYID}
from the "?Pm" (paramater filter)
To
{JobOper.Company} = "HMC"
(if your ID was HMC).

This will turbo charge your report. Ignore passing the company ID
unless you use multi company.
Good luck,
Aaron


-----Original Message-----
From: Richard Bailey [mailto:rbailey@...]
Sent: Thursday, June 17, 2004 7:37 AM
To: vantage@yahoogroups.com
Subject: [SPAM] - RE: [Vantage] Crystal Sub-Reporting - Email found in
subject


Sorry to appear such a dummy (rarely stopped me before, I know).
Presumably
I use the Edit Selection Formula Records within the sub-report? Current
settings are,

{JobOper.JobNum} = {?Pm-@CalcJob}
and
{JobOper.AssemblySeq} = {?Pm-@CalcAssy}
and
{JobOper.OprSeq} = {?Pm-@CalcOpSeq}
and
{JobOper.Company} = {?Pm-JOBOPER.COMPANYID}

How can I hard code a filter for Open Jobs?
-----Original Message-----
From: Aaron Hoyt [mailto:hoyt@...]
Sent: 17 June 2004 11:35
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Sub-Reporting


Richard,
Throw a hard coded filter in the sub report for your company ID and
job
open. You will find the report runs in no time.
Good luck,
Aaron Hoyt
Hittite Microwave

-----Original Message-----
From: Richard Bailey [mailto:rbailey@...]
Sent: Thursday, June 17, 2004 5:15 AM
To: vantage@yahoogroups.com
Subject: [SPAM] - [Vantage] Crystal Sub-Reporting - Email found in
subject


Dear All,
I'm having a problem with a Crystal Sub-report link which I hope/pray
some
genius might be able to help me with.

I've set up a sub-report within our Job Traveller document to retrieve
data
from the actual database JopOper table rather than the .dbf version
which
(as usual) doesn't provide certain fields that we want.
I've created 3 formula fields in the main report to convert
JobOper.dbf
fields (Job Number, AssySeq & OpSeq) to the same format as the actual
database. I create the sub-report and link to our database via ODBC
using
these 3 fields.

The sub-report works and retrieves the data we require OK, the trouble
is it
takes FOREVER. When you refresh the report you can see the sub-report
churning it's way through the data and then accessing the database.
Takes
about 7 minutes to produce the traveller!!

I've used this approach before on other forms and the performance is
fine.
Any bright ideas, anybody?
Regards,
Richard
Richard Bailey
Dudley Industries
W:+44(0)1253 738311
M:+44(0)7836 550360
Mailto: rbailey@...



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 Sponsor

ADVERTISEMENT


<http://us.ard.yahoo.com/SIG=129ctss4r/M=295196.4901138.6071305.3001176/

D=groups/S=1705007183:HM/EXP=1087550932/A=2128215/R=0/SIG=10se96mf6/*htt
p://companion.yahoo.com> click here


<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=480131611>


_____

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




************************************************************************
****
****************************************

This e-mail and any files transmitted with it are confidential and
intended solely for the use of the individual
or entity to which they are addressed. If you have received this
e-mail in
error please notify the system manager.

This e-mail message has been swept for the presence of computer
viruses.

WARNING: All e-mail sent to this address will be received by the HMC
network and is subject to archival and review
by someone other than the recipient.


************************************************************************
****
****************************************





[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 Sponsor
ADVERTISEMENT





------------------------------------------------------------------------
----
--
Yahoo! Groups Links

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

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.



[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 Sponsor
ADVERTISEMENT






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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

************************************************************************
****
****************************************

This e-mail and any files transmitted with it are confidential and
intended
solely for the use of the individual
or entity to which they are addressed. If you have received this e-mail
in
error please notify the system manager.

This e-mail message has been swept for the presence of computer viruses.


WARNING: All e-mail sent to this address will be received by the HMC
network
and is subject to archival and review
by someone other than the recipient.

************************************************************************
****
****************************************





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 Sponsor

ADVERTISEMENT

<http://us.ard.yahoo.com/SIG=129gocs5h/M=298184.5022502.6152625.3001176/
D=gr
oups/S=1705007183:HM/EXP=1087562761/A=2164339/R=0/SIG=11e2d64in/*http://
www.
netflix.com/Default?mqso=60183348> click here

<http://us.adserver.yahoo.com/l?M=298184.5022502.6152625.3001176/D=group
s/S=
:HM/A=2164339/rand=814362587>


_____

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



<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and
keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the
views of the sender and not necessarily the views of the company. The
email and any files transmitted with it are confidential to the intended
recipient at the e-mail address to which it has been addressed. It may
not be disclosed or used by any other than that addressee, nor may it be
copied in any way. If received in error, please delete and notify the
sender via e-mail or sales@... quoting the name of the sender.
Messages sent via this medium may be subject to delays, non-delivery and
unauthorized alteration. This e-mail has been prepared using information
believed by the author to be reliable and accurate. Unless expressly
stated otherwise, this e-mail does not form part of a legally binding
contract or agreement between recipient and Innovative Office Products,
Inc.

Warning: Although Innovative Office Products, Inc. has taken reasonable
precautions to ensure no viruses are present in this email, we cannot
accept responsibility for any loss or damage arising from the use of
this email or attachments. It is, therefore, your responsibility to scan
attachments (if any).



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

ADVERTISEMENT

<http://us.ard.yahoo.com/SIG=129pqsp8c/M=295196.4901138.6071305.3001176/
D=groups/S=1705007183:HM/EXP=1087563341/A=2128215/R=0/SIG=10se96mf6/*htt
p://companion.yahoo.com> click here

<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=610800263>


_____

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



****************************************************************************
****************************************

This e-mail and any files transmitted with it are confidential and intended
solely for the use of the individual
or entity to which they are addressed. If you have received this e-mail in
error please notify the system manager.

This e-mail message has been swept for the presence of computer viruses.

WARNING: All e-mail sent to this address will be received by the HMC network
and is subject to archival and review
by someone other than the recipient.

****************************************************************************
****************************************





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

ADVERTISEMENT

<http://us.ard.yahoo.com/SIG=12916ne9d/M=298184.5022502.6152625.3001176/D=gr
oups/S=1705007183:HM/EXP=1087564618/A=2164339/R=0/SIG=11e2d64in/*http://www.
netflix.com/Default?mqso=60183348> click here

<http://us.adserver.yahoo.com/l?M=298184.5022502.6152625.3001176/D=groups/S=
:HM/A=2164339/rand=292175351>


_____

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



<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the views of the sender and not necessarily the views of the company. The email and any files transmitted with it are confidential to the intended recipient at the e-mail address to which it has been addressed. It may not be disclosed or used by any other than that addressee, nor may it be copied in any way. If received in error, please delete and notify the sender via e-mail or sales@... quoting the name of the sender. Messages sent via this medium may be subject to delays, non-delivery and unauthorized alteration. This e-mail has been prepared using information believed by the author to be reliable and accurate. Unless expressly stated otherwise, this e-mail does not form part of a legally binding contract or agreement between recipient and Innovative Office Products, Inc.

Warning: Although Innovative Office Products, Inc. has taken reasonable precautions to ensure no viruses are present in this email, we cannot accept responsibility for any loss or damage arising from the use of this email or attachments. It is, therefore, your responsibility to scan attachments (if any).



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

I guess it is just "one of those things"



Frank Zeigafuse

Innovative Office Products

General Manager

Direct Phone: 610-559-6369

Email: fzeigafuse@...



-----Original Message-----
From: Aaron Hoyt [mailto:hoyt@...]
Sent: Thursday, June 17, 2004 9:28 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Sub-Reporting


Richard,

Now to blow your mind. Try adding this to any and all reports that use
ODBC and to Report Builder reports. Watch your reporting time drop.
Good luck, glad I could be of assistance.

Aaron

-----Original Message-----
From: Richard Bailey [mailto:rbailey@...]
Sent: Thursday, June 17, 2004 9:06 AM
To: vantage@yahoogroups.com
Subject: [SPAM] - RE: [Vantage] Crystal Sub-Reporting - Email found in
subject


Working on the pragmatic approach (and also as we're only single
company) I
don't really care!
It has however cracked my problem. Hard coding the company id and using
the
JobOper.JobComplete flag gives an almost instantaneous response.
Thank you Aaron (and all other interested parties) for all your help and
advice.
Regards
Richard
-----Original Message-----
From: Frank Zeigafuse [mailto:fzeigafuse@...]
Sent: 17 June 2004 13:56
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Sub-Reporting


does anyone know why this makes a performance difference, in a single
company db?



Frank Zeigafuse

Innovative Office Products

General Manager

Direct Phone: 610-559-6369

Email: fzeigafuse@...



-----Original Message-----
From: Aaron Hoyt [mailto:hoyt@...]
Sent: Thursday, June 17, 2004 8:43 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Sub-Reporting


Richard,

Change the
{JobOper.Company} = {?Pm-JOBOPER.COMPANYID}
from the "?Pm" (paramater filter)
To
{JobOper.Company} = "HMC"
(if your ID was HMC).

This will turbo charge your report. Ignore passing the company ID
unless you use multi company.
Good luck,
Aaron


-----Original Message-----
From: Richard Bailey [mailto:rbailey@...]
Sent: Thursday, June 17, 2004 7:37 AM
To: vantage@yahoogroups.com
Subject: [SPAM] - RE: [Vantage] Crystal Sub-Reporting - Email found in
subject


Sorry to appear such a dummy (rarely stopped me before, I know).
Presumably
I use the Edit Selection Formula Records within the sub-report?
Current
settings are,

{JobOper.JobNum} = {?Pm-@CalcJob}
and
{JobOper.AssemblySeq} = {?Pm-@CalcAssy}
and
{JobOper.OprSeq} = {?Pm-@CalcOpSeq}
and
{JobOper.Company} = {?Pm-JOBOPER.COMPANYID}

How can I hard code a filter for Open Jobs?
-----Original Message-----
From: Aaron Hoyt [mailto:hoyt@...]
Sent: 17 June 2004 11:35
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Sub-Reporting


Richard,
Throw a hard coded filter in the sub report for your company ID and
job
open. You will find the report runs in no time.
Good luck,
Aaron Hoyt
Hittite Microwave

-----Original Message-----
From: Richard Bailey [mailto:rbailey@...]
Sent: Thursday, June 17, 2004 5:15 AM
To: vantage@yahoogroups.com
Subject: [SPAM] - [Vantage] Crystal Sub-Reporting - Email found in
subject


Dear All,
I'm having a problem with a Crystal Sub-report link which I
hope/pray
some
genius might be able to help me with.

I've set up a sub-report within our Job Traveller document to
retrieve
data
from the actual database JopOper table rather than the .dbf version
which
(as usual) doesn't provide certain fields that we want.
I've created 3 formula fields in the main report to convert
JobOper.dbf
fields (Job Number, AssySeq & OpSeq) to the same format as the
actual
database. I create the sub-report and link to our database via ODBC
using
these 3 fields.

The sub-report works and retrieves the data we require OK, the
trouble
is it
takes FOREVER. When you refresh the report you can see the
sub-report
churning it's way through the data and then accessing the database.
Takes
about 7 minutes to produce the traveller!!

I've used this approach before on other forms and the performance is
fine.
Any bright ideas, anybody?
Regards,
Richard
Richard Bailey
Dudley Industries
W:+44(0)1253 738311
M:+44(0)7836 550360
Mailto: rbailey@...



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 Sponsor

ADVERTISEMENT



<http://us.ard.yahoo.com/SIG=129ctss4r/M=295196.4901138.6071305.3001176/


D=groups/S=1705007183:HM/EXP=1087550932/A=2128215/R=0/SIG=10se96mf6/*htt
p://companion.yahoo.com> click here



<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=480131611>


_____

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





************************************************************************
****
****************************************

This e-mail and any files transmitted with it are confidential and
intended solely for the use of the individual
or entity to which they are addressed. If you have received this
e-mail in
error please notify the system manager.

This e-mail message has been swept for the presence of computer
viruses.

WARNING: All e-mail sent to this address will be received by the HMC
network and is subject to archival and review
by someone other than the recipient.



************************************************************************
****
****************************************





[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 Sponsor
ADVERTISEMENT






------------------------------------------------------------------------
----
--
Yahoo! Groups Links

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

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.



[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 Sponsor
ADVERTISEMENT






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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


************************************************************************
****
****************************************

This e-mail and any files transmitted with it are confidential and
intended
solely for the use of the individual
or entity to which they are addressed. If you have received this
e-mail in
error please notify the system manager.

This e-mail message has been swept for the presence of computer
viruses.

WARNING: All e-mail sent to this address will be received by the HMC
network
and is subject to archival and review
by someone other than the recipient.


************************************************************************
****
****************************************





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 Sponsor

ADVERTISEMENT


<http://us.ard.yahoo.com/SIG=129gocs5h/M=298184.5022502.6152625.3001176/
D=gr

oups/S=1705007183:HM/EXP=1087562761/A=2164339/R=0/SIG=11e2d64in/*http://
www.
netflix.com/Default?mqso=60183348> click here


<http://us.adserver.yahoo.com/l?M=298184.5022502.6152625.3001176/D=group
s/S=
:HM/A=2164339/rand=814362587>


_____

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



<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and
keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the
views of the sender and not necessarily the views of the company. The
email
and any files transmitted with it are confidential to the intended
recipient
at the e-mail address to which it has been addressed. It may not be
disclosed or used by any other than that addressee, nor may it be copied
in
any way. If received in error, please delete and notify the sender via
e-mail or sales@... quoting the name of the sender. Messages sen
t
via this medium may be subject to delays, non-delivery and unauthorized
alteration. This e-mail has been prepared using information believed by
the
author to be reliable and accurate. Unless expressly stated otherwise,
this
e-mail does not form part of a legally binding contract or agreement
between
recipient and Innovative Office Products, Inc.

Warning: Although Innovative Office Products, Inc. has taken
reasonable
precautions to ensure no viruses are present in this email, we cannot
accept
responsibility for any loss or damage arising from the use of this email
or
attachments. It is, therefore, your responsibility to scan attachments
(if
any).



[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 Sponsor
ADVERTISEMENT





------------------------------------------------------------------------
----
--
Yahoo! Groups Links

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

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.



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

ADVERTISEMENT

<http://us.ard.yahoo.com/SIG=129aqac8c/M=295196.4901138.6071305.3001176/
D=groups/S=1705007183:HM/EXP=1087565126/A=2128215/R=0/SIG=10se96mf6/*htt
p://companion.yahoo.com> click here

<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=680865787>


_____

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



****************************************************************************
****************************************

This e-mail and any files transmitted with it are confidential and intended
solely for the use of the individual
or entity to which they are addressed. If you have received this e-mail in
error please notify the system manager.

This e-mail message has been swept for the presence of computer viruses.

WARNING: All e-mail sent to this address will be received by the HMC network
and is subject to archival and review
by someone other than the recipient.

****************************************************************************
****************************************





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

ADVERTISEMENT

<http://us.ard.yahoo.com/SIG=129jtoqb6/M=298184.5022502.6152625.3001176/D=gr
oups/S=1705007183:HM/EXP=1087565468/A=2164339/R=0/SIG=11e2d64in/*http://www.
netflix.com/Default?mqso=60183348> click here

<http://us.adserver.yahoo.com/l?M=298184.5022502.6152625.3001176/D=groups/S=
:HM/A=2164339/rand=834376147>


_____

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



<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the views of the sender and not necessarily the views of the company. The email and any files transmitted with it are confidential to the intended recipient at the e-mail address to which it has been addressed. It may not be disclosed or used by any other than that addressee, nor may it be copied in any way. If received in error, please delete and notify the sender via e-mail or sales@... quoting the name of the sender. Messages sent via this medium may be subject to delays, non-delivery and unauthorized alteration. This e-mail has been prepared using information believed by the author to be reliable and accurate. Unless expressly stated otherwise, this e-mail does not form part of a legally binding contract or agreement between recipient and Innovative Office Products, Inc.

Warning: Although Innovative Office Products, Inc. has taken reasonable precautions to ensure no viruses are present in this email, we cannot accept responsibility for any loss or damage arising from the use of this email or attachments. It is, therefore, your responsibility to scan attachments (if any).



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