Active Reports Resources - business

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
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>

Selection	File type icon	File name	Description	Size	Revision	Time	User

Selection	File type icon	File name	Description	Size	Revision	Time	User
	ċ	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

Selection	File type icon	File name	Description	Size	Revision	Time	User
	Ċ	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

Selection	File type icon	File name	Description	Size	Revision	Time	User
	ċ	Download	The Development Tool for ClientTrack Reports	3099k	v. 2	May 14, 2010, 8:54 AM	Scott Heffron