Custom report on existing database need crosstab reports

We are designing reports for Open ERP the database is Postgresql reporting tool used is jasper reports we are stucked with crosstab reports we need help for crosstab reports as per our needs i will provide database copy and template for what we want in report you can use either crosstab function from Postgresql's library or from jasper reports feature (for pgsql function you will need to design dynamic jasper report) regards govind99