reports with input controls

I have a requirement to create a report such that there would be input controls on it so that a user could press a recalculate button and the information in the report would be updated.  I assume this is a somewhat similiar technology to what is used in tax software where it looks like you're filling out an actual form.  I'm just looking for some direction on how to setup the solution the the problem.  I'm developing this app using VS 2005 with VB.
PeterTrefrenAsked:
Who is Participating?
 
Jeffrey CoachmanMIS LiasonCommented:
Something like this:

JeffCoachman
Access-EEQ24170394FormAsReportCa.mdb
0
 
Jeffrey CoachmanMIS LiasonCommented:
Reports are not meant for "inputting" data.
They are meant for displaying and printing.

What you need is a "Form".

Depending on how the form is created, it can be made to update on demand or automatically.

If the form is based on a query, then the data you are inputting will be stored in a table, the form can update automatically.

Or you can opt to "unbind" the form and update the values "On demand", then send the values to a table to be stored.

Do you know how this data will be stored?

JeffCoachman
0
 
PeterTrefrenAuthor Commented:
The problem with using a Form is that it sometimes doesn't seem as intuative to end users as something that looks like an actual paper document.  This is why when you use tax software the Form you're working with generally looks like the paper return.  The update I'm working with is performed from a complex mathmatical caculation using VB.  This calculation has nothing to do with taxes.  I'm using ADO .NET against an MS Access database.  The issue is not how do I make Crystal Reports display input controls but how do I give the user the experience they are working with a paper document that can be printed.  I've seen where pdf documents are displayed with input fields so I thought this would be something that Crystal or other reporting packages might be able to handle.  
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
Jeffrey CoachmanMIS LiasonCommented:
Well, it is no big deal to make an MS Access Form look like a Report (a printed piece of paper), if that is what you want.
Let me know...

You mention Crystal Reports though, I don't think it is easy to create this type of interface in Crystal Reports, but I am reasonably sure it can be done in Access.

Again, let me know.

;-)

Jeff
0
 
PeterTrefrenAuthor Commented:
Just give me a basic idea of how I would create one in Access and I'll award the points.  I have a couple of references so I'll just look it up.  Thanks.
0
 
Jeffrey CoachmanMIS LiasonCommented:
OK, working on it now...
0
 
Jeffrey CoachmanMIS LiasonCommented:
;-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.