Report Builder - joing to MEMO table

Yahoo Archive
1
I have done this in the other direction (Memo to InvcHead) using right outer
join and filtering for related-to-table = 'InvcHead' and InvoiceNum = a user
defined field (MemoKey) calculated as NUMERIC(Key1). But this limits you to
just these two tables. Make the related-to-table filter first so it ignores
other memo file types or it could run a very long time. I suspect you could
do it the other way and conditionally (based on the InvoiceNum=MemoKey)
print a memo text line after the invoice info if you want to see all the
invoices plus any memos for them. I think you can only use the first 254 or
so characters of the memo text. I could not get the join on a calculated
field method to work but did not try real hard either.

-Todd Caughey
Harvey Vogel Mfg.

-----Original Message-----
From: Wayne Cox [mailto:wmc@...]
Sent: Thursday, February 22, 2001 2:16 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder - joing to MEMO table


Hi All,
I'm trying to use Report Builder to list open A/R invoices (in
InvcHead) along with any corresponding Memos. The common fields between
them, InvcHead.InvoiceNum (integer) and Memo.Key1 (string) are different
data types, so Report Builder doesn't want to join the two. Is there any
way to do this, or am I SOL with using R.B. here?

Is there any way to get around this with the Export Utility, or other
tools? I have ProVision, but only know enough Progress to be dangerous
right now [managed to clean up our Country table though :) ]

-Thanks,
Wayne Cox





Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=163100.1330039.2920210.2/D=egroupmail/S=1700007183:N/
A=524804/*http://www.classmates.com/index.tf?s=2629> Classmates.com
Click here for Classmates.com

<http://us.adserver.yahoo.com/l?M=163100.1330039.2920210.2/D=egroupmail/S=17
00007183:N/A=524804/rand=177972535>

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



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]
2
Hi All,
I'm trying to use Report Builder to list open A/R invoices (in
InvcHead) along with any corresponding Memos. The common fields between
them, InvcHead.InvoiceNum (integer) and Memo.Key1 (string) are different
data types, so Report Builder doesn't want to join the two. Is there any
way to do this, or am I SOL with using R.B. here?

Is there any way to get around this with the Export Utility, or other
tools? I have ProVision, but only know enough Progress to be dangerous
right now [managed to clean up our Country table though :) ]

-Thanks,
Wayne Cox
3
I have uploaded the report for all into Yahoo Groups. The report shows all
open invoices by customer with the memos associated with the invoice. I
don't really know how it worked, but it did. I can't get a report with PO
number and memos to work. If anyone else has figured this out, I would
really appreciate to know how you did it. Thanks.

Alex Neutgens
Controller
Circuit Check, Inc.
763-694-4110

-----Original Message-----
From: Wayne Cox [SMTP:wmc@...]
Sent: Thursday, February 22, 2001 2:16 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder - joing to MEMO table

Hi All,
I'm trying to use Report Builder to list open A/R invoices (in
InvcHead) along with any corresponding Memos. The common fields between
them, InvcHead.InvoiceNum (integer) and Memo.Key1 (string) are different
data types, so Report Builder doesn't want to join the two. Is there any
way to do this, or am I SOL with using R.B. here?

Is there any way to get around this with the Export Utility, or other
tools? I have ProVision, but only know enough Progress to be dangerous
right now [managed to clean up our Country table though :) ]

-Thanks,
Wayne Cox





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



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

It has been a while since I tried this but, create calculated string fields
from the invoice and line numbers and use them in your join to the memo
table.

Regards
Jim Stetter
-----Original Message-----
From: Wayne Cox [mailto:wmc@...]
Sent: Thursday, February 22, 2001 3:16 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder - joing to MEMO table


Hi All,
I'm trying to use Report Builder to list open A/R invoices (in
InvcHead) along with any corresponding Memos. The common fields between
them, InvcHead.InvoiceNum (integer) and Memo.Key1 (string) are different
data types, so Report Builder doesn't want to join the two. Is there any
way to do this, or am I SOL with using R.B. here?

Is there any way to get around this with the Export Utility, or other
tools? I have ProVision, but only know enough Progress to be dangerous
right now [managed to clean up our Country table though :) ]

-Thanks,
Wayne Cox




Yahoo! Groups Sponsor

Click here for Classmates.com


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



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



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