Sorry guys above i am not clear with my requirment…i hav PurchRFQCaseTable with RFQCaseId , PurchRFQTable (RFQId ) has multiple vendors with same RFQCaseId, PurchRFQLine (RFQId) which has PurchRFQReplyLine for rate and amount .
In lines rate and amount are different for same items.
Refer the Request for quote details and Request for quote reply details form
i want to generate the above report for dynamic vendors in row wise …i got the logic but in report the line body it is displaying the data in diagonal way …