Skip to main content

Equivalent FMREPORTS SQL account on database to assist creating crystal reports

Written by Charnjit Singh Dharival

Are their connection details for the Orchestrate database for creating custom reports, like the FMREPORTS for FactoryMaster?


The Orchestrate database does not have a builtin login account like FMREPORTS to use on the FactoryMaster database.
​
Any custom reports will require consultancy which is a chargeable request.
​
There are reports within Orchestrate. Some of them didn't work in older versions of Orchestrate. but they have now been fixed in Orchestrate version 7.60 or above. For example, Actuals reports were producing empty cells for some columns. This has now been rectified.

  1. Select Reports

  2. Reports again

  3. expand Production

  4. expand Analysis

  5. select Actuals By Created Date

  6. Click Run

Did this answer your question?