ReportBro User Guide

A table is used to display a list of values, e.g. for invoices, statistics, shipping items. To print dynamic data a table needs a parameter list as data source. Have a look at table element and section element for further details. One click on the table selects the table itself, double click into the table selects a content element. Configuration and styling of contents is done the same way as for text elements. Have a look at the invoice demo and delivery slip demo to see how to use and configure tables.

Tables can be configured on different levels:
Table element itself: Contains the data source definition, allows enabling/disabling table header and footer and setting the amount of content rows for grouping purpose. By default a table contains 1 content row to iterate the parameter list.
Table content element: Set "Always on same page" within print settings to prevent row splitting on page break.
Table header and footer element (if enabled): Table header can also be repeated on every page in case the table spreads over more than one page.

Data grouping

To perform grouping of rows inside a table you first need to create multiple content rows. Select the table element and enter 2 into the field "Content rows" (or a higher number in case you have more grouping rows). Now you'll see multiple content entries below the table entry in the menu panel. Select the new content entry and enter a "Group expression". This row will then only be printed whenever the group expression value changes. If you want to show a header for each group your content row with the "Group expression" must be above the real content row (the one without any "Group expression"), otherwise it must be below to show a footer for each group.
The delivery slip demo uses grouping. A group header is shown every time the ${Category} parameter changes.

Hiding a table column

A section allows to print grouped lists of values. It needs a parameter list as data source (like a table). The difference to a table is, however, that a section can contain multiple elements to be grouped whereas a table displays data line by line. A section can be forced to be always printed on the same page.

${NetPrice} + ${Vat}
${Minutes} % 60

${Price} > ${Budget}
${Tax} != 0

${Weight} > 0 and ${Capacity} <= 200
${CompanyName} or ${Name}
not(${Age} >= 18 and ${AcceptTerms})

'ok' if ${Weight} <= ${Capacity} else 'not enough space'

'ok and plenty of space' if ${Weight} < ${Capacity}/2
    else ('ok' if ${Weight} <= ${Capacity}
        else 'not enough space') 

format_datetime(${Birthday}, 'd.M.yyyy')

format_decimal(${TotalAmount}, '#,##0.00')

len(${Name})
len(${InvoiceItems})

'Number of customers: ' + str(${CustomerCount})

int(${Price})

float(${Price}) * 1.2

# bad, will not work because Price is a decimal
${Price} * 2.5

# good, works because both values are decimals
${Price} * decimal('2.5')

'random value between 1 and 3: ' + str(randint(3) + 1)

rand() * 100.0