Crystal Reports worked great for me. Even had ActiveX and ASP versions. Only problem was Seagate Software was in Canada and CR was quite buggy. So I got docked in my paycheck for calling Canada. It is SAS now I think.

Lotus Approach also did the same as Access.