Documentation Reports

Below is a list and brief descriptions of the documentation reports in Report Analyzer.

View the sample output in PDF format.

 

Report Title Description of what it does
Specifications
 

01 Database Dictionary

View Sample Output

Lists only database tables and fields that are used in each Crystal Report with property values including data types and sizes.  

02 Report Specification

View Sample Output  

Provides full report specification - database tables, fields, formulas, parameters, crosstabs, running totals  

03 Report Specification Summary

View Sample Output

Provides summary specifications for each report  
Metrics
 

04 Object Inventory

View Sample Output

Lists Type and number of Objects used in report  

05 Report Complexity

View Sample Output  

Measures report complexity at the formula level to assist in planning for maintenance and test case development  

06 Report Complexity Summary

View Sample Output  

Measures report complexity at the report level to assist in planning for maintenance and test case development  
Reports
 

07 Report Listing

View Sample Output  

Lists reports within the workbench  

08 Report SQL String

View Sample Output  

Lists the SQL query code for a report where the property is available  

09 Report Properties

View Sample Output  

Provides report properties and settings  

10 Report SQL Expression Fields

View Sample Output  

Lists SQL Expression fields and code  

11 Text Object by Section

View Sample Output  

Shows text objects with embedded fields and text  
Formulas
 

12 Formula Listing

View Sample Output

Lists all report formulas, including Record Selection and Group Selection formulas  

13 Formula Call Tree

View Sample Output  

Lists all formulas by report and the objects that the formula calls  

14 Conditional Formulas

View Sample Output  

Lists all conditional formulas including code and where they are used.  

15 Formula Variable with

properties  

View Sample Output

Displays variables if used in formulas with an option to view the actual code.  

16 Variable Inventory  

View Sample Output

Profiles all of the variables used in each report formula by formula or by variable. Assists in tracking down global and shared variable usage by formula name.  
Tables and Fields
 

17 Report Fields  

View Sample Output

Lists tables and fields used by report. Includes field properties  

18 Reports Referenced by Table  

View Sample Output

Lists all database tables grouped by Database and the reports which use them.  

19 Table Authorisations

View Sample Output

Lists all the tables used in the report and shows properties  
Report Features
 

20 Report Subreports

View Sample Output  

Lists subreports within the report  

21 Cross Tabs - Details

View Sample Report  

Lists cross tabs in the report and shows the rows, columns and summarised fields with properties  

22 Parameter Cross Ref

View Sample Output  

Cross references parameters across reports  

23 Parameter Listing with Properties

View Sample Output  

Lists parameters in each report. Parameter default values and properties are displayed if parameter prompt is yes.  

24 Report Running Totals  

View Sample Output

Lists the running totals in reports with the value type and field used to created the total  

25 Report Graphs  

View Sample Output

Lists Graph Objects in the report  
Object Cross Reference
 

26 XRef Object by Object  

View Sample Output

Lists all objects by type and the parent object it is referenced in  

27 Xref Objects by Table  

View Sample Output

Lists tables and then all objects by report that reference the table  

28 Xref Objects by Formula

View Sample Output  

Lists formulas and then all objects by report that reference the formula  

29 Xref Object by Field  

View Sample Output

Lists fields and then all objects by report that reference the field  

30 Xref Object by Summary field  

View Sample Output

Lists summary fields in the report and cross reference  
Suggestions
 

31 Suggestions by Report

View Sample Output

Lists suggestions by report object based on Design and Performance  

32 Suggestion Details  

View Sample Output

Lists reports to which the suggestions apply