Hi to All,

Greetings!

I am new in crystal report and i am currently using CR 11. 

I want to create a new Report for our Sales table.

The format should be like this:

                                              Sales Report

                                       Nov-2009   Dec-2009  Jan 2009  upto Nov 2010
Product Name
                           
Product 1                            100            100             1000              1000
Product 2                                0              10               999                    0

The fields are:

SalesDate
ProductName
No_Sales

I can generate the total sales by single month only, however i am having difficulty to generate the report using the above format.   

for your assistance, please...

many thanks,
archel

Hi LockWelle, that solved my query.. many thanks i haven't done crosstab also, now i already explore it.



Archel