! Help on designing report managment screens for an app

  • Thread starter Savvoulidis Iordanis
  • Start date
S

Savvoulidis Iordanis

What I want, is a good example of having database driven reports presented
to a user
with their proper parameters (as detail, as I can imagine), so that the
users select what to print
using a single point of start. How can such a report table(s) be like, and
how can such a form
be created, so that it can handle different type of controls for criteria
parameter (eg. drop down lists/radios
for certain values, simple text boxes or masks, etc...)

WHAT I REALLY NEED, IS A FORM THAT PRESENTS THE APPLICATION REPORTS TO
THE USERS AND BE BASED ON TABLES FOR REPORTS AND PARAMETERS

Is there anybody out there that has implemented a nice DB report engine ?
 
D

Duane Hookom

I have created a number of these in my work for clients. Much of the
functionality is based on tables.
tblReports (one record per report)
rptReportName objectName
rptTitle
rptDescription
rptStatus (ready to display in list of reports)

tblCriteria
criControlName (controls on a main report selection form)

tblReportCriteria (one record for each filtering control used on each
report)
rpcReportName
rpcControlName

My report selection form has a list box of all the available reports. As a
report is selected, some controls are enabled or disabled based on
tblReportCriteria. I also have a text box that displays the Description of
the selected report.

When the "Preview Report" button is clicked, code will loop through the
enabled controls to see if they have values selected that might filter the
report. Some of the controls might be simple text boxes for beginning and
ending dates while other controls are multi-select list boxes. The code
builds a "where" clause the is used in the DoCmd.OpenReport line.

I don't have a sample on the web anywhere and I can't share my client
applications so you are on your own for exact coding unless someone else has
this for you.
 
Top