×
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!
  • Students Click Here

*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.

Students Click Here

Jobs

*****REALLY NEED SOMEONE'S HELP WITH SQL ERROR*********

*****REALLY NEED SOMEONE'S HELP WITH SQL ERROR*********

*****REALLY NEED SOMEONE'S HELP WITH SQL ERROR*********

(OP)
Hello,

I have installed the crystal report viewer on someone's p.c that does not have crystal reports installed.  The version of crystal I am using is 7.0.  I run the setup program and all files install correctly.  I setup the ODBC connection(SQL SERVER) and tests complete successfully.  However, when I run the report by clicking the print with the refresh data checkmarked, the client's computer crashes.  I get this dialogue error box saying PRINT ENGINE ERROR  Error in file c:\program files\seagate software\Distributed reports\New Month End.rpt.  SQL server error.  Does anyone know why I am getting this error.  I install the same report on someone else's P.C and it works correctly.  Is this profile related?  Any ideas would be very helpful.  Thanks and great forum.

RE: *****REALLY NEED SOMEONE'S HELP WITH SQL ERROR*********

What is the difference between the 2 PCs?
Which viewer are you referring to and how did you set it up?
Does the person have permissions to all needed directories and files?

Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB
http://www.kenhamady.com/

RE: *****REALLY NEED SOMEONE'S HELP WITH SQL ERROR*********

Thanks for your quick reply Ken.  
I checked to see if there was any difference between the 2 p.c's with regards to permissions, ODBC versions etc.  Unless there is something else I should be checking for, I think I captured the majority.  I found nothing to be different. The viewer I am referring to is the free crystal viewer that get's installed with the distribution files.  Yes the person has all necessary permissions.  When I use the distribution expert in crystal, it creates files necessary for someone who does not have crystal software installed on his/her p.c.  I run the setup program that the distribution expert has created and follow the instructions.  I have done this many times for other people in the same department with the same report and it works fine.  We have checked the SQL permissions and everything is comparable to someone who is accessing the same report. Again, I am using crystal 7 and the viewer version that gets installed with 7.  Thanks Ken

RE: *****REALLY NEED SOMEONE'S HELP WITH SQL ERROR*********

Try a report with saved data.  If that works it is the data connection.  If that doesn't work either, then it is the report engine.

Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB
http://www.kenhamady.com/

RE: *****REALLY NEED SOMEONE'S HELP WITH SQL ERROR*********

(OP)
Thnaks Ken,

I have tried both situations and that did not work.  I tried to reinstall the distribution files and run the setup again.  That did not work either.  When you say it is the report engine, what can I do about this.  Yours suggestions will be helpful.  Thanks Ken.

RE: *****REALLY NEED SOMEONE'S HELP WITH SQL ERROR*********

Neither the PC that works nor the PC that doesn't have CR?

You are sure that the report had saved data?  The test is if you close it and reopen it in the designer and it immediately goes to preview.

Was it was run from the compiler with the saved data?  You get the choice of saved or refresh if there is saved data.

If it can't run the report with saved data, which doesn't even need the ODBC connection, then the compiler is not installing correctly or a dependant file is missing.  You may need to do a DLL comparison between the 2 PC's to see what is different.  There is a utility for this on Crystal's web site.

Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB
http://www.kenhamady.com/

RE: *****REALLY NEED SOMEONE'S HELP WITH SQL ERROR*********

What are the different printer setups on the two PC's.

I've found Cr has major problems if a printer isn't configured correctly.  
What is the default printer on each?
What printer was the rpt designed against?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

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