saving excel spreadsheet on server for reporting

server administration XI Server Discussion
1

Hi All,

I wanted to know if there is a way to save an excel spreadsheet on the BOE server. I have .xls which i want to use as a datasource for my reports. Reports run fine from the desktop since the .xls is also saved on desktop but if i want to run from infoview i get an error " failed to load database" I am assuming that I will have to save the xls somewhere on the server but how and where?

Kindly suggest. version XI R2

Thanks

nb4884 (BOB member since 2010-07-20)

2

create a network share on the BOE server(could be anywhere on the server) that you want to store the file on and point your data provider to it from your desktop and try running the report (\myserver\sharename\myexcelfile.xls). If it works from your desktop, it should work just fine from the server as well. The only issue(s) you may run into is directory permissions/file access; that should be easy enough to work through.

jresendez :mexico: (BOB member since 2004-05-03)

3

Thanks jresendez

Can you please let me know the step by step , I am new to BO.

I have access to BOE server via virtual server logins and do have admin access. How shall i proceed to create a network share? please let me know step right from the login to Virtual BO server.

Many Thanks

nb4884 (BOB member since 2010-07-20)

4

All that is basically involved is connecting to the server, select a folder that you want to create a share for and right-click and select ‘sharing and security’ this should open up the properties dialog box for that folder w/the security tab selected. On that tab, you need to select the ‘share this folder’ option and give it a name. After you give it a name, click apply and the contents of that folder will now be shared. You also need to grant access, so in that same dialog box there will also be a security tab, select it and add the appropriate users/groups with the required security (you can probably set it to give ‘everyone’ rights so that you can test). Once you are done setting permissions, you should be able to connect to that server share from any other network machine using the following
\servername[share i just created]
this should open the folder and display the contents of that folder.

hope this helps

jorge

jresendez :mexico: (BOB member since 2004-05-03)