I am interested to know if anyone is using Sage 100 or MAS 200 and is doing anything with business intelligence for reporting. The only reporting mechanisms I have are crystal reports and Sage Intelligence. Each has their drawbacks, notably the complexity and immense time it takes to create those reports.
What I am looking to see if anyone has done is to web enable the reports? I am looking to see if we can pull reports via a web page and have the results appear in the browser. Or even simply have an iframe contain the results of a specific report. This would eliminate the need to manually run and wait for reports, as many may take several minutes to run, but then must be re-ran all the time for updates.
Unfortunately Sage 100 is not on a SQL database, but rather providex. It does have ODBC drivers to link to its tables.