Nick,
I have used InfoReports in the past.  It is basically a point & click SQL
query generator with some neat features.
I think CA bought this package.  You could also write your own SQL  selects
and perform as macros or server scripts.

MV

        -----Original Message-----
        From:   Nick Rutherford [SMTP:Nick.Rutherford AT HONDA-EU DOT COM]
        Sent:   Thursday, November 18, 1999 7:59 AM
        To:     ADSM-L AT VM.MARIST DOT EDU
        Subject:        Reporting tools

        Hello all,
        can anybody offer me a solution for generating reports on client
archives.
        We run archive schedules for departments on a periodic basis and
they would like
        a report of what is archived each time. Are there any reporitng
tools on the
        market that can perform such an action?

        Thanks for any ideas,

        Nick.