Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > Crystal Reports
| Search | Today's Posts | Mark Forums Read
Crystal Reports General discussion about Crystal Reports. For discussions specific to the book Professional Crystal Reports for VS.NET, please see the book discussion forum for that book.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Crystal Reports section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 9th, 2006, 04:11 AM
Authorized User
 
Join Date: May 2006
Location: , , .
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default Login Failed for User sa

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.
 
Old November 29th, 2009, 09:50 AM
Registered User
 
Join Date: Jul 2009
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi try this

http://crystalrepterrinfo.blogspot.c...al-report.html




Similar Threads
Thread Thread Starter Forum Replies Last Post
Login failed for user 'sa' scarlisle BOOK: ASP.NET Website Programming Problem-Design-Solution 3 November 29th, 2009 09:51 AM
Login failed for user 'sa'. Reason: Not associated Saurabh Sharma Classic ASP Basics 0 October 23rd, 2007 01:37 AM
Login failed for user 'sa' ??? reidcor BOOK: ASP.NET Website Programming Problem-Design-Solution 9 October 17th, 2006 01:04 PM
Login failed for user 'sa'. ernestlambert BOOK: ASP.NET Website Programming Problem-Design-Solution 2 March 7th, 2005 12:26 PM
Login failed for user 'sa' ameg BOOK: Beginning ASP 3.0 5 April 6th, 2004 01:52 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.