Report Queries - HELP!

Hi, I am having some issues converting my queries to build a report.
I have some great maintenance reports that I'd like to build reports for, but having some tough luck.
Basically, when I run it in query analyzer, the results are perfect, and just want to get the same results in a report format, that I can work with.
I tried using the wizard, but it seems to bomb on build. Even when I get past the wizard the execution bombs.
Some of these scripts have variables, cursors, and even temp tables, but sure there must be a way to get this working in RS.
Please help!!

Are you puting the script in a Stored Proc and running that? That is the cleanest way of running it. also, dont do it from the wizzard but from scratch or update the datasource of the existing report to point to the SP. Make sure you change the type from text to store proc for the data source.

Hello,
If you are using SP with temp tables, use SET
FMTONLY OFF
for the SP to work in report.
Gopal