Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 175
  • Last Modified:

.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?
0
Nobletucky2004
Asked:
Nobletucky2004
  • 2
2 Solutions
 
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
 
somnaticCommented:
nope .. that is not possible ...
excel needs to be installed for that
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now