Question How do I get a report like the details of this thread?

Socarsky

Well-known member
Joined
Dec 27, 2012
Messages
173
Location
Jakarta/Indonesia
Programming Experience
Beginner
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.
howdoiknow2.png

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.
howdoiknow.png
 
Back
Top