If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
! Help on designing report managment screens for an app
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 ? |
#2
|
|||
|
|||
! Help on designing report managment screens for an app
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. -- Duane Hookom MS Access MVP "Savvoulidis Iordanis" wrote in message ... 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 ? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Opening reports causes report to open twice and produces errors | Matt the confused newbie | General Discussion | 7 | July 1st, 2004 09:32 PM |
Specify Filter criteria before running report | Nikos Yannacopoulos | Setting Up & Running Reports | 3 | June 25th, 2004 09:36 PM |
Label | SRIT | General Discussion | 2 | June 22nd, 2004 09:42 PM |
need help make a report | [email protected] | General Discussion | 2 | June 16th, 2004 08:31 PM |
Report button linked to exact report record- Open report method? | Rich | Using Forms | 1 | May 27th, 2004 06:17 PM |