Page 1 of 1

Crosstab report

Posted: Fri Aug 26, 2011 11:03 am
by jmiller
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


Crosstab report

Posted: Mon Aug 29, 2011 7:25 am
by HighAley
Hello.

Yes, it is possible. Please, see the attached report template.

Thank you.

Crosstab report

Posted: Wed Aug 31, 2011 7:15 am
by jmiller
Thank you! I am pretty sure I can work with this.

Crosstab report

Posted: Wed Aug 31, 2011 10:51 pm
by Andrew
Great!