×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

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.

Students Click Here

URGENT: Errror opening Crystal Report

URGENT: Errror opening Crystal Report

URGENT: Errror opening Crystal Report

(OP)
Can anyone please tell me why I would not be able to open a report in this particular folder using my asp page when I can open other reports in the same folder using the same page? I thought it might be accepting parameters but I cannot seem to find where!!! This is reallly frustrating me now! The other reports in the same folder.. I can view the 'Show SQL Query' for them but am unable to do so with this one...it is disabled in the desgin view. Help! I am able to open this report directly from the folder and run it. At that time it doesn't ask me for any parameters. Thanks in advance for your help!

RE: URGENT: Errror opening Crystal Report

It does sound like it's based on a Stored Procedure.

Open the report in CR, does it prompt for parameters? If so, then it's likely a Stored Procedure.

Are you getting errors?

What's in Database->Set Location?

Show SQL Qery doesn't help describe a datasources origin, the Set Location will though because you can select options and reduce the view to only SP's.

Generally it's best to supply some information about your environment, such as the database used, version of CR, example of what you tried, and any error messages.

Here's the CD whitepaper on ASP applications:

http://support.crystaldecisions.com/communityCS/FilesAndUpdates/aspxmps85.exe.asp

-k

RE: URGENT: Errror opening Crystal Report

(OP)
It seems to be a DSN problem. The database that its accessing on the server cannot be read by the report for some reason. The error message is as follows: 'CRAXDRT Error Occured on Server. - 2147189136: Logon failed.
Details: IM002:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.'

The other reports in the same folder...one accesses our SQL server database which resides on another server and the other one accesses one on my local machine. I have a an Access database with my asp page and report on the same server but it looks like it will not read it.

Any idea what I would need to do? I think I have to set the DSN name on the server for that database but not sure how to do it. Please let me know if you do. Thanks!

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