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
How to Use DebugLogLevel Registry Value to Debug Report Desk Issues
Release Date: TBA Version 8.6 Since Report Desk is a brand new feature of Elliott V8.5, you may encounter a problem with it. If you do, a Netcellent support representative may ask you to turn on the debugging of Report Desk so a log file can be ...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 ...I Cannot See the Spooled Reports Even though I Am an Administrator Equivalent User
Release Date: 08/16/2017 Q - I am an administrator equivalent user, I logon to the PSQL server to run Elliott V8.2. I do this because I was instructed to run Deferred Processing on the PSQL server since the performance is much faster. My PSQL server ...Feature: Joining Databases in PowerSearch and Report Desk
Release Date: 6/13/2024 Elliott Versions: 8.6 and Higher Background PowerSearch and Report Desk provide powerful abilities for our users to easily access and customize fast, powerful, and complex searches and reports. The default database for these ...Feature - Sales Promotion Desk
Release Date - 8/30/16 Sales Promotion Desk Introduction In Elliott Business Software, Item Master table, we have the following fields that allow users to put an item on sale: Start Sale Date End Sale Date Sale Price If customers purchase this item ...