How do you use a dynamic sql statement for a report

[sk8er1]

I have a dynamic sql statement that I use as the dataset for a crystal report. I built the crystal report on a stored procedure that uses COALESCE ...depending on what values the user filled in. When I run the report, the report prompts based on the stored procedure.
I used a dataset, in which i dragged the stored proc onto the VB.NET form. I rather use the dynamic sql string to populate the report....How can i do it that way...