White Papers, Webcasts, Case Studies on Actuate

The Matrix Link Libraries for Actuate are a collection of Actuate Libraries and Actuate Basic files which you can use in your own reports or as a source of ideas. Some sample reports are also included.

Download Libraries

Available Files:

MatrixLink.rol	Actuate Library containing a number of useful classes, mainly simple extended functionality versions of the standard AFC classes.
MLDebugLog.bas	Actuate Basic file containing debug logging utilities.
MLExcelConstants.bas	Actuate Basic file containing constant definitions for use in Excel methods. This is not complete, it only has the constants I have used so far.
MLProgress.bas	Actuate Basic file containing functions specific to the Progress database. See the comments in the file for details.
MLSQLQuery.bas	Actuate Basic file containing functions to perform SQL Queries independent of the main query of a report. The code here would form a useful basis for executing other SQL statements. See the comments in the file for details
MLSQLServer.bas	Actuate Basic file containing functions specific to the SQL Server database (also useful for Access/Jet databases). See the comments in the file for details.
MLStrings.bas	Actuate Basic file containing string functions. See the comments in the file for details.
MLFindContainerByClass.bas	Actuate Basic file containing the MLFindContainerByClass() function. See the comments in the file for details.

MatrixLink.rol

MLBelowFlowFrame	A Frame class which appears below the flow (strictly speaking it extends the flow to hold it). Useful for remittance advices on multi-page statements, etc. See the comment in the class for details.The example report BelowFlow demonstrates the use of this class.
MLFrame	A standard Frame class with a widow- and orphan protection functionality. You can set the minimum space needed to the bottom of the frame, if this is not available, the frame will automatically start on a new page.
MLOverlayHeadingFrame	A Frame class which allows a hanging / indent style in which contents frames sit on top of or beside their corresponding subtitle (before) frame. The example report HangingFrame demonstrates the use of this class.
MLProgressConnection	A Database Connection class which can use an ASCII file to set its connection properties. Useful to allow speedy reconfiguration of your Progress database server without the need to recompile all your reports. See the comment in the class for details. It would be easy to make versions of this for other databases just by copying and hacking code from this class, but I have a neater scheme planned.The example file Miscellaneous contains a sample file for use with this class.
MLRemoveBlankLinesFrame	A Frame class which removes blank lines within itself. This is particularly useful to remove blank lines from addresses, etc. See the comment in the class for details.The example report HangingFrame demonstrates the use of this class.
MLRunningTotal	A Double Control class which computes the running total of its value expression. This can also be used as a running count by setting the value expression to 1. See the comment in the class for details.The example report RunningTotal demonstrates the use of this class.
MLStartDateTime	A Date/Time Control class whose value is set just once for all instances of the class when the first instance of the class is initialised. Useful to allow an identical date/time to be displayed on every page of a report. See the comment in the class for details.

MLDebugLog.bas

MLDebugLog()

Write a message to a log file.

How to use them

It is recommended that you install these files in the default location (C:\Actuate).

To use this free software, simply include the Actuate Library or Actuate Basic file(s) you require in your project. In addition to the documentation provided on this Web site, all the files contain comments explaining what they do and how they work. The Actuate Libraries have comments in the Class tab of the property sheet for each class. The Actuate Basic files simply have comments in the code.

Many of these files are used in the example reports which are available for download on this site.

Source: http://www.bi4progress.nl

With special thanks to Mr. Peter Headland ...