Hi
I am working on Crystal reports10. My task is by using an existing report, I want to convert it into .pdf file. Suppose there are 3 documents namely covering letter, registration letter, and invoice. These 3 reports containing parameter fields which connects SQL server. For document 1(Covering Letter), Im successfully converted to .pdf file but for 2(Registration letter) from the following line it goes to error condition...
objStream = rptEngineObj.ExportToStream(CrystalDecisions.[Shared].ExportFormatType.PortableDocFormat)
Stack Trace:
Error while Issuing Documents for Corporation: 107760. Error message: Error in generating documents. 107760 Error in CreateReport: Articles of Incorporation.rpt. Error message: Logon failed. Details: ADO Error Code: 0x80040e4d Source: Microsoft OLE DB Provider for SQL Server Description: Login failed for user 'sa'. SQL State: 42000 Native Error: 18456 Logon failed. Details: ADO Error Code: 0x80040e4d Source: Microsoft OLE DB Provider for SQL Server Description: Invalid connection string attribute SQL State: 01S00 Error in File C:\DOCUME~1\SYSTEM8\ASPNET\LOCALS~1\Temp\{D445F186-CD40-4CCF-8787-52AF7782B180}.rpt: Unable to connect: incorrect log on parameters. Stack trace: at CrystalDecisions.ReportAppServer.ConvertDotNetToEr om.ThrowDotNetException(Exception e) at CrystalDecisions.ReportSource.EromReportSourceBase .ExportToStream(ExportRequestContext reqContext) at CrystalDecisions.CrystalReports.Engine.FormatEngin e.ExportToStream(ExportRequestContext reqContext) at CrystalDecisions.CrystalReports.Engine.ReportDocum ent.y(ExportOptions 1) at CrystalDecisions.CrystalReports.Engine.ReportDocum ent.ExportToStream(ExportFormatType formatType) at CP_BusinessLayer.Activity.CreateReport(String rptFileName, String rptFilePath, String reportFileType, Int32 PrintFlag, String PrinterName, Collection DocumentParameterListArr, DataSet subReportDataset) in C:\LIS\Corporate\CP_BusinessLayer\Activity.
vb:line 879. Stack trace: at CP_BusinessLayer.Activity.CreateReport(String rptFileName, String rptFilePath, String reportFileType, Int32 PrintFlag, String PrinterName, Collection DocumentParameterListArr, DataSet subReportDataset) in C:\LIS\Corporate\CP_BusinessLayer\Activity.
vb:line 898 at CP_BusinessLayer.Activity.AddActivityWithDocuments (Int32 CorpID, Int32 aorID, String aorContactID, String aorContactName, String ShippingAddress, String LocationCode, String thirdPartyFlag, String DocumentType, String rptFilePath, String FolderID, Int32 PrintFlag, String PrinterName, String FormVariablePrefixStr, NameValueCollection FormParameters, DataSet Products, Double Amount, Double DiscountAmount, Double CustomerPayment, Int32 created_by, Int32 CC_activityNumber, String ADDITIONAL_DOC_LIST) in C:\LIS\Corporate\CP_BusinessLayer\Activity.
vb:line 160. Stack trace: at CP_BusinessLayer.Activity.AddActivityWithDocuments (Int32 CorpID, Int32 aorID, String aorContactID, String aorContactName, String ShippingAddress, String LocationCode, String thirdPartyFlag, String DocumentType, String rptFilePath, String FolderID, Int32 PrintFlag, String PrinterName, String FormVariablePrefixStr, NameValueCollection FormParameters, DataSet Products, Double Amount, Double DiscountAmount, Double CustomerPayment, Int32 created_by, Int32 CC_activityNumber, String ADDITIONAL_DOC_LIST) in C:\LIS\Corporate\CP_BusinessLayer\Activity.
vb:line 205 at LIS.CorpIssueDocument.btnSubmit_Click(Object sender, EventArgs e) in C:\Inetpub\wwwroot\LIS\Corporate\CorpIssueDocument .aspx.
vb:line 289.
Login Failed for User sa
