crystal report problem

[sjose]

hi friends,
i'm new to reporting in win app.. so i need a great help.. my problem is..
i want to show a report that populate data from two tables. & i used the sql query like this.
dim _Ssql as string=""
_Ssql="Select d1.id, d1.name, c1.name from Dress d1, Color c1 where " _
& " c1.id=d1.c and d1.id=10 "

Hope u got my query...
i'm using the sql server , so i created a crystal report and add the fields from the two tables. now i used the below code to show the report

dim objds as new Dataset
dim _Cconnect as new GetConnection
objds=_Cconnect.GetAll(ssql)

dim crt as new Report1
crt.setDatasource(objds)
CrystalReportViewer1.ReportSource=crt

The main problem is when show the report it displays all the records.. but its not taking the data from dataset. ie it should show only 1 record.. How can i resolve this...
cheers...

[Hack]

Moved to reporting

[brucevde]

You are passing the GetAll method the sql statement from a variable called SSQL. Should it not be _SSQL?

[sjose]

hi,
GetAll() --> is a function which will return a dataset for the _ssql Query..
Do you have any idea about Addcommand in the crystal report????