Export result of a query made in a stored procedure to an excel file and use it for an asp

[Hamed]

Hello

I want to write a stored procedure in SQL Server that gets two parameters and
makes a query based on the parameters, then exports the result to an Excel file,
make a graph from it by automation techniques and use the image of graph in my
asp result. Is this task possible in SQL Server 2000 ? How ?

Is there any better/more simple solution to make the graph from the database?

Thanks in advance

Hamed...

[Q*bert]

You could consider using a third party charting tool and directly access
the data in the database via ASP and write code to process the recordset
results providing enough info to the tool so it could chart. An example
of a third party tool would be like those found at www.objectplanet.com or
those provided through crystal reports. But your probably after a no expense
solution; if that's the case, I'd research through www.Google.com to see
if there are any freeware charting javascripts out there that met my need.

If your stuck with the Excel Option, You can use ASP to query the database,
and make updates to the cells within Excel by instancing a version of Excel
through ASP using automation to update it then saving the Excel file as an
HTML document and redirecting to the document you created.

Personally I like using www.objectplanet.com tools for charting. They are
easy to use, pretty inexpensive and provide lots of cool functions.

Cheers,
Q*bert
"Hamed" <hamedarab@hotmail.com> wrote:
>Hello
>
>I want to write a stored procedure in SQL Server that gets two parameters
and
>makes a query based on the parameters, then exports the result to an Excel
file,
>make a graph from it by automation techniques and use the image of graph
in my
>asp result. Is this task possible in SQL Server 2000 ? How ?
>
>Is there any better/more simple solution to make the graph from the database?
>
>Thanks in advance
>
>Hamed...
>
>
>