473,666 Members | 2,010 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to generate an excel report using ASP?

I have to generate a report from the database in an excel format using
ASP.please help me.Thanks in advance
Jul 21 '05 #1
2 1789
Kurien,

Is it ASP or ASPNet

When it is the first you better can ask this in a "classic" ASP newsgroup

When it is ASPNET than you can probably start your question the best in the
newsgroup
microsoft.publi c.dotnet.framew ork.ADONet and later when you know how to
retrieve your data to the newsgroup
microsoft.publi c.dotnet.framew ork.ASPNET

Or both in one time using crossposting, one message too both newsgroups in
one time. Do not sent two messages in one time, most regulars in newsgroups
become irritated by that.

I hope this helps something

Cor

"Kurien Baker Fenn" <Ku************ *@discussions.m icrosoft.com>
I have to generate a report from the database in an excel format using
ASP.please help me.Thanks in advance

Jul 21 '05 #2
Moving data from a SQL Database into Excel in ADO.NET :
http://www.winisp.net/cheeso/srcview...Connections.cs

"Kurien Baker Fenn" <Ku************ *@discussions.m icrosoft.com> wrote in
message news:C2******** *************** ***********@mic rosoft.com...
I have to generate a report from the database in an excel format using
ASP.please help me.Thanks in advance

Jul 21 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
17404
by: Steven Stewart | last post by:
I have a user who has been using Excel for a while to keep statistics and print reports. She finds using it cumbersome because of long formulas and a lot of copying and pasting. I have designed a database for her which is intended to make things a lot easier; however, I don't have a lot of experience with Access and I find that designing the reports in Access is tedious. I want to be able to print the reports (which are simply based on...
3
286
by: Rana | last post by:
I developed a reporting website using ASP.NET and Microsoft Office XP. The reports are generated using Microsoft Excel. It works perfectly as designed in the development environment. I deployed it on production server, which has Microsoft Office 2003 installed. The site works perfectly, except that the excel reports do not come up. No error message is displayed. Is it an issue with Microsoft frontpage extension or could it be a Microsoft...
2
335
by: Kurien Baker Fenn | last post by:
I have to generate a report from the database in an excel format using ASP.please help me.Thanks in advance
2
8189
by: Martin Widmer | last post by:
Hi guys I am looking for the best way to generate new reports with reporting services for SQL server 2005. The reports will be generated programmatically from a .Net VB application. So far I see the only way to do it is to feature my objects (text blocks, pictures, tables drawn from excel and databases etc.) with a "render to RDL"- function and thus create an RDL definition of the report, then push that one to the server using the...
5
1841
by: ken | last post by:
how ASP.NET to generate excel report(office 2003) to client what component i need to reference into the asp.net application and what component i need to install to the server? Moreover, does it free?
0
3073
by: manoharcr | last post by:
I am using the fallowing code.... This condition generats a two different excel sheet based on IF condition If(Condtion) { response.setContentType("application/vnd.ms-excel"); response.setHeader("Content-disposition","attachment;filename="+deviceName+"_Spec"+".xls"); response.setHeader( "Pragma", "no-cache" ); MY CODE TO WRITE DATA ON 1St EXCEL SHEET } else { response.setContentType("application/vnd.ms-excel");...
0
1692
by: Wes Groleau | last post by:
Is there a reasonably simple way to dump an SSRS report into Excel format automatically at a scheduled time without using Report Manager/Report Server? Creating the report was easy, but we seem to be having security trouble with the server. SSIS is also working OK -- it loads all the data this report comes from.
1
1720
by: Ramchandar | last post by:
I would like to create a dynamic report in excel using VB6.0. I am having many recordset and i would be using these separate recordset to prepare report in excel. I have a separate format also for this. Say for example each cell value in excel would be from a separate recordset. The data for this recordset would be from SQL. Can u please suggest me some freeware or some source code to achieve this task.
2
6407
hemantbasva
by: hemantbasva | last post by:
Note We need to have a template on server for generating report in multiple sheet as we do not had msoffice on server moreover this require a batch job to delete excel file created by the method.... it creates 6 sheets # region Namespaces using System;
0
8356
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8871
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8781
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8551
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
1
6198
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5664
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4198
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4369
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2011
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.