> 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.
Hi Chris,
Comments. At my job, I create intranet reporting sites for my
company. I have some of the requirements you do. The solution I came
up with is to write the majority of my code in MSSQLSERVER stored
procedures. My web pages simply gather user form inputs and calls the
stored procedures. (If there was a simple way to create web pages via
IIS and MSSQLSERVER only with html forms and cookies and stylesheets,
I would do it.) Browsers are great for screen presentation but
terrible at printing. IE on the MAC even displays different than on
the PC (because the MAC has stricter parsing rules). As a workaround,
I create text or CSV files on my webserver and name them with user's
IP address. I then instruct the user to download them. --Louis