The actual layout is created on the "Draft" tab. A wide variety of objects can be selected and positioned here. The tools can be used to make settings such as alignment, color, font, formatting, etc. In addition to the basic properties, each object (=element) has many other properties that can be set in the right mouse menu for the object.
The fields are essentially positioned in the layout, the stationery is stored and graphics are integrated.
Draft file card
In the"File" menu, you will find the"Page Setup" item, which you can use to open the page setup dialog.
Using the"Printer" selection box, a report template can be permanently connected to a specific printer. Only the fonts that the selected printer has installed are then available in the layout. This option is now only important for special printers or dot-matrix printers. By default, this should be"Default". In this case, all scalable system fonts are available. The printer can then be freely selected in the EULANDA® print box.
If a special printer was selected, the fonts are only available after saving the report template and restarting EULANDA®. If special printer fonts were selected in the report template and another printer is used in the EULANDA® print box, the result is not defined. If you have specified a fixed printer in the page settings, the form should always be output on this device.
Each printout is queued under Windows. The application can give the print job a name that you can set individually for each report. At this point, you can give the report template a name for the queue.
Leave the number at "1" and use the EULANDA® print box instead to control the number.
Duplex (paper turner)
If your printer has a paper turner and you want a double-sided printout, you can enter here whether the sheet should be turned at the long or short edge (horizontal, vertical).
The selection of paper sizes depends on the printer used. If no special printer has been selected on the"Printer" tab, the options of the default printer are available.
You can also freely enter the width and height of the paper, but not every combination of width and height is supported by every printer driver. The support of any sheet dimensions and formats is called "custom format". Some printer drivers do not support custom format and switch to one of the predefined standard sizes (A3, A4, A5, etc.).
For shaft control, you should use the setting in the EULANDA® print box. The setting in the report template itself is only intended for cases in which no print box is available.
The setting of the columns is especially intended for multi-column labels. The overview shows the start of the label in millimeters. This specification also depends on the edge setting.
For labels, you can use the "Run through from" function to determine whether labels are to be printed from right to left or from top to bottom.
The margin setting is self-explanatory. With label sheets, the non-printable edges can be very easily adjusted using these specifications.
Bands are placeholders for objects that are positioned in these bands. During printing, the tapes are printed in a specific order. Tapes that are not required can be switched off via the report menu or invisible via "Properties".
The skilful use of the tapes allows all kinds of printouts to be created.
The most important volume is the detail volume; it is printed once for each data record. The title volume is printed only on the first page, the summary only on the last page, the page style is placed under the actual printout like a slide and printed with the page information, the header and footer volume is printed on each page.
Texts, fields, graphics and other elements are positioned on these tapes and provided with properties such as size, font, markup, alignment, etc.
Showing and hiding tapes
In the report menu, you can tick or uncheck the title, summary, header, footer and page style; you can also show additional bands under Groups (Ctrl+G). Group tapes can be used to form groups, for example to output subtotals. The various possibilities of these bands are described in the"Groups" section.
Properties of tapes
If you click with the right mouse button into a band, you reach the properties menu of the band.
Height of the belt
You can change the height of a band by clicking on the brown separation bar between two bands (the mouse pointer becomes a double arrow), keeping the mouse button pressed and then dragging the mouse up or down.
Dynamic and static belts
Normally, a ribbon is printed at the height specified in the design (static ribbon). However, there are situations in which elements with variable heights have been positioned on a conveyor belt. In such cases, the strip must have the"dynamic" property, since it aligns its height with the necessary extension of the elements lying on it. This would be the case, for example, if a memo (long text) was positioned on a tape. The memo can contain one line, but also hundreds of lines of text. The tape then also has a variable height; the"dynamic" property must be set.
A dynamic height can also be considered if elements are positioned on a tape that are switched invisible depending on conditions. If a tape uses the"dynamic" property, it is possible to determine whether an element is visible, i.e. whether a color portion is printed. With a dynamic height, only as many dots are printed as are set on the printer.
The bands in detail
- title tape
- Head band
- Group Header Band
- detail tape
- Group foot band
- Page Style Ribbon
Properties of the tapes
The following settings that can be called with the right mouse button are:
- Dynamic height
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.
The area below the last element on a tape is not printed with dynamic property, regardless of whether there is free space left in design 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 variable length (=stretch property) text elements.
- Static height
The "static height" property is possible for all belts. If a tape is given this property, this tape is printed exactly at the specified height, regardless of whether elements that are placed on it have space or not.
The static property is the default property for tapes.
- New page
This property is only possible for certain tapes. This property means that the tape in question always starts on a new page.
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.
- calculation sequence
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.
These calculated fields can contain formulas of any complexity via Pascal script,
usually only in bands such as the footer, group footer and summary.
- 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.
- 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. You will accordingly deselect the"visible" property of the picture 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".
Most elements can be assigned properties, the most important of which are font, content, color, etc. The commands for this are located in the toolbar. Additional properties for the respective element can be selected via the right mouse menu.
To position an element on a tape, it is selected in the toolbar by mouse click and then transferred to the desired position by clicking on the tape. The standard properties of the transferred elements can now be set via the right mouse menu and the toolbar.
Non-database elements (Pascal script)
A barcode with a defined value can be positioned and configured on a tape. The type of barcode (EAN, Code39, EAN128 etc.) can be set via the right mouse menu. Enter the digits or letters to be converted into barcode information in the toolbar.
The settings can be called up with the right mouse button.
Basic geometric shapes, such as rectangles, circles, etc., can be positioned on a band using shapes. The possible shapes can be selected in the toolbar via a selection box. To do this, the element must be positioned and active - that means it must have been clicked beforehand -
shapes can be provided with a frame and a fill color. The additional functions can be displayed in the toolbar via the"View/Toolbar/Draw" main menu. In addition to the colors, a line type can also be selected for the frame. Here you can choose between solid, dotted or dashed lines.
The graphic element can be used to position images in a wide variety of formats on a tape. Various formats are supported which can be selected in a list in the image dialog.
To insert an image into your layout, first click the image icon in the toolbar, then click where you want to insert the element.
Next, drag the frame of the image to the desired size. Then the image must be inserted; this element has the property "Image..... You reach the property with the right mouse button.
To be able to work with the image as usual after loading the image, it is important to activate the options "Stretch" and "Keep aspect ratio" with the right mouse button.
The loaded image is then displayed completely and proportionally. Without the"Keep aspect ratio" option, the image would be distorted, i.e. compressed or stretched.
Note about Pascal-Script
Via script an image can be loaded via the method Bild1.Picture.LoadFromFile('Filename') or saved with Bild1.Picture.SaveToFile('Filename'). This allows you, for example, to load and print out a personal graphic signature depending on the logged in user.
With the line element horizontal and vertical lines can be positioned on a tape. The position of the lines - left, right, top and bottom - is set via a selection box in the toolbar.
To get horizontal lines, you have to select the property "top" or "bottom", for vertical lines you have to select "right" or "left".
Similar to the single-line text element, a memo can contain multi-line text. The text content is entered via the right mouse menu and there via the "Lines" property.
The Richtext element works similar to a memo element and can also contain multi-line text. Here, however, it is possible to display font information, such as bold, italic, etc. The element is more complex than a memo and requires more processing power to generate the printout. It should only be used if a lot of text with different markups is needed. Richtext is in any case more effective than many different text elements with different awards. Richtext cannot be exported with the integrated export functions (PDF, BMP, HTML etc.). If you want to create PDF documents, you should do without rich text or use Acrobat in the full version to generate PDF.
Using the system variables, date, time, page number and other values can be set and inserted into a tape. The system variables can be selected in the toolbar. The possible values are self-explanatory.
Free text cannot be entered directly on a tape, but must be inserted into a tape using the text property of a text element. Once the desired text has been assigned to the element, this element can be positioned freely in the band, even together with other elements, and common properties such as colors, font, etc. can also be set.
Variables are calculating fields. These can contain formulas and refer to any other field contents. The calculations can be entered via the "Calculations" property. Besides simple calculations, the formulas can also be more complex and contain Pascal script.
Variables, for example, are a simple way of calculating the COD fee from the gross amount plus a surcharge on a cash on delivery card and printing it out accordingly.
Database-bound elements (Pascal script)
DBBarcode has similar properties as the element Barcode, but with a database connection. This means that barcodes can be converted directly from fields in the database. In principle, any number or text field can be output as a barcode, because in addition to the usual food barcodes EAN13 and EAN8, the alphanumeric barcodes EAN128 and C39 are also supported.
The DBCalc element allows you to perform various standard calculations, such as total, average, etc., for a database field with a number type. Date operations can also be performed. For example, output the smallest and largest date of a series. This option is used in substitute evaluation to automatically output the commission period.
The element DBImage is related to the element Image. However, DBImage has the ability to read and display images from a database. In this way, image price lists can be printed from the article master, for example.
The element has similar properties to "Memo", but with database connection, texts etc. can be taken over directly from the database.
The "DBRichtext" element can be used to output long texts with font markings, such as bold, italics, etc., similar to the "Richtext" element. "However,"DBRichtext" has a database connection and can thus print out fields of the database directly.
The element "DBText" works similar to the element "Text". It displays short texts, which are usually single-line. The complete element can be designed by its properties with a font, color, size. In contrast to the"Text" element,"DBText" has a database connection and can thus output any text and number information from the database.
255 characters is the maximum length, in contrast to"DBMemo", which can display two billion characters.
Advanced elements (Pascal script)
Subreports are full reports within a report. You have all elements and functions like a normal report (header, footer, summary, detail, etc.), have the same events and also access to all variables, constants, procedures and functions declared in the main report.
Subreports can be nested as deeply as desired. A tab is created at the bottom of the editor for the main report and each sub-report. To access the draft of the subreport, select this tab.
The above screen displays several subreports. This is a report template for an offer. The subreport is positioned in the main report via the element "Subreport", which is marked "1" in the picture. The subreport is only displayed as a simple framed box. It represents the placeholder for the complete output of the associated subreport(s). Next, a data source is assigned to the subreport. To do this, click on the subreport and assign a data source in the toolbar under "2". After the sub-report has been positioned, a tab appears at the bottom of the editor under"3". If you click on this, you have a new report, which can contain all the usual elements and other subreports.
In the above example, the main report consists of the header data of the bid and the subreport consists of the items.
To print the correct items for the header data, they must be connected to data sources.
With the help of regions, any elements can be grouped together in one area. You can hide regions with a statement or move the region. When moving, all elements positioned in the region are also moved.
In regions you can basically combine everything - shapes, free elements like text fields, database-bound elements, images.
Sub-regions, i.e. regions containing several regions, are not supported. It is also not possible to position a sub-report in a region. However, new regions may be included in sub-reports.
To use a region, simply select it in the toolbar and insert it in the band at the desired position. Since regions have the default fill color white and a black border, it makes sense to set the fill color to"no fill" and the border color to"no line".
If the symbol for the region is missing in the toolbar, it can be displayed via the"View/Toolbar" menu and the"Advanced elements" item.
If you position field elements in the region, they are automatically assigned to the region. You can always use the report tree to check whether a field is actually assigned to the region. You can display the report tree via the"View/Toolbar" menu.
The report tree displays the field elements assigned to the region indented, allowing you to check whether the fields are assigned to the region or the band.
A cross table allows you to output evaluations with different dimensions. Normal table statistics have two dimensions. For example, you can display a time axis (top) and a postal zone axis (left) and display the totaled sales as results.
However, if one does not only want to look at areas in relation to a period, but also have different periods such as year, quarter, month and beside the areas also customer groups and representatives in the evaluation, then one would have to print out conventionally very many individual statistics and compare the values in each case. From such lists it is difficult to get an overview and make the right decisions for a company.
Crosstabs help here. They represent any number of dimensions - year, quarter, month, area, customer group, etc. - in a single diagram. Each combination of dimensions is an intersection point; hence the name cross table. The intersection points contain the calculation. These can include not only sales and earnings, but also static calculations such as average, total, minimum value, etc. A crossing point can also display several values at the intersection.
In addition, all intermediate results are totaled and displayed at the right and bottom edge of the diagram.
To calculate these huge amounts of data rows, a program would have to load all fields from the database, which would place an enormous load on the network. For this reason EULANDA® shifts the calculation of these intersection points to the SQL server. This means that not all data records have to be transmitted to the executing program and the intersection points calculated there, but these are already calculated by the SQL server and only the results of the intersection points are transmitted to EULANDA®.
The duration of the calculation depends on the number of data records. If, for example, crosstabs are created using an article-related evaluation, all invoice items must be processed. If the period to be evaluated is long and a lot of data is available, the calculation can take several minutes for 100,000 data rows.
Cross tables are also called PIVOT tables in Microsoft® Excel. The mode of action is similar, whereby of course in EULANDA® there is no limit for the number of data to be processed and the calculation is optimized in the SQL server.
To support you in selecting the fields for a cross table, EULANDA® has pre-configured data sources that are stored as views in the SQL server. These always begin with "PIVOT" in the name of the data view.
Cross table with four dimensions
This cross table has four dimensions and a calculated value at the intersection, which is the sum of the Vk field. The calculated fields are displayed in the upper left corner. In this example, there are two nested dimensions. In the line bar on the left, the postal routing zone is the main dimension and nests the customer groups in it. In the column zone above, the year is the main dimension and the quarter is nested in it.
The cross table now calculates the fields to be calculated for all intersection values. The table can quickly grow larger than a sheet of paper. In the properties of the cross table you can therefore set whether all horizontal connection sheets are to be output first or all vertical connection sheets first.
Short description of the cross table
Crosstabs are normal elements such as subreports or regions. You will find them in the toolbar under "Advanced elements". The report template for a cross-table is based on a new report, that is, a completely empty template.
In report management, select the"New" function with the right mouse button at the point where you want to insert the statistics into the menu tree.
After opening the report, a data source is created first. To do this, select the "Data" tab and select "New" from the menu. The easiest way is to use the query wizard.
Select one of the PIVOT views from the list of possible data. For example the Pivot_InvoicePos and then select the "Finish" button.
On the "Draft" tab, position the cross table in the detail area. Click on the positioned element and select the new data source from the toolbar. The detail volume itself must not be assigned to a data source in the"Reports" menu, otherwise the cross table would be repeated for each data record. Then select the "Configure" property in the right mouse menu of the crosstable element.
The cross table is normally positioned in the detail band. It is displayed using a frame placeholder. First connect the data source - usually a pivot data source - to the element. The data source must have been created beforehand via the "Data" tab.
The detail tape must not be assigned to a data source. Otherwise, the cross table would be repeated for each record in the data source.
Using Drag&Drop, the fields on the left can now be dragged to the"New row" or"New column" box. The value to be calculated is drawn onto the "New value" area. You can also add several values here. The same applies to the rows and columns.
Close the dialog and check the result using the preview.
You can remove items that are already configured by dragging them back to the left field list.
Configuring the cross table
Use the right mouse menu and the"Configure" menu item to set the cross-table.
The configuration dialog consists of three areas. The selection of possible fields is displayed on the left. In the upper area there is a toolbar for setting the calculation, the formatting and the font and color selection. The main area consists of three zones: "New Row", "New Column" and "New Value". You can now drag fields from the left edge into one of the zones with the mouse.
If a field is dragged to "New column", this field is displayed horizontally, i.e. at the top. With"New line", the field is displayed on the left-hand side. In the display, all the different values of these fields are determined and displayed in a separate column or row.
The field to be calculated is dragged onto the"New value" zone. This is a yield, Vk, Ek or another field that is to be totaled. You can drag several fields onto the zones and also determine the order in which the expression is to be nested. If several number fields are drawn to"New value", a corresponding number of numerical values are summed in the intersections.
If you select the total field, you can also set other calculation types, such as average, minimum value, etc., via the toolbar.
The finished configuration
The finished configuration can then be extended with colors and fonts. Especially if you have several values calculated, you can use colors to highlight the most important values.
If you want to remove fields from your diagram, you can drag them back to the field list on the left side.
The toolbar can also be used to set the sort order for the rows and columns.
What has to be considered?
- If no pivot view is used, all fields used in the data source, except the calculated total fields, should be grouped. This shifts the calculation load to the SQL server.
- If you want to restrict an area, you can set various filters in the data source using the magnifying glass icon. If you want to change the filters in a user dialog before printing, select the"Search dialog" option.
- After creating the data source, the data source must be switched off for the main report. To do this, select "Data source" from the "Report" menu.
- If possible, select only the really required fields in the data source, so that no more than the necessary intersection points have to be calculated.
- Assign the data source to the crosstable element via the toolbar.