Previous topic Next topic JavaScript is required for the print function Mail us feedback on this topic! Mail us feedback on this topic!  


Report Builder can do a lot more than simply print columns of data. While that would certainly meet the needs of a lot of users, there are times when more complexity is necessary to accomplish your task. Here is a short list of features you can use:


Accessing/Saving Report(s)


Tree-styled Report Manager screen will help you arrange your reports by means of classifying and grouping them by type and using several folders to store report files (ComQuest has defined a variety of reports, such as those for Respondent data, and those that compile song scores, etc).


You can create and manage an unlimited number of reports.


Quickly create reports that are similar to an existing report by opening a file, then saving the report to a new file name.


You can use Windows-styled long filenames when saving reports.


Data Creation/Manipulation


Simultaneous processing of several data tables joined in an integrated structure


Effective and high speed filters for records using any available fields from ComQuest's database file(s), including expressions and functions of the Report Builder's native programming language


Sort data using any available fields, including expressions and functions of the Report Builder's native programming language


You can easily build complex expressions with the help of the built-in Data Dictionary. The Dictionary contains all the field names, functions, operators, built-in variables and user defined total variables/calculated fields which are allowed for use in an expression. The Dictionary also shares a tree-style hierarchical structure.


Supports end-user creation of  total variables of type Sum, Counter, Average, Minimum, Maximum, Evaluate. Total variables can be reset on the end of appropriate sorting group as well as on the end of each page. These variables can be set up to be evaluated at the start of report, at the each record, at the end of a sorted group, at the end of page, at the end of report.


Supports end-user creation of  "Calculated fields". These are very similar to "Total variables" but always use the Evaluate type and are never reset. You can accomplish very complicated computations using any number of Total variables and Calculated fields.


"Calculated variables" can be set up to evaluate at the start of the report as well. By means of dialog window functions provided for by ComQuest, it is possible to ask for run-time entered values or browse selection. The value being entered/selected will be accepted to the "Calculated Variable". Such variables usually are used in defining filter expressions, such as date or demo ranges.


Using the report Dictionary you can select an individual element from array type data fields (up to 4 dimensions).


Print the current date and time on a page. The Picture can change the format of a date or time field to any desired format. For example, you can change 02/21/00 to read "21 February, 2000" at report runtime.


Wizard style dialog easily helps you build a Picture of any type (Numeric, Date, Time, Pattern, etc.).


Frame contents may be formatted in accordance with a Picture. The Picture can help you to change the format of text strings easily. For example, if the social security number is stored in the database as only numbers (123456789) you can reformat it at runtime to print "properly" (123-45-6789).


ComQuest can create computed fields indistinguishable from the fields in the actual database table, and in fact has done this for you in the case of counting how many respondents scored each song with a "1", or a "2", etc.


User Interface


The Report Formatter uses a word processing-styled interface, with buttons commonly found for formatting text (right align, left align, center align, etc.).


Supporting report sections (bands): Page header, Report header, Group break, Group header, Detail, Group footer, Report footer, and Page footer. Each band can contain an unlimited number of Frames to represent information.


Frame contents may be a text string(s), or a formula. This is similar to Microsoft Excel usage: if the frame contents begins with the equal sign "=" then it means the rest is the formula to evaluate. In that way you can reference not only one variable but also an expression containing as many variables and functions as you want.


Use borders around the Frames to make them standout. For example, you can place a border around mean averages at the bottom of reports. You can also use all the Frames with borders and join Frames side-by-side to get grid-style report. Frame borders may have varying thickness and color. Also the whole frame can be filled by a selected color.


You may select a font typeface, size, style and color for the whole report or report section as well as for  an individual frame. Use different fonts and font types to make key data stand apart from other data.


You can select multiple Frames at the same time for repositioning or alignment operations. (CTRL + LeftMouse click to select multiple frames).


Frame contents are placed and aligned both vertically and horizontally.


Print the current page number as well as the total number of pages on each page header/footer.


Print the number of database records printed on the current page (useful for page footer information).


ComQuest can change the language from "English", "Russian" or any other interface language. The FRB_NLS.INI file is provided for translation of all the messages and prompts that the Report Builder uses to interact with end-users.


ComQuest can make available additional functions to be used in report runtime evaluated expressions. (Just ask us!)


Ability to export report pages in WMF format to Microsoft Word for Print Preview, Edit, Save as *.doc format file, Printing purposes, etc.


Add graphics to a report that are stored on your computer. This is a GREAT feature commonly used for office letterhead, computer-generated invoices, etc.


Support for Inch as well as for Metric coordinate system.


Ability to customize default properties of a new Frame.


It is possible to set the percent values both for Horizontal and/or Vertical scaling of a whole report page being generated. Default percent value = 100%, effective increment/decrement step = 5%. X and Y percent values are stored in the user's WIN.INI file for each installed printer separately. This unique Report Builder capability allows end users to adjust the actual size of report controls/whole report page on a hard copy for an any specific printer, such as Laser, Matrix and so on.


The "Trailing Text" feature is helpful for a MEMO field printing. The "Trailing text" option is selectable as a property of a report section (band). Text will be printed line-by-line beneath the band with page overflow control. This feature can handle a text of unlimited length.