Generate Report Export from Stored Procedure

I have what should be a simple task, but I cannot find any information on
how to accomplish it. All I want is a stored procedure that I can call on
demand to export a report to a given format, path, and file name. I have
found ways to write a VB.Net application to do this using the "Render"
command, but it sure seems like I should be able to do it directly from SQL
Server.
Any help would be greatly appreciated!!!
John A. Prejean
Guardian Computer
john@.gcit.netT-SQL is not ".NET enabled" yet (sounds like more support will be in SQL
2005). You might try sp_OACreate in the meantime.
Jeff
"John A. Prejean" <john@.gcit.net> wrote in message
news:etrheKdlEHA.3476@.tk2msftngp13.phx.gbl...
> I have what should be a simple task, but I cannot find any information on
> how to accomplish it. All I want is a stored procedure that I can call on
> demand to export a report to a given format, path, and file name. I have
> found ways to write a VB.Net application to do this using the "Render"
> command, but it sure seems like I should be able to do it directly from
SQL
> Server.
> Any help would be greatly appreciated!!!
> John A. Prejean
> Guardian Computer
> john@.gcit.net
>