Reports help

Hello,

i’m looking for a way to make a chart and summary that shows the quantity of events per month per client and still cant get it the way i want

I have a database where every event is stored with a client id and a timestamp for every insert.

i’d like to have something like this
JAN FEB MAR ABR MAY JUN JUL AGO SEPT OCT NOV DEC
CLIENT A 1 5 10 0 2 1 6 3 1 3 9 0
CLIENT B 23 12 32 4 11 16 25 21 9 12 11 8
CLIENT C 21 23 22 18 19 20 23 26 27 20 22 19

Re: Reports help

I would create a view in MySQL and then just display it.

Regards,
Scott.

Re: Reports help

I saw an example on the SC web, using pivot tables, but i cant find the crosstable option on my scriptcase