Crystal Reports 2008 SP3 with Visual Studio 2005 help !!

[Former Member]

Have application that uses reports developed using CR2008. The reports in question are created from an XML datasource and are populated at runtime with a dataset.

The reports work fine on developement machine but the client machines keep displaying the database login prompt.

What do I need to do to fix this

[former_member183750 · Accepted solution]

See the blog [Troubleshooting Issues with VS .NET Datasets and Crystal Reports|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/13270] [original link is broken] [original link is broken] [original link is broken];

Umm, entering the search terms "dataset net crystal" in the search box at the top right corner of this web page comes up with this blog as the 1st hit...

- Ludek

[Former Member]

The runtimes are now identical.

You were correct regarding the XML being incorrectly formatted. This issue was resolved and the report works fine.

Thanks for your assistance.

[Former Member]

The version of crpe32.dll on my development machine is 12.3.0.601

The version on the client machine is 12.3.3.812

The references .net assemblies in the project are:

CRYSTALDECISIONS.CRYSTALREPORTS.ENGINE.DLL (dev: 12.3.2000.301, CLIENT: 12.3.2003.812)

CRYSTALDECISIONS.CRYSTALREPORTS.SHARED.DLL (dev:12.3.2000.601, CLIENT: 12.3.2003.812)

CRYSTALDECISIONS.CRYSTALREPORTS.REPORTSOURCE.DLL (dev 12.3.2000.601, CLIENT:12.3.2003.812)

CRYSTALDECISIONS.CRYSTALREPORTS.WINDOWS.FORMS.DLL (dev:12.3.2000.601, CLIENT: 12.3.2003.812)

THere are others but I think this shows a pattern.

Also, when I attempt to reference the 12.3.XXX assemblies in vs.net, they show as 12.0.2000.0 in the vs.net project refererce listing .

Edited by: Patrick Hayden on Mar 21, 2011 12:52 PM

[former_member183750]

What we are looking at are three different things.

1) Assembly versions - never changes

2) Assembly file versions - changes with any SP or FP (but is different from DLL versions)

3) DLL versions (not assemblies) changes with any SP or FP

12.0.2000.0 (frm. 2.0 +) and 12.0.1100.0 (frm. 1.1) are the actual assembly versions and as stated above these do not change - ever.

12.3.2000.301 and 12.3.2003.812 are file versions (Properties | Detail Tab) of the assemblies.

Dues to this potentially confusing versioning, I do not specify the assembly versions in [this|https://wiki.sdn.sap.com/wiki/display/BOBJ/CrystalReports2008-VersionandDownloadinformationforSPsand+FPs] wiki. Rather, I specify the version of the CRW32.exe which is exactly the same as the crpe32.dll (the runtime print engine) and most of the other runtime dlls. E.g.; it is easier, less confusing, etc. to look at the DLL versions as opposed to the assemblies

File version of 12.3.2003.812 of say, crystaldecisions.crystalreports.engine is from Service Pack 3, with Fix Pack 3.3 on top. E.g.; if you look for crpe32.dll on the client, you will find it is of version 12.3.3.812.

Your dev computer is on a lower Fix Pack Service Pack. I suspect if you look for the crpe32.dll on your dev computer, you will find it is of version 12.3.0.601. The crw32.exe will also be of that same version.

So where does that leave us?

As far as I am concerned, the above has no bearing on the issue at hand. Looking at the XML of the dataset where this does not work, as suggested a while back is the place to start;

[Troubleshooting Issues with VS .NET Datasets and Crystal Reports|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/13270] [original link is broken] [original link is broken] [original link is broken];

- Ludek

[Former Member]

I ran the modules utility .... this appears to be my issue. My PC has runtime 12.3.XXX loaded where the clients have 12.0.XXX

I ran the SP3 runtime on the client machines .... there are still differences.

My development PC has a few libraries with runtime of 12.3.1100.601

The clients have the same libraries with 12.3.1103.812

I can send you the .mdd differences file to help resolve.

Edited by: Patrick Hayden on Mar 17, 2011 8:40 PM

Edited by: Patrick Hayden on Mar 17, 2011 8:49 PM

[former_member183750]

Something is not right here. If you are looking at assembly versions, then there are versions 12.0.200.0 and 12.0.1100.0 - framework 2 and framework 1.1 respectively. These do not change from SP to SP.

File versions do change. So, the assemblies for CR 2008, SP 3 would be 12.3.2000.601. Version 12.3.1100.601 is not familiar to me...

So, what libraries are you refering to? What is the version of the crpe32.dll?

BTW., sharing of log files is typically reserved for [phone|http://store.businessobjects.com/store/bobjamer/en_US/pd/productID.98078100?resid=S6I@hgoHAkEAAGsiyVkAAAAR&rests=1282226845369] cases.

- Ludek

[Former Member]

OK thanks. I will review.

My problem is the reports work on certain machines and not on others .....

[former_member183750]

Same still applies.

You may also want to compare the runtimes. Use [Modules|https://smpdl.sap-ag.de/~sapidp/012002523100006252802008E/modules.zip] for thast.

- Ludek