sounds like a join issue.
you have to join quote number on the header and the detail tables.
Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...
-----Original Message-----
From: Karen Brodniak [mailto:karen.brodniak@...]
Sent: Monday, November 08, 2004 12:31 PM
To: Vantage Group (E-mail)
Subject: [Vantage] Report Builder Help
LeavesHello,
I am writing a report that shows quoted jobs in a particular time period,
whether the quote was ordered, the order quantity, and unit price. My
problem is the lines are duplicating. If there are two lines in the quote,
each line appears 2 times, if there are 3 lines, each line appears 3 times
and so on. I have tried every approach that I know to get this to stop with
no luck. Any help is appreciated. Also, if any of you have an RB or Crystal
report similar to this, can I please get a copy?
Also, does anyone have a report that shows the quoted set-up and production
hours vs.. actual set-up and production hours?
Thanks,
Karen Brodniak
Accounting Manager
425-742-7011 X44
Fax 425-353-8945
karen.brodniak@...
[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=129riismv/M=294855.5468653.6549235.3001176/D=gr
oups/S=1705007183:HM/EXP=1100021417/A=2376776/R=0/SIG=11ldm1jvc/*http://prom
otions.yahoo.com/ydomains2004/index.html> click here
<http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=groups/S=
:HM/A=2376776/rand=475315483>
_____
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]
you have to join quote number on the header and the detail tables.
Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...
-----Original Message-----
From: Karen Brodniak [mailto:karen.brodniak@...]
Sent: Monday, November 08, 2004 12:31 PM
To: Vantage Group (E-mail)
Subject: [Vantage] Report Builder Help
LeavesHello,
I am writing a report that shows quoted jobs in a particular time period,
whether the quote was ordered, the order quantity, and unit price. My
problem is the lines are duplicating. If there are two lines in the quote,
each line appears 2 times, if there are 3 lines, each line appears 3 times
and so on. I have tried every approach that I know to get this to stop with
no luck. Any help is appreciated. Also, if any of you have an RB or Crystal
report similar to this, can I please get a copy?
Also, does anyone have a report that shows the quoted set-up and production
hours vs.. actual set-up and production hours?
Thanks,
Karen Brodniak
Accounting Manager
425-742-7011 X44
Fax 425-353-8945
karen.brodniak@...
[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=129riismv/M=294855.5468653.6549235.3001176/D=gr
oups/S=1705007183:HM/EXP=1100021417/A=2376776/R=0/SIG=11ldm1jvc/*http://prom
otions.yahoo.com/ydomains2004/index.html> click here
<http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=groups/S=
:HM/A=2376776/rand=475315483>
_____
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]