Report Desk Company DSN missing. Ask your administrator to run EL860CF
Release Date: 6/26/20
Version: 8.6 & Up
Q - When I try to run a report in Elliott 8.6, I receive the following message:
"Report Desk Company DSN missing. Ask your administrator to run EL860CF."
See sample screen below:
What should I do?
A - Report Desk is a feature in Elliott 8.6 that is based on the PSQL relational engine. If you choose to turn on this feature in Global Setup -> System -> Comp. Specialized Control -> Flag "4. Use Report Desk?," then you will need to indicate the DSN that will be used to access this company. You can do this through the EL860CF.EXE utility, or you can edit the EL860.CFG file. See the following sample screen for turning on the Report Desk feature:
Create or Manage Database (DSN) on PSQL Server
Before you can indicate the database (DSN) to be used for Report Desk, you will first need to make sure that you have created the database on the PSQL server. The following is a sample of databases available on a PSQL server through the PSQL Control Center view:
To create Elliott database by following Elliott's naming convention, please see the following KB article:
To manually create database in PSQL Control Center, please see the following KB article:
To use EL860DB.EXE utility to create the PSQL database, please see the following KB artilce:
Define Report Desk Database Name
Use Notepad to Update EL860.CFG
Once you have created the database on the PSQL server, you need to indicate so in the <ElliottRoot>\Bin86\EL860.CFG file. See sample screen below:
You can use an editor like NOTEPAD.EXE to edit this file directly. Keep in mind that sometimes NTFS security may prevent you from saving your changes, so verify your changes afterwards.
In the above example, you can see that company 01 is using ELIDATA (Elliott 8.2 DDF) instead of ELI86DATA (Elliott 8.6 DDF). The reason for this is because Elliott 8.6 DDF defines all document numbers as strings. If you have not converted your Elliott database to use alphabetic document numbers, then you should continue to use Elliott 8.2 DDF to access your data.
Use EL860CF.EXE to Update EL860.CFG
If you don't feel comfortable updating the EL860.CFG file, you can use the utility <ElliottRoot>\Bin86\EL860CF.EXE to update it. See sample screen below:
Once you have the proper database defined for the company, you will no longer receive the error message. As you start a traditional Elliott report, you may see the following Report Desk Selection window pop up:
The "Legacy" report is the one you used to report. All other "UDRs" (User Defined Reports) are new Report Desk reports.
EMK
Related Articles
Report Desk: Missing Column Title
Release Date: 1/8/2023 Elliott Versions: 8.6 and Later How to Fix a Missing Column Title Occasionally, during custom report development, you may see something like the following when you first run the report: In this case, the column title ...Report Desk: Documentation Roadmap
Release Date: 4/28/23 Version: 8.6 Setup and Configuration The following articles explain initial setup and ongoing maintenance of Report Desk: Report Desk: Setup and Configuration : Initial installation and ongoing maintenance. Elliott V8.6 ...Report Desk: Setup and Configuration
Release Date: 4/28/23 Version: 8.6 Report Desk provides a powerful developing environment for Netcellent to deliver modern reports with rich elements of proportionally spaced fonts, graphics and line drawing. It allows us to output reports to PDF, ...Feature: Report Desk AR Statement
Release date: 5/5/2023 Elliott Version: 8.6 Overview Beginning with Elliott version 8.6, there is a new ability to create more professional looking Accounts Receivable statements. The following standard features are included: Accounts are ...Report Desk: Notifications
Release Date: 8/31/2022 Elliott Version: 8.6 and Higher Background Some Report Desk reports may contain sensitive information or may need to be tracked for other reasons. Elliott Report Desk allows for email notification whenever a report is run. ...