2 Replies Latest reply on Apr 19, 2013 6:53 AM by Mike_Mitchell

    multi variable report

    camcorp

      I'm trying to build a report with many views. The main indicator is the gross margin

      The report is build with 4 countries and 26 branches and 6 product lines

       

       

      In summary

      report by month (12) by country (4) comparing each country for the same period

      (6) report by month (12) by country for each product line

       

      countrymonth 1
      month 2
      ...
      month 12
      country 1



      country 2



      country 3


       

       

       

      then for each product line a similar report (6)

       

       

      report by branch

      report by month (12) by branch (26)

      report by month by branch (26) and product line (6)

       

       

      branchmonth1...Month 12
      branch 1


      branch 26


       

       

      then a report for each product line (6)

       

       

      report by country

      12 month report for each country compared with one and years before

      12 month report for each country for each product line compared with one and years before

       

       

      Header 1month 1...Month 12
      current year


      last year


      2 years befor


       

      the a report for each product line (6)

       

       

      report by branch

      12 month report for each branch compared with one and years before

      12 month report for each branch for each product line compared with one and years before

      Header 1month 1...Month 12
      current year


      last year


      2 years befor


      then for each product line

       

      I have used the cross tab report, but it required to many relationships

      12 month relationships for each 26 branch relationsships and for 4 by each country and 6 product line

       

      or I have to generate a different table for every variable?

       

      The main data table is as follow

      Country, Branch, product line, month, sales, cost of sales

       

      I have to build for each table a chart.

      In the end the port must be generated in PDF, for each report I think its better to have a separete layout

      thanks in advance

      CAMCORP

        • 1. Re: multi variable report
          RubenVanDenBoogaard

          Hi CAMCORP,

           

          I would use a reporting table with the fields Country(ID), Branch(ID), month 1 to 12 and make 12 relations to the main data table using the Country, Branch and month relation.

          Then make as many records as needed in that table and fill them with the Country and Branches.  Use sorting and finding to make the report needed.

           

          If you add the year in the table you can produce the report by country using the same table.

           

          Hope that helps,

           

          Best regards,

           

          Ruben van den Boogaard

          Infomatics Software

          ruben@infomatics.nl

          • 2. Re: multi variable report
            Mike_Mitchell

            Ruben's option works well. Another option is to build the report using variables or global fields and HTML tables.

             

            Mike