Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal report which runs off access database will not run

Status
Not open for further replies.

tsouth4

Programmer
May 2, 2007
46
US
Sorry for such a long post but i'm trying to be as thorough as possible. Thanks for any help in advance.

I have a very simple report which I need to create and am having trouble doing so. Heres what I need to do... Our Technology department has an excel spreadsheet which it maintains as new users are added to our system. To keep things short the spreadsheet tracks users and their phone #'s. The excel file is stored in a shared drive which only a few select people have access to. The goal is to keep maintaing this document in the shared drive folder however enable our admin department to access the document with the ability to view and not edit. I know that excel has view only rights..etc... But we would rather not allow users access to the shared folder. So heres what I did. For testing purposes I tried two things I saved the excel spreadsheet in a shared folder which I have access to on my local machine. I created an access db which references the excel spreadsheet so that each time the excel spreadsheet is edited it will automatically update in the accesss db. In one instance I connected to the excel spreadsheet. This works fine on my computer however when I publish to the business objects enterprise the report fails to run. I did the same for the access database and it runs fine on my local machine however fails to run in the infoview. I receive the error below in both cases.

CrystalReportViewer:

Failed to retrieve initial report values. For example, the database information for this report could be incomplete or incorrect. This is a configuration problem. Please contact your system administrator.


ERROR: Failed to retrieve initial report values. For example, the database information for this report could be incomplete or incorrect. This is a configuration problem. Please contact your system administrator.


A few things to note which may be causing this the. I remote desktop in to the our reporting server machine. This machine has access to the same shared folder which my databases are saved in. However this machine does not have microsoft office on it so I am unable to open these files. Any help would be greatly appreciated.

-Tim





 
Hi,

Few things about this:

1. The ODBC needs to connect to the access DB using UNC path \\server\share\file.mdb and NOT mapped drive

2. Make sure the necessary services (CR Page and CR Job with Crystal) are started with a domain account with permission to this share.

Done!
Pat

Business Objects Consultant and Trainer
BOCP - BOE and CR & Official Migration Specialist

BI Toolkit - Offices in UK and Holland
 
Pat, thanks for the reply but I cant seem to get this to work. Am I doing this wrong? I'm going into the current connections-> create new connection -> Aceess/excel (DAO) -> insert unc path in the database name \\Fileserver003\Reporting\DID\DID_Inventory.mdb -> database type access and this report runs fine in CR XIR2. There is no password on this database and i am leaving secure login unchecked. However when i publish the report to the enterprise it fails to run. Thats when i recieve an error message. I have left the password and login blank in the CMC and checked the box so it does not ask the user for the login info. Any help?
 
when you are running in the CMC,, hit the preview button on the report,, see if you can generate it. Also,, the machine, that you are using to distribute the reports, needs to have the odbc setup to the database.
 
I receive the following error when I hit the preview button


Error in File DID Inventory: Failed to load database information.

Unable to retrieve Object.
Error in File DID Inventory: Failed to load database information.


by the machine i'm using to distribute the reports do you mean the server?
 
Yes the server. It should be able to connect to the machine where the tables are.
 
Not sure what jmd0252 is trying to say...

This is simple architecture: Web Viewing of Crystal Reports (Infoview or CMC) = CR Page Server doing the database connectivity and when scheduling it's the CR Job Server.

For those services to see your DB on the network: make sure the necessary services (CR Page and CR Job with Crystal) are started with a domain account with permission to this share.

Regarding the ODBC:
1. Go to Admin Tools on your Windows Server
2. ODBC
3. System DSN
4. Add
5. Microsoft Access Driver (.mdb)
6. Enter the full UNC (\\something) as described above.

Pat



Business Objects Consultant and Trainer
BOCP - BOE and CR & Official Migration Specialist

BI Toolkit - Offices in UK and Holland
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top