Socarsky
Well-known member
Two queries retrieve data at the same time into two Dataset that they populated separately so that using them in one report like below. One of them retrieves sales details the other payment details both have relationship and as you can see one sales details row related two payment rows and we need to show them under sales details.
I mean this, how do I add Dataset2's PaymentType and PaymentAmount below of DataSet1's rows as a result of its payment's details like above that screen capture. And There is something I need to emphasis that PaymentType can be two, three row but most of it can be only one row. How Do I do this? Help me please I'm open ideas.
I mean this, how do I add Dataset2's PaymentType and PaymentAmount below of DataSet1's rows as a result of its payment's details like above that screen capture. And There is something I need to emphasis that PaymentType can be two, three row but most of it can be only one row. How Do I do this? Help me please I'm open ideas.
