PLEASE HELP!! Error opening Crystal report!

[SmileyFace]

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.

 

[Madawc]

Are you saying that you can't run it? Or that it won't even open? I had a report that got corrupted and refused to open, luckily I had a backup copy, since there was no way to get that report opened again.

Madawc Williams
East Anglia, Great Britain

 

[SmileyFace]

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!

 

[hengisglasgow73]

Your heading down the right track. The Show SQL command is only enabled when you working off a server type database (SQL SERVER)and not a file database (MS ACCESS).

To set up a DSN pointing to the database on both your development machine and server - this normally requires the location to be accessable via a share.

Then set the locaiton of the database to that DSN. it should connect. OH and make sure the DSN names are the same

Hope that helps

Hengis

 

[SmileyFace]

Hey Hengis! Thanks for the information. I used that and it worked but then just moved my database over to SQL server so I could manipulate the query inside of Crystal itself and it works fine now!

 

[synapsevampire]

Hengis: That's not entirely true, you can set up an ODBC connection to an Access database, and use record selections to pass SQL to the database (verified in Show SQL Query), making Access appear to be a big kid database

Try it.

-k