The Report and Report (auto format) types are used to generate standard column and row reports. You specify which columns from the query’s result set are to be displayed, in what order and on how many rows and how each column is to be formatted.
Report (auto format)
All the columns from the result set are displayed using “General” formatting options with column headings labeled with the field names returned from the SQL Query. This layout type can be useful for simple reports or for reports where the columns of the result set are not predetermine (e.g. a result set generated by a cross tab).
If the Report (auto format) type is chosen there are no settings for the report layout.
Report
A simple example of a "Report" type custom report with all columns presented in a single row is:
NOTE: The report shown above and using the layout details shown below called 'Example - Top Ten Oldest', can be downloaded as part of the Example Reports package.
The layout settings for a Report Layout/Organization Type are:
In the above example report, note the the first column is pale blue indicating it is a link to the issue (like on the main issue list). When a field is defined as a hyperlink and it appears in the first column of the report, RMTrack will use this pale blue column link display. Click here for more information about hyperlinks in reports.
Each row of the Layout Details represents a column in the report. Any number of columns can be added to a report.
To add a new column, fill in the required settings and click the Add Field button. Once a field has been added you can modify the settings by clicking the Edit link beside the field settings, making changes and the clicking Update.
The order of fields can be adjusted by using the up and down arrows at the far right of the field row.
Setting
Meaning
Row
The row the column will appear on. The first row is formatted with column labels above the column, subsequent rows are formatted with side labels on the left
If the Field Type is Field then this is the name of the field in the SQL result set. If the Field Type is Subreport then this is the name of the subreport
Caption
The column label for the field. Or the title for a subreport.
Alignment
How the field is aligned: Left, Right or Center
Named Format
The format to use for the field. Values are supported:
User Defined
Medium Date
True/False
Fixed
General
Long Date
Yes/No
Standard
General Date
Short Time
On/Off
Percent
Short Date
Medium Time
General Number
Scientific
Short Datetime
Long Time
Currency
User Defined Format
If the named format is User Defined then the field’s format is based on the supplied custom format. Custom formats are produced using VBA Script standard functions (i.e. the same Format() function used by MS Word and MS Excel).
at the far right of the field row.