Tables in Internal Reporting

Owned by Morten Lindequist Køhler
Feb 14, 2024
3 min read

Tables can be included in the data delivered to the internal reporting engine in Perfion. The data delivered to the internal reporting is specified by a SuperQuery in a report.

The SuperQuery needs to be setup to include the Table feature to ensure that the data is available.

When the report has been configured to include table data, the Internal report designer can be activated by running the report and selecting the Design option.

In the toolbox of the internal report designer there is a PerfionTable control that you can drag-and-drop onto the surface of the report design:

Before placing the table onto the surface, its worth thinking about where the table data is withing the structure.

If the table data is on the left hand side ( e.g. categorizing ) then you will need to setup a grouping to hold the table.

This is because for every product on the right hand side, the current left hand side will be repeated.

By setting up a grouping for items of the left, that area will only repeat when the item progresses.

To add a group, press the Add a Group button at the bottom of the design screen. You will be prompted to specify an element to group by. For items on the left side CatalogRelation._Order is likely what you need.

Now you can drag the PerfionTable control into the grouping surface or the detail surface, depending on your needs.

To link up the table with data, expand the Field List data.

 

Locate the table data, then drag it into the PerfionTable then release. This will forge a data binding link between the two.

You can now preview the table by pressing the Preview button at the bottom of the report designer.

PerfionTable properties

There are two properties that can be changed for a PerfionTable

  • AutoWidth
    This should be left as True.

  • Keep Together
    For most situations this can be left as No. Some table designs can run into an issue where when a design cell has been split. For example:

This design can produce a result where the splitting of the table over two pages can be an issue as shown:

By setting Keep Together to true, the image will be drawn correctly. The downside to setting this to True is that the output size is increased.