My company has a set of forms they would like available on our website. They would like users to fill out the forms, store the data and print the form. I can create the forms in VFP and output to html. But how do I print the report from the web?
The data would be stored in a database on the website. The report could be printed by the user at time of entry or later by a staff member. Basically, management wants an online employment application app. We have scads of paperwork to do before anyone actually takes a job and this an effort to reduce paperwork and reduce rekeying data when someone is hired. We deal with thousands of employees and God knows how many applicants!
Sounds to me like your problem is not how to print the forms, but how to produce reports from the database.
In fact, I'd go further. Judging from your second message, I'd guess that what you're really asking for is some advice on how to design the application.
My apologies if I'm wrong about that.
Mike
__________________________________
Mike Lewis (Edinburgh, Scotland)
The application is just a set of forms on the website. The input data will be stored in a database. I'm just looking for a way to print the form once it is filled out without using the IE File, Print routine. Any advise or guidance you have on this subject is welcome.
You want the user to print the form (in other words, you want to print on the client side), right? If so, that's not under the control of your application. It's up to the user to use the browser's Print command to do that.
The best you can do to help them is to produce a printer-friendly version of the form. But that's not a programming issue. That's a matter of designing your HTML so that it fits snugly on a page.
You could also provide a button or link on the form that says "Print this page". To do that, you would have to write some client-side code to trigger the printing. You can't write that code in VFP. You have to use a scripting language, which (given that you don't know anything about the user's choice of browser) means JavaScript. Any elementary book on JavaScript will tell you how to do that,
My apologies if I've misunderstood your question.
Mike
__________________________________
Mike Lewis (Edinburgh, Scotland)
Sounds to me like you need a 3rd party software like Westwind or Active FoxPro. You need to insert code into the HTML document (at design time) to capture the users inputs and store that input into a company table. Then use a back end report generator VFP/Crystal to print the table.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.