Discussion Locked

Report generating tools

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?????

1 reply

by lindaewen

Access can link to most databases and, using temp tables especially, can produce nearly any report you want.

By the way, if possible, go for Access 97 - the newer versions are buggy.

This discussion is closed to new replies.