Hi, I need to copy some Content in Excel Sheet and send that Matter as a Mail Content in body of that Message not as attachment. I used Excel .dll i.e Microsoft Excel 11.0 Is there any way to do this. Thanks in advance.

Hi, I need to copy some Content in Excel Sheet and send that Matter as a Mail Content in body of that Message. I used Excel .dll i.e Microsoft Excel 11.0 Is there any way to do this. Thanks in advance.

Hi, I too worked on this where in Web.config file I gave identity impersonate="true" username="MY ID" password="PASSWORD"

Hi, I worked in Web application but I think both are the same. The procedure which I did in Web Applications is: 1) First in the ASPX Page gave the required Text boxes which will give input to Stored Porcs. Upon submitting the Page I will redirect to new ASPX Page which will Display only Crystal Reports. This is because if we keep any other fields like Textboxes there will be a problem which I don't know exactly. 2) In the Second Page I will just have Crystal Reports Viewer(CRViewerPortfolioReports) and Crystal Reports Source(CRSourcePortfolioReports;). On Page Load the below code has to be written int Portfolio_ID = int.Parse(Request.QueryString.Get("Portfolio_ID")); //Portfolio_ID Input Parameter for Stored Procedure. string ReportName = "CRPortfolioReports.rpt"; string ReportPath; ReportPath = Server.MapPath("../CrystalReportFiles/") + ReportName; //ReportPath Location of the CRYSTAL REPORT CRSourcePortfolioReports.ReportDocument.Load(ReportPath); CRSourcePortfolioReports.ReportDocument.SetDatabaseLogon(USERNAME, PASSWORD); CRSourcePortfolioReports.ReportDocument.SetParameterValue("@IMRsPerPortfolio_PortfolioID", Portfolio_ID); //@IMRsPerPortfolio_PortfolioID STORED PROCEDURE INPUT PARAMETER //IF you want to add another Input Parameter DATE... //CRSourcePortfolioReports.ReportDocument.SetParameterValue("@IMRsPerPortfolio_DATE", //DATE); CRViewerPortfolioReports.ReportSource = CRSourcePortfolioReports; CRViewerPortfolioReports.DataBind(); 3) Building the CRYSTAL REPORT .rtp FILE Add New Crystal Report File and create a new Database connection and add the Stored Procedure developed. You will automatically get the Input Parameters and Output Parameters which you could automatically map to X or Y Cordinates. Like if @IMRsPerPortfolio_PortfolioID id INPUT Parameter it will be coming in Parameters Field of Field Explorer Tab.

Hi I exactly don't know the procedure. The previous one which i sent also was wrong I think as pic.Copy() is returning "true".

Hi Try the Below code you have to add one DLL or COM Obeject I dont remember exactly Named Microsoft Excel 11.0 Object //INCLUDE using Excel; //For Excel LOCATION DLL Microsoft Excel 11.0 Object Library using System.Reflection; //For Missing using System.Runtime.InteropServices; //For Marshall //CODE::::: Excel.Application oXL; _Workbook oWB; _Worksheet oSheet; object oMissing = Missing.Value; Range oRng; oXL = new Excel.Application(); oWB = oXL.Workbooks.Open("EXCEL LOCATION", oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing); int TotalSheetsinExcel = 0; TotalSheetsinExcel = oWB.Sheets.Count - 1; oSheet = (_Worksheet)oWB.Sheets[1]; Picture pic = (Picture)oSheet.Pictures(1); //pic object will have PICTURE //Close Objects oWB.Save(); oWB.Close(null, null, null); oXL.Workbooks.Close(); oXL.Quit(); Marshal.ReleaseComObject(oXL); Marshal.ReleaseComObject(oSheet); Marshal.ReleaseComObject(oWB); GC.Collect();

Hi Christian, The IIS was configured correctly for .Net Framework 2.0 sites or 1.1. Since the Web page is loading fine after restarting IIS. I think this won't be the Problem.

Hi mavii, I too worked on Crystal Reports where I didnot do the Procedure as given by you. I used Stored Procedures which is very simple and easy to use. If you require this I will help regarding this.

I hosted my web Page in a Local System which has IIS 5.0, .Net Framework 1.1 and .Net framework 2.0 along with VS 2003 installed in that system. There are no problems with Web pages working in .Net Framework 1.1. For the pages developed in Framework 2.0 i.e VS 2005 the web page is NOT getting loaded at all its taking VERY HIGH Response time and not loading finally. When I restart IIS in this system the Web Pages belonging to 2.0 Framework are getting loaded and after some time the Same Problem is repeating. Could you Please help me to resolve this Issue. Thanks in advance.