Passing SQL statement to Dataset of report

Does anyone know how to pass a SQL statement to a dataset of a report? You used to be able to do this with Crystal and found it a really helpful tool.
Any help would be appreciatedAlthough there might be a way to do this you would be leaving a major
security hole open. You can pretty much do whatever you need to do but you
need to switch your thinking around to RS being the place that pulls the
information together to create the appropriate query. You can pass
parameters, you can have conditional code that changes the where clause, you
can have code behind that does things. Plus when you integrate you can send
a URL or use web services. There is a lot of flexibility and you can
probably do what you want but you might need to think about things
differently and utilize the features that RS provides.
Bruce L-C
"PLSH" <PLSH@.discussions.microsoft.com> wrote in message
news:B32D68AB-898C-4B82-86E3-C656091D5A2A@.microsoft.com...
> Does anyone know how to pass a SQL statement to a dataset of a report? You
used to be able to do this with Crystal and found it a really helpful tool.
> Any help would be appreciated
>