I use Crystal Reports - every time.
ActiveReports (search for it, can't remember who makes it) is supposedly
good also. I was going to try it but decided that since I was already
fluent with Crystal that I would pass it up.
One bad thing about Crystal web reports is that the developer edition only
allows for around 5 concurrent uses. I have built web reports using both
8.5 with ASP and the 9.0 that comes with .NET. Using .NET and 9.0 has been
a major improvement and delivers some decent html using DIV's for accurate
placement of report objects. No browser plug-ins necessary, however any web
reporting solution you do should take advantage of producing a Acrobat PDF
document for download, or page transition and load for the purpose of
printing. You don't have to go to sql server to use this stuff - hopefully
you are hosting all of this yourself, otherwise your problems will be much
more complex by not having full control of the server.
If you expect to have more than 5 concurrent users you are talking about
some $$$$$ for the enterprise edition. The report building components are
large and take some processing power. Fast cpu's, bus, 320 scsi arrays, and
memory contribute to success in this area.
Good Luck! :)
--
Jerry Boone
Analytical Technologies, Inc.
http://www.antech.biz
"Chris" <kr*****@nrel.colostate.edu> wrote in message
news:d0**************************@posting.google.c om...
Greetings all,
I'm hoping someone can recommend a web-based reporting software. My
database is currently in MS Access, but could be ported to SQL Server
if necessary. Would prefer a broswer independent tool with no plug-in
requirements. Would also prefer it to be compatible with existing ASP
code (rather than ASP.NET). We don't need on-the-fly query creation,
but do want pre-formated quality layouts including headers, footers
and controled page breaks.
Any suggestions or direction would be most appreciated.
Thanks,
Chris