asked on

Central Management Console Crystal Reports - Data Refresh for Viewing

Hello Experts,

I added a report in the Central Management Console and when I attempt to run it from InfoView, it often fails to return the data and displays a generic error message. I think the report might be timing out. Is there a way to increase the amount of time before a report times out? I noticed there are options on the Process tab page of the Central Management Console called, 'Data Refresh for Viewing'. What do those options do? Or is there another place I can adjust the how long a report is permitted to work on returning data?

Thank you for any guidance.
Respectfully, Chop

Chopp

ASKER

I would like to add that the report in InfoView sometimes returns the data, and other times does not. The date range entered does not appear to be relevant. Is it possible that if someone is editing data in the front-end application using the database the report is pointed to, the report can't return data because of some sort of 'lock' ?

Thank you for any advice.
~Chop

Ido Millet

Yes, Crystal reports can experience database Lock issues.
If you are using ODBC as the connection method, here's a link to a potentially useful KB:
1216415 - How to change the isolation level for ODBC connections

Also, see this: http://scn.sap.com/thread/3601052

Chopp

ASKER

Thank you, Ido. I checked the link and did a search on what 'isolation level' is, but I didn't yet find a clear definition. Can you tell me what it is?
Additional note regarding the report issue - my report does run without a problem from Crystal Reports, it is when I attempt to run it from InfoView where it fails to run half of the time.

ASKER CERTIFIED SOLUTION

Ido Millet

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Chopp

ASKER

Thank you for your help. I ended up using views to return the data and put 'with(nolock)' in the scripts. I'm not sure that is the reason the reports now run well from Infoview, but I'm pleased they do.
~Chopp