I want to desing a stock report like this

 

 

Date           Material           Type       S/P        Quantity

 

10/02/2009  Pen              Geltype   Sold       10 Items

                     Paper          A3           Sold         1 Bundal

                     Note Book   Scribling  Sold         5 Books

 

11/02/2009  Notebook    Scribling  Purchase 10 Books

                    Pen              Geltype   Purchase  5 Items

                    Paper           A4           Purchase  2 Bundals

 

 

In this report i am using more than 3 access tables,I run a query and

bind the data to a dataset.

 

and by using this code

 

 

but the dataset data is not reflecting in the report...

while design I connect the database by using  command only

in command ... the query i written was "SELECT  date,material,type,sp,quantity from stock"

 

Kindly help me to get output from this probs