Return data from a related row

Printed From: Crystal Reports Book — Forum Name: Technical Questions

Posted By: mabrown — 12 Feb 2016 at 4:13am

I am sure this is simple. I have a table with
Item number, Price and cross number.
ABCD, 2.00, 1234
1234, 4.00, ABCD
What I wan to do is for Item ABCD select the price for the cross number in this case the result should be 4 instead of 2.
Thank you

Posted By: praveeng — 15 Feb 2016 at 1:51am

Hi Mabrown,

As per my knowledge, to achieve your requirement we need to use sub report.

Create a sub report with displaying only "Price column" and link main reports "Price and Cross Number" fileds with "Item Number".
Pleace the Subreport in price column in main report and test the report.

--Praveen G