Passing an SQL statement into Crystal Reports

[bontyboy]

I am tyring to query data out of my Db and pass it into crystal reports and display it based on what the user searches for. How do you pass a SQL statement into crystal reports through VB. I am using the crystal report component but I cant find a method or property that will update my crystal report. Here is my code.

sSQL = "SELECT * FROM Tracking"
sGroup = "GROUP BY Date HAVING User=" & txtAdd(16).Text

if len(sGroup) > 0 Then sGroup
CrystalReport1. ? (this is where I am stuck)
CrystalReport1.PrintReport

Note: This is my first time using crystal reports and I am not very familiar with its methods and properties. I have been playing around with it but I can't get it to work. I created the report and it displays data based on the user name I inserted but I wanted to update it based on what the user queries out in VB.

[Ishamel]

Try using the SelectionFormula property.

CrystalReport1.SelectionFormula = sSQL

Hope this helps.