| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Rescue workbook"
(Created page with "Published reports will try to open any connections to database servers when they are run. In the case where the server is not available, the report can not be opened. If you ...") |
|||
| Line 5: | Line 5: | ||
This means grid data may not be visible, but you can use the standard Excel connection screen to update the connection when you open the workbook. | This means grid data may not be visible, but you can use the standard Excel connection screen to update the connection when you open the workbook. | ||
| − | + | ||
| + | If you use connection mapping, then you must set a [[XLCubed_Web_Edition_Installation_Guide#Behavioural_Configuration|web.config]] setting: | ||
UnmapConnectionsOnExport = false | UnmapConnectionsOnExport = false | ||
| − | Click the "Parameters" icon next to the report on the home screen (under the "...") and at the bottom will be a button that will generate the rescue url. Paste this into your browser and you will get prompted to download the file. | + | Click the "Parameters" icon next to the report on the home screen (under the "...") and at the bottom will be a "Rescue" button that will generate the rescue url. Paste this into your browser and you will get prompted to download the file. |
| + | |||
| + | If the "Rescue" button isn't visible then you'd need to check that you have permission to the "rescue.xml" file located in xlcubedweb\xml\security. You can create the file if it doesn't exist and use the following for the content | ||
| + | |||
| + | <?xml version="1.0" encoding="utf-8" ?> | ||
Revision as of 10:15, 4 January 2017
Published reports will try to open any connections to database servers when they are run. In the case where the server is not available, the report can not be opened.
If you need to download a report when it is in this state then you can try the "Rescue" tool which will attempt to download the report without running it.
This means grid data may not be visible, but you can use the standard Excel connection screen to update the connection when you open the workbook.
If you use connection mapping, then you must set a web.config setting:
UnmapConnectionsOnExport = false
Click the "Parameters" icon next to the report on the home screen (under the "...") and at the bottom will be a "Rescue" button that will generate the rescue url. Paste this into your browser and you will get prompted to download the file.
If the "Rescue" button isn't visible then you'd need to check that you have permission to the "rescue.xml" file located in xlcubedweb\xml\security. You can create the file if it doesn't exist and use the following for the content
<?xml version="1.0" encoding="utf-8" ?>
