How to generate Datewise Report of Products

Aug 11 2010 2:43 PM
Hi All,

i want to generate daily sales report of products. I have generated report that get date parameter and extract records based on that date.

I am facing two issues:

1)  when report displayed it only get record of 1 product. Other products are not displayed.

2) I want to set query like (select distinct Prodname, count(qty),sum(totalcost) where .........) which get product name then count qty sold on today, then sum their price and display.

Means if 5 products sold on 1-Aug-2010 then product should be displayed only one time then it should count quantity sold on that day, then sum their price.

Hope you understand my Problem. Please guys help me.