Crystal Reports

34K

Solutions

14K

Contributors

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.

Share tech news, updates, or what's on your mind.

Sign up to Post

Hello everyone,

Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8.

We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly no detail on the error. Also there is a big lack of documentation on the web about this. There's lot of people with similar issue but no solution.

The error I'm talking about in particular is the one on the image below. This happens when trying to print any Crystal Reports on screen.

 Error 533 PESStartPrintJob
This has happened sometimes in the clients computer and it was hard for us to replicate on our environment. Since it's an old version of Crystal it is very hard to find any helpful documentation to know the exact source of the problem.

Then I though "What if this is a Borland Issue?". Again we have the same problem on documentation. We use BDE Admin to connect to Paradox tables. So then I started checking settings and registry, and this is where I found the issue.

The problem in the registry than can be cause by a double installation of BDE. This can happen for several reasons:
Reinstalled the application or borland without uninstalling it before
The uninstall was not fully completed
Installed a second application using BDE

To verify this, I went into the registry and found the following:

[HKEY_LOCAL_MACHINE \ SOFTWARE \ Borland \ Database Engine] …
0
[Webinar] Cloud and Mobile-First Strategy
LVL 11
[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples).

Crystal Reports uses a two-pass reporting process to provide greater Reporting capabilities. It is also largely responsible for determining what is and is not possible to do in Crystal Reports.

Understanding this two-pass process will explain many common questions, such as:
1. Why does a formula produce the error?
2. Why am I able to insert summaries on some formulas, but not on others?

3. Why are my grand total and/or summaries incorrect after performing a group selection or Top N/Bottom N sort?

Answers to these questions are:
1. Why does a formula produce the error?

"The function cannot be used because it must be evaluated later"?

Answer: This error usually happens when trying to insert a second pass function into a record selection. Since Crystal Reports evaluates record selection formulas during the first pass of the data, they cannot contain second pass functions.

In general, second pass functions are functions that require data from more than one record. Examples of second pass functions (also known as WhilePrintingRecords or print-time functions) are Next, Previous, TotalPageCount, NextIsNull, PreviousIsNull.

2. Why am I able to insert summaries on some formulas, but not on others?
Answer: Crystal usually evaluates formulas during the first pass of the data. These …
3
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems

ISSUE: Reports which contain subreports fail with error "Missing Parameter Value"

DEPLOYMENT SERVER OS:
Windows 2008 with 64 bit
.Net framework 2.0

DEVELOPMENT PC:
Windows XP SP3
Visual Studio 2005 Prof.
.Net Crystal reports 10.2.3600.0

SYMPTOM:
In Crystal Reports for Visual Studio .NET 2005, a subreport link is configured between a database field on the main report to a stored procedure parameter field in a

subreport.
When the report is run, a dialog appears and prompts for the linked subreport parameter field.
The parameter field should have been automatically populated by the main report.

SOLUTION For x86 PC's:
For PC's running with 32 bit, Business Objects released a Crystal Reports hot fix for Visual Studio 2005.
This can be downloaded at the following link.
http://ftp1.businessobjects.com/outgoing/CHF/crnet20win32x86_en_chf.zip 
Reference knowledge base KBase Article ID:c2018840
Download the above patch and install it on your PC. The issue would be resolved.

ISSUE for x64 PC's:
However, the patch from business objects does not fix the issue for PC's with 64 bit operating system.
After searching for a long time on google I presumed that a readily available installable to fix issue with .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating is not available.

SOLUTION For x64 …
1
 
LVL 2

Expert Comment

by:cadsjo
Comment Utility
Hi AmitGK,

Thanks for the solutions, it is exactly what I need.

But the link in point 2 is broken and that is really needed.
Do you have a new location?

2. You need to create an additional Crystal Reports Runtime Package.
The steps to create this additional Crystal Reports Runtime Package can be found at following URL
http://resources.businessobjects.com/support/additional_downloads/runtime.asp
0
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements can be met using a little forethought and planning (and a solid understanding of formulas).

That said, there are a few novel ways of using sub reports which will not affect performance and actually prove a boon to the developer.

1.  Report Header

Any information, graphics, logos or special fields (Date report was run etc) which will appear in every report can be built into a sub report which is then added to the main report.  

The performance hit is minimal, and a small amount is shaved off the development time, plus, it can go a long way to standardising your reports.  But the real benefit comes when the business decides to update its logo or corporate color etc.  As long as the sub report is set to "Re-import When Opening" (via the sub report's Format Editor), only one report needs to be changed to have impact across the entire report library.

2.  Reconciling Conflicting Groups

Often there is a requirement to show the same information summarised by logically conflicting groups.  For example: showing the total sales for each week within a month and totals sales per team in a month.

A typical sub report can be used to load the data again then group it by the second value, and this is the typical …
2
Crystal Reports: 5 Tests for Top Performance

It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways.

Then….

Disaster!

You try to run the report for a month against the live database and not the two days test data you used for development.

Suddenly your report’s runtime goes from twenty seconds to two hours.

Every experienced Crystal Reports developer has experienced this situation and it can be one of the most frustrating aspects of report design.

Thankfully there are a variety of things that can be done to combat bad performance, any one of which can reap huge benefits.

Here are the five most likely causes of poor performance and how to mitigate their effects.

1. The Database Set Up.

This may or may not be within your direct control to alter, but databases are not set up ideally.

Two top contenders are:

a. The fields you are filtering on are not indexed.  You can check whether or not this is the case by referring to the Linking Tab in the Database Expert window.  Indexed fields have colored markers next to them.

I have personally seen reports run hundreds of times quicker due to the addition of an index being added to an important (to the report filter) field.

b. Using a view rather than a table to report from can be devastating to a report’s performance.  This is mainly due to …
5
 
LVL 20

Expert Comment

by:ElrondCT
Comment Utility
I use subreports for child tables related to a parent table (listing the full detail), placing the subreport in a separate detail section. Are you suggesting there's a better way to accomplish that?
0
 

Expert Comment

by:tom_optimum
Comment Utility
Top work Jase! Just read through this, I do most of itbut a few extra little tips in there. Nice!
0

Crystal Reports

34K

Solutions

14K

Contributors

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.

Top Experts In
Crystal Reports
<
Monthly
>