First create a reportviewer and then report.
create a dataset,in dataset create a table using table adapter tool.
add columns in the table according to the need.the content of the table must be equal to the content that
is retrieved.now consider report viewer as rpviewer and report as rpt,write this code to bind the dataset
with the Msreport(rpt).Find the *bindingsource which is present in reportviewer(below).
Query = .....;
adapter.fill(datasetname,"table name of the dataset");
*bindingsourcename.datasource = datasetname;
It works Good!!