Hi,

I am working on a requirement to show a user open purchase and sales details. However, I want the structure just like Inventory valuation report. Like, first there is a screen that has a radio buttons. When I click submit. It shows columns like Vendor, Order Ref., Order Date, PO Amount, SO Amount. 

I know from which model I have to fetch the data and manipulate however, I am confused how to create this report as same structure as Inventory Report. The screens and how to populate the data, I have to fetch manipulate the data each time the data is requested so do I need to create a new model? How do I populate the data in collapsed and expanded form? Below is the Inventory report sample. I need some assist