Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Complicated Report on Gov. Form

Complicated Report on Gov. Form

Complicated Report on Gov. Form

I have a report that really needs to be produced on a Government form. In the past I have used a high quality scanned version of the form behind a bunch of bound and unbound text boxes. (The unbound ones were filled manually by the user.) Pretty crude huh?

Now I would like to do this right, but the data is pulled from the database and twisted and turned and manipulated in so may ways it will take a series of crosstab queries and quite a few subreports to do it. This report has 202 label boxes and text boxes and is letter size. All these boxes are connected and the report needs to look enough like the Gov. form that people would not know the difference. Should I try to overprint the report, create the whole report in access, or forget the whole thing for 1 report a month?

RE: Complicated Report on Gov. Form

For one report a month?

Let them crank the paper into a typewriter and fill it out.  Your effort in producing a trivial piece of code to do the work will take more time and effort than filling the report out manually for the next 10 years.

Just produce a report that includes all the information they need to fill in the report, in the same order that it appears on the report.

RE: Complicated Report on Gov. Form

My vote would be to do the form/report.  Any "opbject" that needs > 200 fields filled in should NOT be given to human typist.  Further, the 'REAL' work is in generating the dataset/record to support the thing, not in the boring/trivial/frustrating ... work in reproducing the "form" look and feel.  After all, this is just a series of labels and lines with some occassional strange fonts.

I have not done this type of work in a couple of years, but many of the U.S. Gov. "Forms" were available from Unc. S. over the internet in a variety of formats, at least two of which made the layout very easy (Word Perfect, and ? Adobe PageMaker ?) where you could just see the location info, font, font size, etc in the privided document.  Much more accurately than the scanner approach.

Most of the Gov. Forms I have done did not require anywhere near the 200+ items of info you are discussing, but I was generally able to "reproduce" the form atthe rate of ~ 2 pages per day, and the dataset to fill them out somewhat faster - probably because so much of hte data was redundant.


RE: Complicated Report on Gov. Form

Just my .02...how about recreating the report in excel, and using ole to enter the values into the cells.  After most of the data is entered, it would be simple enough for a user to complete the entry and print out the report.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close