Troubleshooting reports

Click an issue below to see the solution or workaround.

Some reports containing calculations cannot be generated without showing an error message, if there is no data to be calculated.

The error messages Script timed out are by default activated after 90 seconds.

You can change this time period for the Internet Information Server:

  1. Right-click .../Web Sites/Default Web Site and select Properties > Web Site.
  2. In the Connection timeout field, change the timeout value.

Note: Statistical calculations can require a large amount of time, sometimes many hours.

IIS can only upload files limited to 4 MB. It can be increased by adding the following line to web.config in Crystal directory :

<httpRuntime maxRequestLength="32768" />

Note: You must perform an iisreset after changing the file web.config.

If the error message “access to path …\Data\..XML…is denied.” is displayed, the possible reason is that the user does not have write permissions to the Data folder of sjCrystalRender. You can change the setting in the following way:

  1. Find the Data folder on the server.
  2. Open the context menu and select Properties.
  3. Click the Security tab.
  4. Find or add the user <local machine>\Network Service.
  5. Set Modify and Write permissions for this user..

If the icons are missing in the display window of reports, the possible reason is that the crystalreportviewer site has been deleted, for instance, because of a re-installation of IIS.

During re-installation of WorkZone, the crystalreport viewer site will be re-established.

If the reports are not displayed, check whether SYSADM is a contact on all records of type RAPDEF, and add it if it is not already a contact.

If you run https and try to open a report, you may get the error message:

"ShowReport error: The underlying connection was closed: An unexpected error occurred on a send"

and you cannot open the report. You solve this issue by inserting:

<serverRuntime uploadReadAheadSize="2147483647" />

into the applicationHost.config file, which is located here:

C:\Windows\System32\inetsrv\config\applicationHost.config

.

Example:

<location path="Default Web Site/SJCrystalRender">

<system.webServer>

<serverRuntime uploadReadAheadSize="2147483647" />