Ken
Create a crystal report and export the content as Excel, that's the cheapest
way
see the sample code..
ReportDocument r=new ReportDocument();
crTableLogOnInfo=new TableLogOnInfo();
rptFiles=(MapPath("Reports\\xxx.rpt"));
r.Load(rptFiles);
crDatabase=r.Database;
for (int i = 0; i < crDatabase.Tables.Count; i++)
{
crTable = crDatabase.Tables[i];
crTableLogOnInfo = crTable.LogOnInfo;
crTableLogOnInfo.ConnectionInfo = crConnectionInfo;
crTable.ApplyLogOnInfo(crTableLogOnInfo);
}
s=(System.IO.MemoryStream) r.ExportToStream(ExportFormatType.Excel);
HttpContext.Current.Response.ClearContent();
HttpContext.Current.Response.ClearHeaders();
HttpContext.Current.Response.ContentType = "application/x-msexcel";
HttpContext.Current.Response.AddHeader("Content-Disposition", "inline;
filename=Report.xls");
HttpContext.Current.Response.BinaryWrite(s.ToArray ());
HttpContext.Current.Response.End();
r.Close();
Hope this help you...
vinu
"ken" <ke*@discussions.microsoft.com> wrote in message
news:2C**********************************@microsof t.com...
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?