All reports from EULANDA® can be managed centrally via the report management. You can access report management from the Quick Launch toolbar under "System Administration" and then under "Report Designer".
Each program item that has a print menu is listed as a folder symbol in the report management. The reports for these menu items are displayed within the folder. This corresponds to the display of files in the file explorer.
Each folder first contains the report templates of the delivery status. These read-only reports start in the name with "cnsoft". All report templates created by the user or copied from templates start automatically with"user" in the name and can be changed at any time.
Besides the report templates starting with "cnsoft" or "user", there may also be vendor report templates. These are templates from other manufacturers. These are, like those of "cnsoft", read-only.
Report Designer (Editor)
Click on the "Report Designer" button to open the editor to design the report templates graphically. The Designer allows you to insert new fields, store a letterhead and has wizards for creating your own report templates and labels.
Properties of Elements
The properties can be called up via the right mouse menu of the elements. Since many of the elements, such as texts, long texts, images, and so on, have identical properties, these properties are described centrally here. Deviating behaviour with different elements is pointed out accordingly.
Traverse all data
This option is only relevant for"Fixed" printing behavior. If not all data fits within the specified range, they are usually swallowed because only one page is printed. However, with this option, the sub-report is always printed at the same position on subsequent pages until all data has been processed.
The selection of formatting suggestions in the"Display Format" dialog depends on the current field type for which this dialog was opened.
Display format for number fields
For amounts or quantities,"#,0.00;-#,0.00" provides a display in the form 1.000.000,76 (without currency),"$#,0.00;-$#,0.00" for display in the form 1.000.000,76 EUR, leaving the display format completely blank would result in display in the form 1000000,76 (blank number, no currency).
Display format for date fields
For data, the abbreviations for month, day and year are international, i.e. m=month, d=day, y=year. The separators "/" are exchanged with the characters stored in the Windows control panel during printing. In Germany, therefore, by the point".".
Print on first page
With the right mouse button, the"Print on first page" property can be selected for"Foot" and"Header". The corresponding element is then printed on the first page (if checked) or not printed.
Print on last page
With the right mouse button, the"Print on last page" property can be selected for"Foot" and"Header". The corresponding element is then printed on the last page (if checked) or not printed.
Automatic size adjustment
The length of a field usually depends on the number of characters to be displayed or the size of a graphic. If the"automatic size adjustment" is selected, the dimension of the field changes automatically by the space required to display the complete element. Of course, the element must be smaller than the tape. This option should be used by default.
Automatic word wrap
Use the right mouse button to activate the"automatic line break" option. Regardless of the formatting of the field text, the text is wrapped and distributed over several lines.
Automatic font size
If a barcode is printed in plain text, the size of the plain text can be automatically adjusted to the size of the barcode using the"automatic font size" option.
The text content is assigned to a "Richtext" element via the right mouse menu under "Edit". In the displayed text dialog, text can be entered and freely changed in the font, similar to a text program. In the "Edit" menu you will find a font dialog.
After closing the dialog you are asked whether the changes should be accepted. When you transfer the texts, they are copied to the layout as entered.
Re-print in the following area
If the option "Suppress repeated values" was selected and the tape is continued on a subsequent page, you can set here whether the calculation field on the subsequent page is to be printed despite the set suppression.
Re-print on overflow
If a dynamic tape, for example a tape with a long text, is split several pages, you can use this option to determine whether other elements of the same tape are to be printed again during a page break. This option would be useful, for example, if the lines of a report were vertical. On the other hand, you will not want to print images for a product repeatedly on the following page.
This allows you to determine the calculation order of the fields within a band. This is always necessary if several calculated fields exist in a band and these fields are interdependent.
This usually applies to the fields of the"Variable" type. These calculated fields can contain formulas of any complexity via Pascal script.
Usually this will only occur in bands such as the foot, group footer and summary.
Width of trunk component
Here the element can be aligned to the current width of the root component. The main component is the strip on which the form element is positioned.
Images that are larger than the intended display area can be enlarged or reduced using the"Stretch" property. In this context, the"Maintain aspect ratio" property should also be set.
For memos (long text fields)
A memo can contain almost any number of long texts. Since the actual amount of text is not determined until the time of printing, it is not possible to determine the height expansion at the design stage. The property "Stretch" allows the element to expand downwards so that the complete text can be printed - the memo can also extend to several pages.
Normally EULANDA® graphics are printed by an optimized process. Unfortunately not all printer drivers work correctly in all functions. For faulty printer drivers or printer drivers that do not support all functions, the"Draw directly" property should be selected for images. If this property is activated, however, much more memory is required for printing.
This can be used to set whether a line is to be replaced by a double line.
Print Settings Main Report
Copies the print settings for the subreport from the superordinate report (only relevant for"Section" printing behavior).
Elements such as fonts, barcodes, etc. are usually displayed with a background color - usually white. If there is an image behind the object, nothing of the image shines through because it is covered either by the black letters or the white background. The"Transparent" option can be used to set whether the background color of the element should be transparent. An underlying graphic is thus visible and is only covered by the black font. Instead of black, a different font color can of course be used.
With the right mouse button the property "dynamic height" can be set for any band. Note that you press the right mouse button over a free area of the tape.
The"dynamic height" property is possible for all belts. If a band is given this property, the height of the band automatically adjusts. If elements are placed on such a tape which can also expand, e.g. images, long texts, etc., the tape expands to the required height. In this way, all elements positioned on this tape fit into the printable area.
The area below the last element on a tape is not printed with dynamic property, regardless of whether space was left there in draft mode.
Tapes that are not dynamic are automatically static, which is the default property for tapes.
Dynamic tapes are usually used for detail tapes that have text elements of variable length (=stretch property).
The standard of a line is the simple line. This can be used to change a line from "Double" to "Single".
This is an option for subreports. You can use it to specify an element on which you can click to expand a subreport. You can see all processes when you "expand" the customer. Extension can be anything, image, label etc.
Expanding extension elements
If the"Extension element" option has been selected, you can use this option to specify that the subreport is expanded by default.
Child" (=Child), "Fixed and "Section" influence the printing behavior of the subreport. With the"Fixed" setting, the size of the subreport element is used as the page size of the subreport. The subreport then generates exactly one page of this size (Caution: if the subreport becomes larger than this page, elements will be missing!)
This setting is often used when a fixed size subreport, such as a table at a certain position in the report, is to be printed.
Leave free at zero value
If the value of the field contents is"0", this value can be suppressed. In this case, nothing is printed for this field. In this way, for example, it is possible to output text items without prices and quantities by assigning this property to the fields concerned.
Height of the master component
This property always adjusts the selected element so that it fills the height of the tape on which it is positioned. Since tapes can have dynamic elements such as "memos", this feature allows the element with the tape size to "migrate" without knowledge of the later tape height.
"Child" (=Child), "Fixed" and "Section" influence the printing behavior of the subreport. "Child" is probably the most common option. The sub-report starts at the first possible position and extends as far as necessary to print all its content, possibly over several pages. Therefore, the height of the tape in which the subreport is located must be dynamic in this case, otherwise an endless loop may occur. The page length of the subreport is exactly that of the parent report, the page width is the width of the subreport; to obtain the width of the parent report, you can select the"Width of parent component" option.
Print plain text
The barcode can be supplemented by printing a plain text.
If the statistics are only to be viewed on the screen, the headings can be repeated on all pages ("Repeating labeling")
otherwise, this is standard, this does not happen.
Stretching with the predecessor
Unlike"move relative to","stretch with predecessor" is almost always available. The element remembers the relative position on the background (band), and when the band is dynamically enlarged, the starting point, i.e. the upper left corner of the element, moves with it.
Move with the predecessor
If a dynamic volume containing a long text (memo) is split several pages and another element, such as an image, is to be printed after the long text, this must also be moved depending on the length of the long text. With this option this behaviour can be set. In this case, the predecessor is the tape on which the elements are positioned.
Move to the rear
Each element can overlay a different element. The order is usually determined by the order in which the elements are created. However, you can move an object lying on top down by clicking on the object lying above and using the right mouse menu to send the element down with this function. It is then overprinted by the objects above it.
For example, if you positioned a text first and then an image above it, the image would completely cover the text. When this image is moved to the back, the text is visible. Texts have the property "Transparent", so that in this case only the black font would be visible above the image.
Conversely, any object can also be moved forward.
Each element can overlay a different element. The order is usually determined by the order in which the elements are created. However, you can click on an object at the bottom and use the right mouse menu to bring up the element using this function. Elements underneath are overprinted by elements above.
Conversely, any object can also be moved forward.
This property is only possible for certain tapes. This property means that the tape in question always starts on a new page. This property is possible for the tapes "Title" and "Summary".
This setting can be useful, for example, if several invoices are to be printed with a report template and the title is to be the cover sheet for all invoices.
New print job
Starts a new print job for the sub-report in the"Section" print behavior, so that it is possible to print the sub-report not only with other options, but even on a different paper or printer.
If the printouts go over several pages, you can determine the sequence of the printout,
so that the report can first output all adjacent pages and then process the pages below them (first transversely, then downwards), and
it is also possible to first output all pages below each other (first downwards, then transversely).
Each element can be determined exactly in its dimension and position via the "Position" dialog box. This facilitates the exact alignment of elements on different form areas (tapes) and of course across different forms. In addition to elements, a band can also be set precisely using the "Position" property. Internally, the report designer works with an accuracy of 1/1000 mm.
With the right mouse button you reach the option "Page settings" in the volume "Page style".
Here you can decide behind which pages the layout should be printed, only after the first / last page, after certain pages or after all pages.
Reset page number
Allows you to number the pages of the sub-report independently of the main report (starting from 1).
Maintain aspect ratio
When resizing or enlarging images, width and height can be set separately. The image may then be distorted. When this option is checked, images are proportionally enlarged or reduced.
Child" (=Child), "Fixed" and "Section" influence the printing behavior of the subreport. With the Section option, the subreport uses its own print settings and gets its page size from them. When using this option, the options "New print job" and "Print settings main report" are therefore also available.
With this option, the subreport is a separate section, that is, it starts with a new page and forces a page break after its last page.
For"Section" type subreports, you can set different print options for the main report and subreport ("File" menu -->"Page setup"), even specify different printers so that the main report is printed on a different printer than the subreport. To do this, however, you must activate the "New print job" option and deactivate the "Print settings main report" option.
If the "Mail merge" property is activated, field names in the text of the "Richtext" element are replaced by the current database field contents. Field names must be enclosed in angle brackets. A valid field name for "Addresses" would be"", for example. Use the "Edit" function to select all valid fields from a list under the "Insert" menu item.
This can be used to determine whether an element is printed or not.
Useful examples of this option:
- You have scanned in a form, such as a bank transfer form. You position this on the tape to position the print fields more easily. In this case, the scan should only be visible in draft mode, not in the printout. Accordingly, you will deselect the"visible" property of the image element.
- You want to use different print options in a report template and deactivate unnecessary elements.
- You want to make complete tapes invisible in order to change the print image.
- You want to switch elements event-controlled visible or invisible. This control can be done by "Pascal-Script". This allows you to suppress fields depending on other field values or conditions, making them invisible. The"visible" property is activated as"visible" in"Pascal Script".
With the right mouse button the property "static height" can be set for any band. Note that you press the right mouse button over a free area of the tape.
The "static height" property is possible for all belts. If a tape is given this property, the tape is printed exactly at the specified height, regardless of whether elements placed on it have space or not.
Belts that are not static are automatically dynamic. The static property is the default property for tapes.
Shifting in relation to...
The function "Move in relation to..." refers to an element that can be specified in the dialog, i.e.
if an element is shown or hidden dynamically, the following elements can be automatically moved upwards on fading in and downwards on fading out.
Here you can set that a memo should automatically move with the length of another memo. However, an area object is also a valid reference object. In contrast to the property "move with the predecessor", this function can therefore refer to a preceding element.
Suppress repeated values
If a field with identical contents is output, you can specify here whether identical field values are to be suppressed.
If there is a check mark here, the cross table is drawn, otherwise not. Corresponds exactly to the"Visible" option.
A long text is filled with text using the "Lines" property. In addition to free text input, the dialog also allows the loading and saving of an ASCII text.
Texts within a long text are not simply truncated at the end of the visible element, but are distributed over several lines. Only contiguous words are broken.
If the loaded graphic is smaller than the default area of the display element, you can determine here whether the graphic is to be output centered. If this property is not activated, the graphic is placed in the upper left corner of the display field.
In this case, the area is not wrapped, always stays together.
Attention It is possible that with this setting not everything will fit on one DIN A4 page.