This training program is designed to teach the user how to use Active Reports to enhance the ClientTrack application. The training program will show the user how to generate data with specific run-time and sort criteria (such as date ranges, data fields, and sort orders). We will also show how to extend the reporting capabilities for client demographics, service information, statistics to support organization funding and to reflect accountability.
Training Classes: | Session(s) | Description | | Active Reports Beginning | This course is used to introduce students to the Active Reports environment, architecture and specifications. This session will introduce the student to the database objects stored in the database and the SQL language that is used to access the data in the database. | | Active Reports Intermediate | TBD | | Active Reports Advance | TBD |
Tips and Tricks with Active Reports | # | Description | | 1 | Area [Format Border Properties]: Inside of the integrated development environment (IDE), the ActiveReports objects have a property called "Format Border". You and access this property from the context menu of the object. The issue here for this tip is that the format looks correct while being displayed on the workstation through the preview process. Unfortunately this property does not work when uploaded to the web based application. The developer will need to use the "Line" object to emulate the object borders.
| | 2 | The check box report object can be instable. One option to fix this issue would be instead of using a checkbox object, the user can use line objects to make the appearance of the checkbox and in the SQL code use a case statement to configure the presentation. This reason for this is because a checkbox data type is either on ('X') or off (' ')
SELECT Column1
, ColumnX
, CASE <TargetColumn>
WHEN TargetColumn IS NOT NULL THEN 'X'
ELSE ''
END AS 'TargetColumn'
FROM <TargetTable>
|
Code Snippet(s): Snippet is a programming term for a small region of re-usable source code, machine code or text. Ordinarily, these are formally-defined operative units to incorporate into larger programming modules. Snippets are often used to clarify the meaning of an otherwise "cluttered" function, or to minimize the use of repeated code that is common to other functions. Click here to go to ActiveReports Code Snippets.
|
|
