Preview Hangs

[Former Member]

Hi all,

We have Crystal Reports Developer 2013. It is installed on a Win7 box and a Win2012R2 box.

We are able to use 'Set Datasource Location..' under the 'Database' menu without errors. It is able to see all of the Tables and Views from within that screen.

When we select 'Print Preview..' under the 'View' menu (and select the first 100 records), the application 'hangs' and does not display a preview. The text "Accessing Database" is displayed on the lower-left part of the screen.

This function was okay on about June 2nd.

Admittedly, our databases are behind a highly restrictive firewall. We we were able implicate the firewall as a culprit: we were able to install Crystal on another computer (behind the firewall) and point the datasource to another database (behind the firewall) and the program was able to preview reports without issue.

Our firewall team denies placing any 'new' deny rules.

My question is: is there a port that Crystal uses to preview the reports (this can help guide the firewall team).

[Former Member]

Hi Don,

Sorry for taking so long to get back to you, I was putting out other fires.

I added the new DWORD and "DisableOnStartUp" and set its value to "1" in the directory you described.

The log file did not seem to be created.

I created a logging directory.

LOGGING_DIR (what kind of key? I guessed "String Value", under the same directory as described as above? I assumed yes.)

LOGGING_ENABLED_ASSERT (what kind of key? I guessed "DWORD (32-bit) Value".)

LOGGING_ENABLED_RUNTIME (what kind of key? I guessed "String Value".)

Our database type is "OLE DB (ADO)" and our provider is "SQLELODB".

On the computer (Win2017R2 4cpu's 16GB ram) where the Preview works (computer is behind firewall, datasource (database) is behind same firewall), it takes about 35 seconds for the data to appear. I waited at least 2 minutes for the data to appear on the computer (Win7 4cpu's 8GB ram) where Preview did no show data.

Let me know if I can provide more information.

Thanks,

Scott

[former_member11696]

Hi Scott,

Yes, when CR starts up it attempts to contact home and check for updates and download info on the Start Page.

HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\SAP BusinessObjects\Suite XI 4.0\Crystal Reports -

DisableCheckForUpdates = 1

And then under the same path create a new DWORD and paste this in it:

"DisableOnStartUp" and set its value to "1".

But since this is not the issue the missing data suggests it either can't access the DB or there are problems generating temp files.

The other possibility is how long have you waited for data to appear? It coudl simply be since you are selecting the first 100 records is is compiling those records.

Enable CRLogger by adding these registry keys and creating the logging folder:

LOGGING_DIR = c:\logging

LOGGING_ENABLED_ASSERT = 1

LOGGING_ENABLED_RUNTIME = 30

Have a look in the log file, you should see it connecting and then attempting to access the data.

What DB are you connecting to and how are you connecting to it, ODBC, OLE DB, Native, etc.?

Don