Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 176
  • 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
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.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

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