on 09-29-2017 10:36 AM
I'm trying to set-up a scenario where:
For this i created the CR2013 report via the DOA connection ("Excel 8.0") and i can create run the report fine from with the CR2013 desktop application (with the .RPT file being stored on the BI server)
When i open the RPT report via the CMC or the launchpad (right click > view), it opens ok, but when i try to refresh, i'm asked for a database logon.
No matter what i fill in (my own credentials, the credentials of the SIA user,..), nothing is accepted. I also tried numerous options in the 'Database configuation of the context menu, no result..
>> Is this scenario feasible?
(additional info : the SIA user has access to the .XLS file since a parallel setup with WebI works: i can create a Webi document on the same file and am able to schedule/push this webi via the Publication functionality)
Ian, Don,
thank you for taking the time to answer.
In the meantime i managed to solve the issue. It's rather obvious, so i feel quite stupid :-).
When creating the report in CR2013, i accessed the file on the shared network folder and/or BI server via a mapped drive location (eg: "Z:\OPERATIONS\REPORTS\Source1.xls" ). When refreshing the reports from witin CR2013 this off course works since i'm online and he can find the file. When refreshing from within BI Laucnhpad, this doesn't work.
>> After changing the path to the source file using the SNC (in our case "\\<xxxx>.lcl\data\OPERATIONS\REPORTS\Source1.xls"), i can refresh it from within the BI launchpad
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Have you checked database logon in in CMC.
In drop down above Database user and password, they is a drop down list of options.
Default is to request DB logon details each time report is run. Change to option which says something like use credentials in report.
Ian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You likely need the Office 2010 runtime installed on the BOE Server, WEBI does it different than CR.
Don
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
77 | |
9 | |
9 | |
7 | |
7 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.