Crosstab report
Posted: Fri Aug 26, 2011 11:03 am
Is it possible to create the following type of crosstab report?
Company(C1,C2,C3)
ABC,Atlantic,0.75
XYZ,Central,0.50
Product(P1,P2,P3)
Small Nut,5mm,1.00
Small Bolt,7mm,2.00
Details(D1,D2,D3)
ABC,Small Nut,500
ABC,Small Bolt,350
XYZ,Small Nut,750
P1
P2 P3
------
C1 C2 C3 | D3 D4(D3*P3*C3)
Small Nut Small Bolt
5mm 1.00 7mm 2.00
------------ ------------
ABC Atlantic 0.75 | 500 375.00 350 525.00
XYZ Central 0.50 | 750 562.50
------------ ------------
1250 937.50 350 525.00
Company(C1,C2,C3)
ABC,Atlantic,0.75
XYZ,Central,0.50
Product(P1,P2,P3)
Small Nut,5mm,1.00
Small Bolt,7mm,2.00
Details(D1,D2,D3)
ABC,Small Nut,500
ABC,Small Bolt,350
XYZ,Small Nut,750
P1
P2 P3
------
C1 C2 C3 | D3 D4(D3*P3*C3)
Small Nut Small Bolt
5mm 1.00 7mm 2.00
------------ ------------
ABC Atlantic 0.75 | 500 375.00 350 525.00
XYZ Central 0.50 | 750 562.50
------------ ------------
1250 937.50 350 525.00