• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 242
  • Last Modified:

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.
0
PeterTrefren
Asked:
PeterTrefren
  • 5
  • 2
1 Solution
 
Jeffrey CoachmanCommented:
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
 
Jeffrey CoachmanCommented:
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
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
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 CoachmanCommented:
OK, working on it now...
0
 
Jeffrey CoachmanCommented:
Something like this:

JeffCoachman
Access-EEQ24170394FormAsReportCa.mdb
0
 
Jeffrey CoachmanCommented:
;-)
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now