Over the last couple of weeks I have been involved in generating business reports from a relational database.
Some of the existing reports had been written using Excel and macros. The inherent problem with this method was the time it took to produce the report, the lack of ability to dynamically alter the content of the report and finally the problems with maintainability of the report.
I attempted to convert some of these reports into a single, more generic, automated and easily maintainable report by using Crystal Reports. I hit a snag.
The problem with CRW is that one can not (it would seem) add colums to a report and dictate what must be reported in the column.
Secondly, I need to pick up additional (ubdetermined nos of) columns from data residing in the database… dynamic requirement of the report.
Has anybody got another suggestion, or alternative tool that I may try?????