Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > .NET > Other .NET > Crystal Reports
Password Reminder
Register
| FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
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.
Reply With Quote
  #2 (permalink)  
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
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 09:12 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.