Web based reporting software?

[Chris]

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

[louis nguyen]

Re: Web based reporting software?

> I'm hoping someone can recommend a web-based reporting software. My[color=blue]
> 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.[/color]
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

[louis nguyen]

Re: Web based reporting software?

louisducnguyen@ hotmail.com (louis nguyen) wrote in message news:<b0e9d53.0 312120747.40b26 8b0@posting.goo gle.com>...[color=blue][color=green]
> > 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.[/color][/color]

Hi Chris,
I forgot to add that MSSQLSERVER2000 is coming out with a free add on
called Reporting Services. It looks promising, but I'm still a little
vague about how interactive it is. (Permission/security who can see
what reports. Can the user select a different city/region/product on
the fly or do they query a different report.)

http://www.sqlmag.com/Articles/Index.cfm?ArticleID=40529