SuperReport Editor Window
The "SuperReport Editor" window allows you to create, modify and print report documents.
The following pages explain using the "SuperReport" in a general way for any 4th Dimension Databases. Some of the features described are of an advanced nature. Utilizing some features depends on how the 4th Dimension program was written. Utilizing other features requires knowledge of, and the reference manuals for, the 4th Dimension language, published by ACI US.
Access the "SuperReport Editor" in one of the following ways:
File menu > Print SuperReport
Under Admin Dept > Records menu > create a new "UserReport" and choose "GTsR" as the print application. Use the "Printing Application" button within the "UserReport" record, to open the "SuperReport Editor".
Tools in SuperReport
Play Movie: r1_Tools.MOV
Play Movie: r2_Super.MOV
Play Movie: r3_Detai.MOV
Play Movie: r4_All_S.MOV
Page Breaks, using the Statement as an example
Play Movie: r5_Page_.MOV
UserReports, adding SuperReports to Defined Reports
Play Movie: r6_UserR.MOV
Reports based on Line Count, Proposals, Orders, Invoices and PO's
Play Movie: r7_Line_.MOV
EDI Options in the program
Play Movie: r8_EDI_P.MOV
Depending on the features selected in the "UserReport" you may be able to access the "SuperReport Editor" by choosing a particular "UserReport" from : File menu > Print Defined Reports.
NOTE: If you are printing a form with Line Items (Proposal, Order, Invoice or PO) you must make the "SuperReport" into a "UserReport" so you can define the number or Line Items to print per form. To print the form choose: File menu > Print Defined Reports.
When the "SuperReport Editor" window is displayed, "SuperReport" replaces CommerceExpert/WebClerk menu bar with its own, giving you access to "SuperReport’s" functions.
Options selected in the "UserReports" determine which functions are active.
The functions needed to use the "SuperReport" are available as menu commands or within the "SuperReport Editor" window. The "Report Editor" allows the selection of the paper type for the report, using Page Setup, placing objects (Fields, Variables, Lines and other graphic objects) on the report, defining the different sections of the report (Header, Body, Total and Footer etc) specifying the number of "Break" levels (for subtotalling) and what procedures and scripts are to be executed as the report is generated.
Using the Report Editor
The "Report Editor" area is used to create or modify the report using this area you define the sections of the report along with the objects that the report will contain.
The "Toolbar" area contains the following Tools (reading from left to right):
Selection tool (arrow)
Text tool ("A")
(Straight) Line tool
The "Arrow" (Selection) tool is used to select objects, to drag objects around, and to resize objects, while the other "Tool" icons are used to create new objects.
Creating a New Object
After clicking on one of these New Object tools, move the mouse on to the report (in the "Editor" area beneath the Toolbar), and drag a new rectangle. The appropriate object will be drawn according to the Tool you selected within that new rectangle.
Selecting an object is achieved by first selecting the "Arrow" tool, and then by clicking on the appropriate object within the report. The diagram above shows two objects - the one to the right is selected as shown by the “handles" (black rectangles) at corners of the object, while the object to the left is not selected.
To de-select an already selected object, click on it while holding down the "Shift" key. Clicking on the object again with the "Shift" key selects the object. If you click on part of the report that contains no objects, any selected objects will become de-selected.
If you wish to select a group of objects quickly, then you can click on the report page (but not on an object) and drag a “Marquee" over the objects to be selected - any objects that are touched by or are within the Marque become selected. Any previously selected objects become de-selected unless you are holding down the "Shift" key in which case, the newly selected objects are added to those previously selected.
If you click within an object that is already selected, then "SuperReport" assumes that you wish to move the object, and allows you to drag it around. If more than one object is selected, then all the selected objects are moved.
"SuperReport" also allows "nudging" objects using the "Arrow" keys. If you have selected one or more objects, and you press either of the four "Arrow" keys, the selected objects will be moved by one pixel in the direction of the"Arrow" key. For example, if you press the "Up Arrow" key, the selected objects will be moved up by one pixel. Holding down the "Option" key while pressing any of the "Arrow" keys will cause the selected objects to be nudged by ten pixels instead of one pixel.
If you click within the object’s “handles" then "SuperReport" will assume that you wish to resize the object, and will allow you to drag the corner around, until you release the mouse button. When creating a new object on the "SuperReport" or resizing an existing object, holding down the "Shift" key has the effect of making the height and width of the object the same (as the object is dragged). This feature is useful for creating squares (as opposed to rectangles) and circles (as opposed to ovals).
Objects can also be resized using the "Arrow" keys. If you hold down the "Command" key while pressing any on the "Arrow" keys, any selected objects will be resized. Pressing the "Option" key as well will cause the object to be resized by ten pixels as opposed to one pixel. When the "Up Arrow" or "Down Arrow" keys are pressed, the lower boundary of the selected objects will be resized in a vertical direction, and when the "Left Arrow" or "Right Arrow" keys are pressed, the right hand boundary of the selected objects will be resized in a horizontal direction.
To align two or more selected objects on the report, click in the "Alignment" icon within the Toolbar, and hold the mouse button down. An Alignment Palette will appear allowing you to specify how you want the selected objects aligned. While keeping the mouse button pressed down, you may drag the mouse within the Palette to select the alignment that you want, then release the mouse. If you drag the mouse outside of the Palette and release the mouse, no alignment will take place.
Reading from top left to bottom left in a clockwise direction the six alignment options are:
Align Vertical Center
Align Horizontal Center
Note: The alignment of objects is different from the alignment of Text within an object.
Changing the Line Thickness of Objects
"SuperReport" allows you to specify the line thickness of lines, rectangles and ovals using the" Line Thickness Selection" area. To change the lines thickness of one or more objects, select the object or objects, and click on the required line thickness in the "Line Thickness Selection" area. Lines may be 1, 2, 3 or 4 points in thickness.
Setting an Object’s Text Attributes
"SuperReport" allows you to control the Text Attributes of objects, Fields and Variables that contain text. You may determine the Font, the Size, the Style and the justification of Text within the object. An object’s Text Attributes are set “globally" for the object you may not make particular words within the object have different Text Attributes. To change the Text Attributes for one or more objects, first select the object or objects, and then use the appropriate Text Options shown in the Toolbar (above).
To change the Font of an object, click on the Popup arrow marker to the left of the Font name (shown as “Geneva" above). A Popup menu will appear listing all the fonts available within your system. The object’s Font will be changed to whichever new Font you select.
To change the Font size of an object, click on the Popup arrow marker to the left of the Font size (shown as “12 Pt" above). A Popup menu will appear listing all the Fonts Sizes available within your system. If you select the Other… item from the Popup menu, then a dialog will appear allowing you to enter a Font Size between 1 and 144 points - fractional fonts are not supported. The object’s Font Size will be changed to whichever new Font you select.
To change the Font Style of an object, click within one the "Font Style" boxes. You are able to choose between Plain text, Bold text, Underlined text, Italic text, Outlined text and Shadowed text, or any of these Styles in any combination.
When changing the Font, Size or Style of an object, "SuperReport" will adjust the bottom of the object to accommodate a “whole" number of lines of Text for your chosen Font, Size and Style combination.
To change the Justification of Text within an object, click within one of the three Justification Options (the three icons at the top right of the Toolbar).
The three available Justifications are Left, Center and Right justified (reading from left to right).
Whenever you select one or more objects, "SuperReport" will “show" you the Font, Size, Style and Justification of the selected objects using the "Text" tools in the Toolbar. If you select two text objects, one of which is Geneva 9 pt and the other Helvetica 9 pt, then "SuperReport" will not show a Font name (since the fonts are different), but will show the Font Size as "9 Pt".
If you wish to change the the default Font, Size, Style and Justification for new Text objects, then make the Text Attribute changes when no objects are selected. Any new Text objects that are subsequently created will take the new default attributes.
Adding a Field
Select the "Field" icon from the Toolbar, and drag the field’s "Rectangle" within the report. Once you release the mouse button, a dialog will appear allowing you to select the field, to select the Print Formatting (for "Number", "Date", "Time", "Boolean" and "Picture" fields), and to set the object’s Positioning Options (using the check boxes).
To select the Field, choose a Field from the File/Field Popup menu that is displayed when you click on the Popup menu icon to the right of the word "Field". Having selected the Field Name, the Field’s Type will automatically be displayed.
For "Number", "Date", "Time"," Boolean" and "Picture" fields, you may select one of the predefined formats from a Popup menu that will appear when you click on the Popup menu icon to the right of the word "Format". You may enter your own format string directly in the "Format Text" area instead of using one of the predefined formats, if you wish.
Adding a Variable
Select the "Variable" icon from the Toolbar, and drag the Variables Rectangle within the report. Once you release the mouse button, a dialog will appear allowing you to select the Variable, to specify the Variable Type, to select the print formatting (for number, date, time, boolean and picture fields), and to set the object’s positioning options (using the check boxes).
To select the variable, choose a variable from the Variable Names popup menu that is displayed when you click on the Popup menu icon to the right of the word "Variable". Having selected the variable name, the variables type will automatically be displayed. If the Variable Names Popup menu is not active, or you wish to use a Variable not listed in the menu, you may enter the Variable Name directly into the "Variable Text" area.
You may specify the type of the Variable using the Type Popup menu, and whether the Variable is a "Normal" Variable or an "Array" Variable using the "radio" buttons.
For "Number", "Date", "Time"," Boolean" and "Picture" Variables, you may select one of the predefined formats from a Popup menu that will appear when you click on the Popup menu icon to the right of the word "Format". You may enter your own format string directly in the "Format Text" area instead of using one of the predefined formats, if you wish.
Object Formatting Strings
The object formatting strings are the values that are entered into the "Format Text" area, these are used at print time to format the object’s Text according to the object’s data type.
Format String Displayed As