.Net Excel Report

I have to create a report in Excel from a SQL Server Dataset.  What is the best approach to accomplish this.  The report itself is a pivot type report and cannot simply render a datagrid to Excel?
Nobletucky2004Asked:
Who is Participating?
 
somnaticCommented:
nope .. that is not possible ...
excel needs to be installed for that
0
 
rama_krishna580Commented:
0
 
Nobletucky2004Author Commented:
Thanks for your links.  Although good approaches I'm afraid I wasn't I missed a few key points in my original question.  The first being, that Excel/Office is not installed on the server that this report will be generated from...is is possible to use InterOp with Excel if Office is not installed on the box?
0
 
Nobletucky2004Author Commented:
How about building an in-memory XML with all the summary detail and stepping through it to build a table display which can be converted to excel in the same fasion you would export a datagrid?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.