[Shajee_.net]

Hi!

I am using crystal reports 9.1 in my asp . net application. Now when i am adding data to the report file(say CrystalReport1.rpt) by push method i.e through the crystal report designer and then exporting the file into pdf format it's working fine, the report is being saved as a pdf file into the specied location.

The other method i am using for generating the report is giving data to the report (crystalreport1.rpt) dynamically ,pull method i.e based upon certain conditions a sql query fetches data and feeds it into the report. so far so good ev'thing's working fine and CrystalReportViewer flawlesly generatess the report.

The problem arises when i am exporting this report into a pdf file. Upon hitting the Export Button an error is reported

The folowing error is shown

Code:

 
Exception Details: CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed.
 
Source Error: 
 
Line 126: report.ExportOptions.DestinationOptions = DiskOpts
Line 127: report.Refresh()
Line 128: report.Export()
Line 129:
Line 130: 'Catch ex As CrystalDecisions.CrystalReports.Engine.EngineException
 
 
 
Stack Trace: 
 
[LogOnException: Logon failed.]
.F(String , EngineExceptionErrorID 
) +506
.A(Int16 , Int32 ) +537
CrystalDecisions.CrystalReports.Engine.FormatEngine.Export(ExportRequestContext reqContext) +469
CrystalDecisions.CrystalReports.Engine.FormatEngine.Export() +107
CrystalDecisions.CrystalReports.Engine.ReportDocument.Export() +67
HSSTimeSheet.ReportTimeSheet.Button1_Click(Object sender, EventArgs e) in C:\Hanu Software Solutions\HSSTimeSheet\ReportTimeSheet.aspx.vb:128
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1277
 
 
 
 
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573

[curiouschris]

I have just the same here, all works a treat on my development machines but run it on the target machines (it's a VB.NET desktop app) I get a 'logon failed' message when exporting either to PDF or to email - same error, same stack as above. Have checked all the privs etc., no joy though, have been bashing my head against this one for a few weeks now !

Any help much appreciated,

Chris

[jonemma]

Me to - only with asp.net. On my local machine it works fine but on our Dev server I get:

CrystalDecisions.CrystalReports.Engine.LogOnExcept ion: Logon failed.

I am also head banging here!

Originally Posted by curiouschris

I have just the same here, all works a treat on my development machines but run it on the target machines (it's a VB.NET desktop app) I get a 'logon failed' message when exporting either to PDF or to email - same error, same stack as above. Have checked all the privs etc., no joy though, have been bashing my head against this one for a few weeks now !

Any help much appreciated,

Chris

[lamar]

We encountered the same error on .NET 1.1 using Crystal Reports runtime for .NET 1.0 (DevEnv 2002).
We fixed it by installing Crystal Reports runtime for .NET 1.1 (DevEnv 2003).

[jobo]

I looked under add/remove programs for Crystal and DevEnv to see what my version was. I didn't see it listed. I'm using Visual Studio .NET 2003 with the Crystal Reports designer included with VS. How can I tell if I have this issue?

We encountered the same error on .NET 1.1 using Crystal Reports runtime for .NET 1.0 (DevEnv 2002).
We fixed it by installing Crystal Reports runtime for .NET 1.1 (DevEnv 2003).

Thanks,
Joe

[Explorer]

When I first started using Crystal Reports .NET, I encountered the same issue. I could create the report, and run it, pointing to a SQL Server on my local machine, it worked fine. When I pointed it to a different server, or, migrated my web application to a different server, I received the login failure.

In my case, this had to do with the account that Crystal reports used to access the SQL Server. It was a local machine account that has administrative rights on my local SQL Server, but not on the dev server.

What I was trying to do was to take a report that was created from a stored procedure, and pass a dataset to it. Basically, we were trying to print from an ADO.net dataset.

My workaround was to use the dataset to create an XML file. I would then use the XML file to create the Crystal Report (in CR.NET, you can use XML as a database). Because I didn't need to access a SQL Server to create the report originally, it wouldn't try to use any credentials later. I could pass it the dataset with no problems (I didn't even need the XML file).

I hope this works.

Paul Hammond
Covenant Web Design
http://www.covenantwebdesign.com

[vedrajan]

HTML Code:

<CR:CrystalReportViewer ID="CrystalReportViewer1" EnableDatabaseLogonPrompt="false" runat="server" AutoDataBind="true" Width ="95%" DisplayGroupTree="False" />

modify ur Crystal report viewer as above code.Reply if works.