Report Designer


For trial users; this feature is available and fully functional for trial purposes during your trial period.
For registered customers; this feature is optional and available only if your license includes custom reporting feature.

Designing a Report Template

The basic work flow of creating a report template is as following:

Page Layout & Report Sections

The report designer shows you the page layout on the left. The page layout consists of 5 major sections each of which represents a certain part of the page or report. When you click a section, SB will show only the corresponding area of the page in full page width. You may determine how much height should be allocated by each section by clicking "Section Properties" button.

Tip: SpeedBase will show the prefered page margins as a dotted red line. This line has no effect on your design or print process and is there only to guide you aligning the items easily. You may change the margins from "Report Properties" window (see Custom Reports).

Tip: SpeedBase will show the edge of the printable area reported by the printing device as a solid red line. You shouldn't put any items beyond this line as your device will not create output on that area.

Page Header

Represents the area between the physical top edge of each page and prefered top margin. Any item put on this area is printed to the same area on all pages. You may however exclude the first page of the report from "section properties" window.
You may use this area to put page numbers or drawing items that should be displayed on top of each page.
You may change the height of this section by modifying page margins. See Modifying Report Properties

Report Header

Represents the initial fixed (introductory) content that should be displayed on top of the report. If you leave this section blank, SB will simply skip this section and will not allocate any page area in the report.

Data Section

Represents the data area of the report. Starts after report header and continues thru next pages until all data is written. You will see all data items you can put into the report under this section. When SB creates the report, it will repeat printing this section for each record requested. You may adjust various settings from "Section Properties" window.

Sub-Data Sections

You may see one or more section items under the data section. SB will show a sub-data section for each menu item (i.e. relationship) your records have. This section is very similar to the data section. If used, SB will repeat printing this section for each "related" record.
This section has a special property "Data Source", where you can select the desired view in case the menu item has multiple views with different filter attachments.

Report Footer

Represents the final fixed (conclusion) content that should be displayed at the end of the report. If you leave this section blank, SB will simply skip this section and will not allocate any page area in the report. You may force this section to start from a new page from "Section Properties" window.

Page Footer

Represents the area between the prefered bottom page margin and physical bottom edge of each page. Any item put on this area is printed to the same area on all pages. You may however exclude the first page of the report from "section properties" window.
You may use this area to put page numbers or drawing items that should be displayed on bottom of each page.
You may change the height of this section by modifying page margins. See Modifying Report Properties

Adding / Modifying Data Items

Data items correspond to each field in a catalog. You may place a data item only into the related data section. Tip: If you need to adjust the position or dimensions of the items with more precision, enter the desired values into the related boxes on top and press enter.

Adding Images/Decoration/Computed Items

You may add various shapes and labels to decorate your report.
Tip:
Remember to click on to the small arrow icon on the right end of the "Add Drawing" button. This will open a menu where you can select from available drawing items or labels.

Page Counter: Displays current page number.
Record Counter: Displays current record number, increases by one on each start of a record section. You may use this item on the record section to show the row number of each record or on the report footer to show the total number of records printed.
Sub-Record Counter: Displays current record number on a sub-data section. Counts each "related" record and resets when a new data section starts.

Deleting Design Items

Click on the design item you want to delete. Press delete key from your keyboard or click delete button on top of the designer window.

Creating Tables inside a Data Section

You may prefere to print data in tabular format (grid style) instead of placing each field one by one in free design mode. To create a table:
  1. Select the the data section (or sub-data section) from page layout box on top,left side of the designer window,
  2. Click "Section Properties" button, click "Data" tab,
  3. Check the box named "Show data in tabular format",
    Note that you may not place free style data items and tabular format at the same time. If there are any pre-existing items on current section, SpeedBase will ask you to delete all existing items to continue.
  4. Add the desired fields to the "displayed fields" box, you may also adjust the column ordering of items.
  5. Click "OK" to save changes, this will create a single data object displayed in tabular format,
  6. You may adjust various formatting properties by right clicking on it and selecting "properties".
  7. You may adjust column widths by dragging the column borders with your mouse.
Note that, the tabular item is displayed as a single line table on design area. When the actual report is created, SpeedBase will add as many rows as needed to the table until all records are printed.

How to adjust column widths of the table

Tip: Avoid accidentally clicking outside the table which triggers auto-adjustment until you finish all adjustments as described above.

Printing Multiple Columns

It is possible to design a data section with 2 or more columns. You may choose the desired number of columns from "Section Properties" window.
When you adjust a data section to multiple columns, SB will start to display only the first column of the page, cutting the page at the start of the second column on right. You should put all design items into the first column. While creating the report, SB will use the same design for all other columns and fill data from top to bottom on first column and then continue from the beginning of the next column.
Online Help Home Page   ::   InfoLine Software Home Page