sql server reporting services: Generate Report Export from Stored Procedure -- sql server reporting services

Re: Generate Report Export from Stored Procedure

Jeff Dillon
9/8/2004 11:49:15 AM

sql server reporting services: T-SQL is not ".NET enabled" yet (sounds like more support will be in SQL
2005). You might try sp_OACreate in the meantime.

Jeff

[quoted text, click to view]

Generate Report Export from Stored Procedure

John A. Prejean
9/8/2004 1:35:34 PM

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