Skip to main content

Dear All,

I want to create different output report designer value based on Subaccount that stated on PO Line, how can I make this? for example :
Sub : 00-000000-STV-00, I want to show Stevedoring as return value from Subaccount on third segment

Sub : 00-000000-VES-00, I want to show Vessel as return value from Subaccount on third segment

how can I make this work on report designer?

Thanks

Hello,

It seems like you want to connect to SegmentValue table and print the Description.

 

I could not find another post joining SegmentValue on Subaccounts.  I did find one post where a user connected to SegmentValue table to solve an Inventory SubItem report:

I hope this leads you to an answer, or inspires someone to add more details here on how to join the table.

Laura


@yosephadjie As a follow up to what Laura posted, you could make a long expression of chained IIF() statements switching the subaccount with the hardcoded description.


Reply