First off, you need an instance of your report .rpt file in your solution, so that u can modify it in run time, and pass info to the report. Keep in mind that the examples i may give are all in VB
, but its similar enough. So, u need to add a component to your solution (viewer form), the component u need is the ReportDocument.
Once that is created, and linked to the report file your working on (instance name myNiceRep), u then can use that instance to pass info to your report, like this:
Dim paramValue as String = "Hello!"
And thats it! (If i understood your question well of course... ;) )
Oh!.. and for the SQL query.. well, i use the Selection Assistant... its not quite like SQL, but u can comfortably write what you´d write in the WHERE clause of an Sql query right there.
Hope it helps!