Productivity Report Problem

Hi, i have just managed to get hold of Crystal Reports 11, but im kinda new to using it and was looking for some help. Im trying to make a report that shows the overall sales of a choosen product between or on specific dates.
I have an SQL database which i have setup correctly. To make this simple, ill say these are the columns that are in the database:

Product Code
Date Sold On
Quantity Sold

Now the product code may appear in several records as it can be sold on any day. Im trying to get the report to look through the database, pick out the info i need such as a specific product code on a certain day and show how many were sold on one line like this:

Stock Code : 01-01 Total Quantity Sold on Day : 26

At the moment i can only get the report to show like this:

Stock Code : 01-01 Quantity Sold : 10
Stock Code : 01-01 Quantity Sold : 5
Stock Code : 01-01 Quantity Sold : 11

Any help on this matter would be much appreciated.the best way to do so is to execute the query with group by expression..

i.e. group by date...

other than this..
create a group section by Date in ur eport..
and insert the summary fields of Quantity Sold etc..
with the name of Product also in group section

now the situation is that u have a detail section in which the detail is printed in form of product name, quantity sold etc..

and another section has same sort of value but summarized by date..

from the form.. create the option to suppress the detail section or to suppress the group section.. whethere u want to print detail report... or whether u want only summarize data by date

best of luck
zeeshangodil@.hotmail.comsql