One Touch Reporting - An error occured while using the template

One Touch Reporting - An error occured while using the template

Issue:


When trying to create a OTR report from Forecast 5, you are receiving the error below:


 

Cause:


This can be due to a number of reasons:

1. The excel template you are trying to use is already open.

2. The forecast name contains characters that are invalid for an excel name.

3. You do not have permissions to write to the Documents path


Solutions:


Reason 1: Excel Is Open

1. Close all open excel templates and check no processes are running in the background. 

2. Try run the report again.


Reason 2: Invalid Characters

1. Check the forecast name does not contain any invalid characters, e.g. \ - / ? !

2. If you are unsure, create a new excel sheet, click Save As, then copy the forecast name as the excel name.

3. If you can save, then move to reason 3. If you can't save, remove any characters.


Reason 3: Permissions

2. In your Windows Explorer, Right-click on Documents and click on Properties:

2. Click on the Security tab and click Edit. Then, in the next window, click Add..


3. In the white box, type Everyone. Click Check Names and then Ok.

4. Click on Everyone, add Full Control to the Allow column, then click Ok.

4. Run the report again.


    • Related Articles

    • One Touch Reporting: The report is showing old figures.

      Question: When running my One Touch Report, it is showing old figures or dates in the reports exported. Answer:  One Touch Reporting saves the exported report into your Documents folder, using the name of your forecast. If you have run the OTR report ...

    • How To: Use One Touch Reporting (OTR)

      Try the template (at the bottom of this page) to see how it works. Overview The One Touch Reporting (OTR) feature is designed to reduce the amount of time taken to produce final and quality reporting. Using the One Touch button, you can drop your ...

    • SQLException: A network-related or instance-specific error... [Error: 52]

      Issue: Forecast 5 cannot continue because of an exception occured: SqlException Solution:   This error is generally caused because the Forecast 5 cannot find the SQL Server you are trying to connect to. Please check that your computer can see the SQL ...

    • GST/VAT Rate Error: TargetInvocationException

      Issue / Error Message: When opening a forecast, the following error occurs:   TargetInvocationException Exception has been thrown by the target of an invocation. NullReferenceException Object reference not set to an instance of an object.    at ...

    • Consolidations: An error has occurred while creating/opening the forecast.

      Issue: When trying to complete a consolidation, you are receiving the following error: "An error has occured while creating/opening the forecast. If this is a consolidation, please check that all records are named correctly to avoid duplicate record ...