Resources‎ > ‎Reporting‎ > ‎

Active Reports Resources

This page will store information on the different Tips, Tricks and Code Snippets  that CTR-SQL has used when developing Reports using the ActiveReports tool set.


Tips and Tricks:
#Description
1Area [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.
2The 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>



SelectionFile type iconFile nameDescriptionSizeRevisionTimeUser
SelectionFile type iconFile nameDescriptionSizeRevisionTimeUser
ċ

Download
This is a base line report that can be used for a Listing or detail report.  5k v. 2 Apr 26, 2010, 7:32 PM Scott Heffron
SelectionFile type iconFile nameDescriptionSizeRevisionTimeUser
Ċ
View Download
We want to make sure that the user can distinguish the information that is presented in a listing type of report in an easy and effective manner. This can be done by making sure that every other line will alternate a distinct color.  56k v. 2 Apr 26, 2010, 7:30 PM Scott Heffron
SelectionFile type iconFile nameDescriptionSizeRevisionTimeUser
ċ

Download
The Development Tool for ClientTrack Reports  3099k v. 2 May 14, 2010, 8:54 AM Scott Heffron