Osprey Academy - Customer Support & Training

Using Osprey

Learn how to use Osprey to manage your day-to-day operations and processes

Who is this guide for?

Case Management Supervisors and System Supervisors

You can use a table to display data. This is useful where large data entries are to be displayed, such as time attendance notes. Using tables can make your report easier to read, and you can also set different highlights on alternate rows to enable a striped effect as shown below:

Insert your table

In the example below, we have created the basis of a time attendance note report.

Click to enlarge

We will insert a table to the Detail section to display the data rows.

From the Tool Box on the left hand side of the report designer, click and drag the Table tool into the Detail line on your report. You can add more columns by right clicking on the table, selecting Insert > Columns to Left/Right.

You can then drag the table cells to match with your headings in the Page Header:

Click to enlarge

Inserting data into your table

We now need to insert the data into our table.

Click the first column of your table, and then the little chevron button which appears in the top right hand corner of the column:

From the menu, select Data Binding

Expand your data set name, and then choose the field you want to appear in this table column:

Continue until all table columns have been assigned. You can format the table cells in the same way as regular fields:

Click to enlarge

Adding alternate row highlights to your table

You can now add alternate row highlights if you wish.

  • Select your table by hovering over it, and selecting the icon shown below:
  • In the Property Grid in the bottom right of the report designer, ensure your table is selected in the box at the top, and then navigate to the Style > Collection area:
  • In the Styles Editor box, click Add
  • In the right hand panel, select your background colour, then scroll down to name it in order to identify it later:

In the example above, we have added a light grey and a white style.

Now, we need to apply these styles to the table’s even and odd rows.

In the Property Grid, with your table selected, set the Even and Odd style options to your corresponding even and odd styles:

The Style Priority option will need to have Use Background set to Yes for this to work.

When run, your report will now have alternating grey and white rows:

More Report Writer Links

In this article