?
Solved

.Net Excel Report

Posted on 2004-09-08
4
Medium Priority
?
176 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
  • 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

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

Question has a verified solution.

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

Article by: Najam
Having new technologies does not mean they will completely replace old components.  Recently I had to create WCF that will be called by VB6 component.  Here I will describe what steps one should follow while doing so, please feel free to post any qu…
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
There may be issues when you are trying to access Outlook or send & receive emails or due to Outlook crash which leads to corrupt or damaged PST file. To eliminate the corruption from your PST file, you need to repair the corrupt Outlook PST file. U…
Free Data Recovery software is an advanced solution from Kernel Tools to recover data and files such as documents, emails, database, media and pictures, etc. It supports recovery from physical & logical drive after a hard disk crash, accidental/inte…

601 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