Skip to Content
0

Preview Hangs

Jul 26, 2017 at 01:09 PM

23

avatar image
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).

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Don Williams
Jul 26, 2017 at 01:29 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jul 27, 2017 at 02:53 PM
0

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


sap-reg-keys.jpg (80.1 kB)
Share
10 |10000 characters needed characters left characters exceeded