I need to add phone number from Table "Ship-to Address" in purchase order report and apply conditional formatting on it, i have some idea that we cannot apply conditional formatting in Word layout but we can in RDLC layout. I alos know that we can not add fields to the data set of built in layouts.
So, i created a new RDLC report in AL language and included "Purcahse Header" table as dataset and inside it i also included fields from table "Purchase Line" following this document. But when i run the report in business central data of the fields from "Purchase Line" is showing on report but data of fields from "Purchase Header" is not showing.
I need suggestions to achieve my goal.