Report Execution Error Pastel Xpress Version 18

From Sage Intelligence Knowledgebase
Jump to: navigation, search

Issue:


You will experience a Report Execution error when running reports from report manager. The reason that these reports run into errors is that the “auto connect” feature is checked for our demo DataBase.

Report error execution.png



















Resolution:


Launch the Connector module. Then you need to expand the enterprise tree on the left column. Look for a subtree called ODBC Driver for Access. Double click on it to expand the tree. You will then see the connection name called RKL Trading Demo. Click on RKL Trading Demo to open the properties for the connection. On the right hand side of the screen you will see a check box for Use Auto Connection System. By default this is activated with a tick switched on. You would need to remove the tick by clicking once on the tick. Then you can click the the apply button on the extreme right to save the change. Then you can close the connector module. Launch report manager and run out your reports as normal. The error should not appear any longer.


Connector setting before change:


Before.png




















Connector setting after change:


After.png