Matrix reports

Top  Previous  Next

 

Matrix reports

Reports representing cross reference and usage of objects within application. A matrix style of presentation offers quick overview of which objects are used where and how, depending on their type.

Excel format allows modifying and printing the reports.

 

Matrix reports can be used for easier identification of parts of application, such as reports section, what is used in the section and how it is used.

 

Matrix reports can be created on:

Models, Tables, Programs, Global events, Global virtuals, Global functions, Types of I/O Files, Types of Forms, Task types, Task properties.

 

Main screen

matrix

 

Options:

Excel version

Type of Excel format; versions befroe 2007 has limits of Columns = 255 and Rows = 65,536;

Excel 2007 has limits of Columns = 16348 and Rows = 1,048,576

 

If Excel 95..2003 is chosen, if there is more than the limit number of objects, Excel file will have more Sheets to fit all of the data

No. of heading columns

Set no. of columns as header - each Excel sheet will be limited to the set no. of columns

Hits text color

Set the color of the hit in report

Hits background color

Set the background color of the hit in report

Destination folder

Set the destination folder of Matrix report

 

Generate button will generate each individual Matrix report. If button Generate all selected reports is pressed, then all reports which have checkbox checked will be created in destination folder.

 

Models

matrix_models

Legend - Models are used as/in

X        Used in

V        Model in Virtuals

I        Model on Form control

 

 

Tables

matrix_tables

 

Legend - Tables are used as/in

R        Read Access

W        Write Access

S        Source table

DD        DbDel functions

DC        DbCopy functions

DR        DbRecs functions

 

 

 

Programs

matrix_programs

 

 

Global objects

matrix_globals

All In One will create one matrix report with data about Global events, Global virtuals, Global functions, Types of I/O Files, Types of Forms, Task types and Task properties in one Excel file.

 

 

Sample of Matrix report:

matrix_sample

 

 

 

 

 

 

 


Copyright © 2011 Ocean Solutions http://www.magic-optimizer.com