EnterpriseOne Ad Hoc Reporting
Share
One thing that I have heard from many organizations about E1 is the lack of an Ad Hoc reporting tool. Report Design Aid (RDA) is great, but has a very steep learning curve and requires a "fat client". Because of this, it is almost impossible to use for those "one-time" situational reports.
Well, over the next few weeks both of our installations will be evaluating Data Access Studio by ReportsNow.
So far, it looks like a great solution. It’s been very easy to setup (I’m just waiting for a license key). The way we would like to use it involves installing a "fat client" on Windows Server 2003 with IIS installed. A user will then login using their E1 credentials and be able to design reports online. I believe that it uses an ActiveX control for the design and the integration with Excel.
I will post more information as our evaluation progresses.
What do you use as an ad hoc reporting solution?
Author
Stewart Schatz
Average Rating
One thought on “EnterpriseOne Ad Hoc Reporting”
Leave a Reply Cancel reply
This site uses Akismet to reduce spam. Learn how your comment data is processed.
More Stories
Windows God Mode… What!?!
Windows God Mode is a hidden feature in the Windows operating system that allows users to access all of the system’s control panel options and settings in a single place.
How To Test A SQL Server Connection
There is an easy way to test your SQL Server connection when running Windows without any special software. I found...
4 Lines To Export Outlook Rules To Excel/CSV Using PowerShell
I used to use a ton of Outlook Rules to organize the thousands of emails that I receive each day....
Get The Size & Record Count Of All Tables In A SQL Server Database
Use the SQL query below to display the size and record count of all tables in an SQL Server database....
How To Get AS400/iSeries Job Queue Information Using SQL
I received a request the other day about the JD Edwards EnterpriseOne job queues and what the maximum number of...
The EnterpriseOne CNC Job Description
The JD Edwards ERP Specialist is responsible for maintaining the JD Edwards EnterpriseOne platform and auxiliary systems from a development, CNC, system administration, and functional consultant perspective to create and maintain business solutions.
I have used Data Access Studio quite extensively at different client sites. It is very user friendly and much more flexible that Data Browser. I also like the fact that it requires E1 credentials, therefore utilizes E1’s security workbench.
-Patrick