Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

.Net Excel Report

Posted on 2004-09-08
4
Medium Priority
?
174 Views
Last Modified: 2010-04-15
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
Comment
Question by:Nobletucky2004
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 23

Assisted Solution

by:rama_krishna580
rama_krishna580 earned 750 total points
ID: 12005542
0
 

Author Comment

by:Nobletucky2004
ID: 12005714
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
 
LVL 4

Accepted Solution

by:
somnatic earned 750 total points
ID: 12005720
nope .. that is not possible ...
excel needs to be installed for that
0
 

Author Comment

by:Nobletucky2004
ID: 12007192
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction Although it is an old technology, serial ports are still being used by many hardware manufacturers. If you develop applications in C#, Microsoft .NET framework has SerialPort class to communicate with the serial ports.  I needed to…
Introduction Hi all and welcome to my first article on Experts Exchange. A while ago, someone asked me if i could do some tutorials on object oriented programming. I decided to do them on C#. Now you may ask me, why's that? Well, one of the re…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
Suggested Courses

715 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question