Using the CrossTab...?
Hi,
I've 12 product categories (CAT1, CAT2, ..., CAT12). And I've the invoices
of the products with, into the invoice details, the code of the product
category. I want show the sell totals by category by month. Like this:
---------------------------------------------
CAT1 CAT2 CAT3 .... CAT12
---------------------------------------------
JAN tot_J1 tot_J2 tot_J3 tot_J12
FEB tot_F1 tot_F2 tot_F3 tot_F12
MAR
APR
MAY
JUN
JUL
AUG etcetera etcetera
SEP
OCT
NOV
DEC
----------------------------------------------
It's possible with the CrossTab component?
Thanks
Robert
I've 12 product categories (CAT1, CAT2, ..., CAT12). And I've the invoices
of the products with, into the invoice details, the code of the product
category. I want show the sell totals by category by month. Like this:
---------------------------------------------
CAT1 CAT2 CAT3 .... CAT12
---------------------------------------------
JAN tot_J1 tot_J2 tot_J3 tot_J12
FEB tot_F1 tot_F2 tot_F3 tot_F12
MAR
APR
MAY
JUN
JUL
AUG etcetera etcetera
SEP
OCT
NOV
DEC
----------------------------------------------
It's possible with the CrossTab component?
Thanks
Robert
This discussion has been closed.
Comments
Yes, this should be possible. Take a look at the crosstab demos located in
the \RBuilder\Demos\2. CrossTabs\... directory for example on how to create
crosstab components using the crosstab designer.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com