If you do your reporting in a group footer for quote header the last "records" for line and qty should be the ones that will show - that is, still in the "buffer" so to speak. Just remember to turn off the record band.
-Todd C.
-----Original Message-----
From: Larry Barriere [mailto:larrybarriere@...]
Sent: Wednesday, February 02, 2005 1:27 PM
To: Vantage Group
Subject: [Vantage] Report Builder Quote
I am trying to create a report using QuoteHD, QuoteDtl and QuoteQty.
What I would like to see is the last line of the Quote only. Then the detail of the Selling Qty and Unit Price from the QuoteQTy file.
I tried using the Maximum function to get the last line only. But I could not figure out how to do it.
I know by grouping the Quote Line I can get the last line number but then I lose the detail of the unit price and selling qty. If I add the Selling Qty and Unit price to the record line I get all of the record for all the lines. I only want the the records for the las tline of the quote.
Ex:
Quote Num LN Selling Qty Unit Price
11111 8 10 $ 500.00
20 $ 400.00
30 $ 300.00
Larry Barriere
barriere@...
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
[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
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
-Todd C.
-----Original Message-----
From: Larry Barriere [mailto:larrybarriere@...]
Sent: Wednesday, February 02, 2005 1:27 PM
To: Vantage Group
Subject: [Vantage] Report Builder Quote
I am trying to create a report using QuoteHD, QuoteDtl and QuoteQty.
What I would like to see is the last line of the Quote only. Then the detail of the Selling Qty and Unit Price from the QuoteQTy file.
I tried using the Maximum function to get the last line only. But I could not figure out how to do it.
I know by grouping the Quote Line I can get the last line number but then I lose the detail of the unit price and selling qty. If I add the Selling Qty and Unit price to the record line I get all of the record for all the lines. I only want the the records for the las tline of the quote.
Ex:
Quote Num LN Selling Qty Unit Price
11111 8 10 $ 500.00
20 $ 400.00
30 $ 300.00
Larry Barriere
barriere@...
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
[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
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]