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