Is there a simple way to gewt the Vendor Purchase Point Email to print on the RFQ form rather than the Vendor Header Email? at the moment when we print RFQs the email being grabbed is the one from the vendor header (usually the accounts email) however each purchase point for some vendors will have its own email. It makes more sense to me that the emil address for the purchase point we are contacting to buy the item off should be on the form rather than the one on the header level.
So Ive tried adjusting the SSRS report to find the purchase point email but havent had much luck. Ive got it in the calculated fields for the RDD, in the Function for the dataset on the SSRS form with the new field created as well however when i print the form although the RDD and SSRS are cleary comunicating (because its not erroring out), it still doesnt seem to be bringing anything into the field. See screenshots attached.