Need help with linking fields in excel report builder

(0) Share

Report

Posted on by Katie Pieczynski

3,225

Hello,

I created a report using one of Vicotrias views and adding additional tables. Everything was working okay until I added the PM Address MSTR table.

I had to add this table to get the country code and country to pull in. Once I added this table my data brings in multiple rows of the same data. I have tried left outer and equals (on Vendor ID) and I have tried to link it to the view and to the PM Vendor Master file. Am I missing something? My tables are below

view_AP_Apply

PM Vendor Master File

Address Electronic Funds Transfer Master

PM Paid Transaction History File

PM Address MSTR

Thanks for any help.

*This post is locked for comments

All responses (3)

Answers (1)

Mariano Gomez 26,225 on at

Like (0)

Report

RE: Need help with linking fields in excel report builder

Well, it must be, so I am sure I can get a Mark as Answer on my reply above? :-)
Katie Pieczynski 3,225 on at

Like (0)

Report

RE: Need help with linking fields in excel report builder

Thanks Mariano!

Yes I am just needing it for the primary address and of course the vendors have multiple address. I cant believe I didnt think about that. (Must be because it is Friday)
Verified answer

Mariano Gomez 26,225 on at

Like (0)

Report

RE: Need help with linking fields in excel report builder

The question is, the country code for which address though. The query will show as many records per address for each line of the apply, for a specific vendor if you do not filter the address ID. Are you looking to add the country code for the remit to address? Otherwise, the vendor master table already contains the country colum.