Report looks different when printed than in report view

[former_member391509]

Hello,

I have created a report on crystal 2008.

I used the preview to verify that I got the wanted design.

Then, when I run it through the code, using the viewer, the outcome is different. For example - a running total field which is doing "sum" in the design mode, is now doing "count" when the report is showed through the viewer.

I am using VS2005 and crystal reports 2008, dlls are of version 10.2.3600.0. runtime verstion 2.0.50727

Any suggestion would be appreciated!

Thanks,

Shmulik.

[former_member11696 · Accepted solution]

Hello,

If you are using CR 2008 then you are not using that version at runtime. Remove all of your 10.2 assemblies and replace them with the 12.0.1100.0 and/or 12.0.2000.0 assemblies and try again.

CR 10.2 which is the basic version of Cr included with .NET and based on CR 10, CR 2008 is version 12 and therefore CR 10 is not aware of new functionality and features CR 2008 has.

Thank you

Don

[former_member391509 · Accepted solution]

Hi Don,

Thanks for your reply. I did try changing the references to the 12 version but I still got the same results.

Do you have any other ideas what the problem might be?

Thanks,

Shmulik.

[Adam_Stone · Accepted solution]

In the viewer where it is acting differently, try exporting it to Crystal Reports format and then open that in the designer. Is the field getting changed from the original design?

[former_member11696 · Accepted solution]

Hello,

The Preview in the .NET IDE is using the ActiveX viewer, not distributable, when you are viewing at runtime you are using the CR.Windows.Forms viewer which is different.

It doesn't make sense why the type is changing.

Do as Adam suggests and the preview the exported report with saved data in the app, then hit the refresh button, log on and then compare to see if you have the same results.

Thank you

Don

[former_member391509 · Accepted solution]

Hi there again Don and Adam,

Thanks for the tip with saving it as .rpt - wasn't aware to the fact that I can do that. Anyway, I did it and the new report is different from the original - the running total field was changed from "sum" to "count". I need to take you one step backward to Don's first tip since I'm using another computer which doesn't have the 12.0.200.0 dlls. I tried to reinstall crystal reports 2008 and also the crystal reports runtime sp3 but the right dlls won't show up in the references' list. Any idea about that?

Thanks again for your tips,

Shmulik.

[former_member11696 · Accepted solution]

Hi Shmulik,

When you installed make sure you are using Service Pack 3, full build. No need to install the runtime on a DEV PC if CR is installed.

Thanks again

Don

[former_member391509 · Accepted solution]

Hi Don,

I installed the sp3 full build but still can't see the right references in the references list.

I d/l the installation pack from this link:

[original link is broken]

Should I d/l and install the fix packs as well?

Should I try to uninstall the whole crystal installations and install it again from the beginning?

Please advise...

Thanks,

Shmulik.

[former_member11696 · Accepted solution]

That is odd.... What version of VS 2005 are you using? If it's the Express version then Cr will not integrate into the IDE.

What happens if you just browse the assemblies located here: C:\Program Files (x86)\Business Objects\Common\4.0\managed

Thank you

Don

[former_member391509 · Accepted solution]

Hi Don,

I'm using VS2005 team edition for software develops version 8.0.50727.42.

.net framework version 2.0.50727 SP2.

In the folder C:\Program Files\Business Objects\Common\4.0\managed I have 6 dlls:

CrystalDecisions.Enterprise.Desktop.report.dll

CrystalDecisions.Enterprise.Framework.dll

CrystalDecisions.Enterprise.InfoStore.dll

CrystalDecisions.Enterprise.PluginManager.dll

FlashControlV71.dll

ShockwaveFlashObjects.dll

More over, I have folder there named "dotnet2" (C:\Program Files\Business Objects\Common\4.0\managed\dotnet2) which contains:

CrystalDecisions.CrystalReports.Design.dll

CrystalDecisions.CrystalReports.Engine.dll

CrystalDecisions.ReportSource.dll

CrystalDecisions.Shared.dll

CrystalDecisions.Web.dll

CrystalDecisions.Windows.Form.dll

(these are the dlls i actually need and looking for in the references list in VS2005 and can't find.)

there are few more dlls there and a folder named "en" which contains more dlls...

How can I add those dlls (in the dotnet2 folder) to the reference list in VS2005 under .NET?

Thanks for your ongoing help,

Shmulik.

[former_member11696 · Accepted solution]

Hello,

That is odd. In your project resources try adding the CR folder for the Reference Path.

You could even add the \windows\assemblies folder too, that's where all of them are GAC'd anyways...

Have you tried doing a Repair install?

Was VS installed before CR?

Thanks again

Don

[former_member391509 · Accepted solution]

Hi Don,

Back to square one - I added the path (C:\Program Files\Business Objects\Common\4.0\managed\dotnet2) to the references path and the dlls appeared in the .NET references list.

I added the 4 relevant dlls (Engine, ReportSource, Shared and Windows.Forms) instead of the older references so now I have only those in my project's references list, crystal dlls wise (all of them are version 12.0.2000.0).

Anyway, I tried to show the report after those changes and I'm getting the same results - in the viewer I'm getting the running total to do "count" although when I edit the report and preview it, either in crystal 2008 or vs2005 it does "sum".

This is really really really odd...

Regarding your other questions:

1. I didn't add the \windows\assemblies folder once I saw the dlls showing. Should I add it as well?

2. I didn't try to do repair install. Should I try it? Should I use the full installation pack of crystal 2008 sp3?

3. VS was installed before CR.

Hope you have some idea regarding this problem, I'm quite frustrated...

Thanks,

Shmulik.

[former_member11696 · Accepted solution]

Hi Shmulik,

No you don't need to add the assemblies to the reference path.

Yes do a repair install.

When you Add a reference and open the Reference wizard in .NET are you clicking on the .NET tab or manually browsing to the assembly folder?

This is very strange, I suggest you purchase a support case and get a Rep to see what is happening using WEBEX or NetViewer session.

Thank you

Don

[former_member391509 · Accepted solution]

Hi Don,

I continued to try all those things and more but still ended up in the same place. I had to "go around" the problem and avoid the problematic fields.

Thanks for your help anyway!

Shmulik.

[former_member391509]

null

Edited by: Shmulik Shicht on Feb 21, 2011 11:36 PM