one wizard should show to user to ask for date. Call this one as analysis date. The view formati is like this.

product code| productname|qoh(location-1)|qoh(locatio-2)...qoh(location-n)| incoming(summ of all locations) | out going=(sum of all locations out going quantity and sales delicered quantity after analysis date.). I want to prepare Html view, Pdf report and excel report. Please can any one help me.. what concepts i have to use in odoo-7?