Hi! I am in full blown gray matter gridlock!
I have this report I created in Crystal Reporting (V. 8.5.0299) that I use with Mas90. The problem is (Mas90) (stinketh mightily) (sorry) the fields for the Division, Vendor Number and Vendor Name. The Division and Vendor Number are seperate entities in the area of Mas90 that I am pulling totals from. However, they are combined in other areas of Mas90 that I am referencing to get the Vendor Name...I think.
For Example two vendors: Vendor 30-001172 and Vendor 00-001172. the "30" and the "00" are the Division and sometimes the rest of the number is identical. When I run my report, it shows the correct division "30" and correct Number following, but rather than give me the actual vendor name associated with the information given, it will print the one that starts with the "00". Since all the information that I need for my report is in one field of Mas90 EXCEPT the name, how can I get Crystal to look at the "VendorMaster" and return the correct name for each particular invoice?
Not sure if that makes sense to someone not looking at it, and I apologize. Here is the SQL Query it it will help:
SELECT
APH_JobDistDetail."Division", APH_JobDistDetail."VendorNumber", APH_JobDistDetail."InvoiceNumber", APH_JobDistDetail."JobNumber", APH_JobDistDetail."CostCode", APH_JobDistDetail."CostType", APH_JobDistDetail."DistributionAmount",
AP1_VendorMaster."VendorName"
FROM
"APH_JobDistDetail" APH_JobDistDetail,
"AP1_VendorMaster" AP1_VendorMaster
WHERE
APH_JobDistDetail."VendorNumber" = AP1_VendorMaster."VendorNumber" AND
APH_JobDistDetail."JobNumber" = 'CATS'
ORDER BY
APH_JobDistDetail."CostCode" ASC
any help will be greatly appreciated! Thanks