Crystal Reports Problem

The following error loaded today when trying to output a crystal report from asp.Net:

Logon failed. Details: crdb_adoplus : Object reference not set to an instance of an object. Error in Filename.rpt: Unable to connect: incorrect log on parameters.

The problem was that I didn’t set the report’s DataSource. Next is the code that worked:

 

 

 

ReportDocument report = new ReportDocument();

 

 

report.Load(Server.MapPath(“Reports\Label.rpt”));

report.SetDataSource(dset);

report.ExportToDisk(ExportFormatType.PortableDocFormat, full_path);

report.Clone();

report.Dispose();

Hope this helps someone!! 🙂

 

 

 

 

Visual Studio 2005 – Crashes Randomly

Visual Studio 2005 

 

Last week i was using Visual Studio 2005 and all of a sudden it started to crash. Everytime i tried to open VS after 1 or 2 minutes it would crash. I checked the event log and the following error appeared:

Faulting application devenv.exe, version 8.0.50727.762, time stamp 0x45716759, faulting module craxddrt.dll_unloaded, version 0.0.0.0,
time stamp 0x43068582, exception code 0xc0000005, fault offset 0x0d26e30f, process id 0x1180, application start time 0x01c75cae13960a41.

After googling the problem, i found the following solution. The problem was that when opening my solution, by default it opened the last crystal report that i was working on. This seemed to start some crystal report ActiveX thing that didn’t work on Vista.

Sometimes it would take 2 minutes and sometimes 5 minutes, but it would always crash, even if i closed the report straight away.  The only way to stop this problem was to load up VS, close the report immediately and safely close VS before it got a chance to crash! The next time it opens, there is no crystal report and the ActiveX control never loads.

So the next time you save the solution and close visual studio be sure to close all Crystal Reports window 🙂

Happy Programming.

Reference: http://tim.mackey.ie/FIXVS2005CrashesRandomlyWhenUsingCrystalReports.aspx

Leading Caps in Crystal Reports

When designing a report in Crystal Reports, a common problem is the text to retrieve from the database. Sometimes the text is all in Capital Letters, or Small Letters, and a few times it’s ok.

Crystal Reports can only transform the text either in Small Caps or All Caps. To have the text written in Leading Caps you have to do the following… Continue reading

Migration to ASP.NET 2.0 breaks Crystal Reports

Crystal Reports

If you have an asp.net application using Crystal Reports and are migrating from VS .NET 2003 and VS 2005, or deploying your asp.net website from your development machine to the web server, a common problem that may arise is the following:

Could not load file or assembly ‘CrystalDecisions.ReportAppServer.CommLayer, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304’ or one of its dependencies. The system cannot find the file specified.

To solve this problem you must copy the following file on the server, and run the installer.

C:Program FilesMicrosoft Visual Studio 8SDKv2.0BootStrapperPackagesCrystalReportsCRRedist2005_x86.msi

This will put the missing packages on your web server thus be able to run crystal reports.

Reference: http://forums.asp.net/1218067/ShowPost.aspx