INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Data Connectivity

My report runs fine in Crystal Reports, but fails when I run it via Crystal Enterprise. Why? by AEldridge
Posted: 12 Jul 01

When you have a report that runs fine in Crystal Reports, but it fails when you run it in Crystal Enterprise, it is generally a data access problem.

When you run the report in CR, the report engine is run by the user ID with which you logged in. When it runs in CE, it is run either by the page server service (for on-demand reports) or the job server service (for scheduled reports). By default these services run under the local system account.

At the end of the day, 90% of these problems are caused by the data source not being available to the page/job server services.

Common steps to try:
1.  If the report is written against an ODBC DSN, is the DSN a system DSN and not a user or file DSN? Make sure the appropriate type is used.

2.  If the report is written against a native driver (eg. SQL*Net or DB2) does the local system account have permission to run this driver? Try running the page/job server services under a named user ID that you know can access the data.

3.  Install CR on the same machine as the page/job server and test the report there.

Back to Business Objects:Crystal Enterprise FAQ Index
Back to Business Objects:Crystal Enterprise Forum

My Archive

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close