
Web-based data entry & reporting application
Hi.
I will soon need port a complex data entry and reporting application to run
in a web browser. The web server will based on a Windows NT server.
Some parts of the application have 6 page data entry screens that build lots
of pick-lists on the fly, and required substantial data validation and
feedback to the user. Transaction control will be a serious issue in case an
internet connection is lost in the middle of creating a record.
Also, I need to duplicate the local reporting capabilities that the users
currently have. I haven't seen any report writes that allow the user to set
up parameters for a report, fetch the data from the database server via the
web, and have it print to a local printer. I'm used to products like Crystal
Reports and the MS Access report writer.
Can anyone suggest a good source of information about how I can do these
things using MS SQL Server 6.5, Visual Basic, Visual InterDev, and other
tools? Does anybody know of existing sites that provide such functionality
that are visible to the public?
Thanks for any help and direction.
-Peter Stelman
What would be the issues to watch out for in developing such a system? What
about security? This application will be used world-wide, but only be
authorized users.