www.Usenet.com
www.Usenet.com
| <-- __Chronological__ --> | <-- __Thread__ --> |
My company currently generates a large number of reports in Excel that are
basically produced by VBA macros querying a relational database and
formatting the results. Since this is somewhat tedious and the developers
here have limited SQL skills, I've been looking at using some sort of OLAP
tool to simplify the process.
The report formats tend to be fairly complicated and I've found that
using and kind of point-and-click pivot table-like front end isn't
flexible enough. I'm looking for what I've seen called 'disjoint'
reporting.
Using straight MDX is out, since, as I mentioned, the developers here
already have trouble with normal SQL. I've been looking at various
ActiveX products, but their object models seemed only capable of
automating the creation of pivot tables or whatever their built-in user
interface is. I've also looked at XLcubed, which supports disjoint
reporting, but it doesn't seem to have an ActiveX interface.
What I think I need is an ActiveX version of something like XLcubed.
Any suggestions?
| <-- __Chronological__ --> | <-- __Thread__ --> |
