Web report development

[Jack]

Hi,
We have a web application(asp based) without any report features. I have to
build
web reports. Right now, these reports are build on an Access 97 desktop
application. The idea is to have our clients to print the reports via web
application.
I am wondering, what is the best way to develop web reports that would be
exact same as Access 97 reports. Thanks in advance. Regards.

 

[Ray Costanzo [MVP]]

Hi Jack,

There isn't really any quick trick or anything. It'd just be a matter of
duplicating the logic in those reports and rewriting everything for your ASP
app.

Ray at work

 

[McKirahan]

Hi,
We have a web application(asp based) without any report features. I have to
build
web reports. Right now, these reports are build on an Access 97 desktop
application. The idea is to have our clients to print the reports via web
application.
I am wondering, what is the best way to develop web reports that would be
exact same as Access 97 reports. Thanks in advance. Regards.

There may be a way to invoke the Report modules that exist in Access 97.

A Google search came up with:

Viewing and Printing Access Reports with ASP and/or VisualBasic
http://www.4guysfromrolla.com/webtech/042600-1.shtml

Viewing Access Reports in ASP
http://forums.devarticles.com/archive/t-2085/Viewing-Access-Reports-in-ASP

 

[Jack]

Hi Ray and McKirahan,
Thanks a lot for the various advises to handle web reporting with my
situation. I am going to weigh all the options and try to work on the
solution which would take the least time as I have very little time of
delivery for this projects. Regards.

 

[AL_LONGO]

Access 97 may support snapshot creation. If so, create your report as
normally and have a macro write the report to a location as a "SNAPSHOT". You
will need to then redirect the snapshot via URL. If the webuser doesn't have
the snapshot viewer, it will try to download and install in the browser. It's
free and it basically works like ADOBE. You will be able to view the report
on your browser as you would normally would in Access. It's a miracle!!!
Googleit: ASP ACCESS REPORTS or SNAPSHOT VIEWER.

Hope this helps,
AL

 

[Bullschmidt]

I mostly agree with this:

<<
There isn't really any quick trick or anything. It'd just be a matter of
duplicating the logic in those reports and rewriting everything for your
ASP app.
Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
http://www.Bullschmidt.com
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...