| Multiple Sequential Sections |
|
Display a control dynamic depending on 2 details sections
|
|
Description :
A regular good design of commercial reports and these could be basic requirements
to reports.
The usage of multiple sequential sections are used for the following
reasons :
- Usage control of reports and general characteristic control.
- Report specific parameter display.
|
#
Userid
& passwords for the database
This is taken into the reports as
parameters, these has to be passed to the report from the front-end tool(
this can be any GUI tool). Usually this information is kept in a text file
with the front-end application. So any changes to the database Id's is
transferred to all the reports without re compiling the reports.
The following code in the NEW method of connect object will take care
about the Database Id's.
Sub New( )
Super::New( )
HostString = ps_DBHostString
Password = ps_DBPassword
UserName = ps_DBUserName
End Sub
|

|
# User
verification
First report section checks the user id & password from a database for authoring him to run the report. If there is not sufficient user permissions for this user. The report execution process terminates at this level.
Most of the general characteristics of the reports are supplied can be controlled through a table. The first report can get those parameters to control the report.
|
# User
specified parameter display
At the end of the report it will be always better to display the
parameters used in the report and report generation details. This is
done at the frame in the sequential section after the second report
section. The display parameters are collected from all the parameters
entered.
|
|
|