AnsweredAssumed Answered

multi variable report

Question asked by camcorp on Apr 18, 2013
Latest reply on Apr 19, 2013 by Mike_Mitchell

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

Outcomes