Display a fluent number of columns beside each other
depending on the available space.
For this report is a generic columns template used.
Whit the following settings:
Before rows: <div class="uTable">
After rows: </div>
Before each row: <span class="uRow">
After each row: </span>
Column template:
<div class="uColumn">
#COLUMN_VALUE#
</div>
For the departments Breaking of the report is used
With the following settings:
Breaking columns: First column
Breaking column style: Repeat headings on break.
For repeat heading breaks use this format,
use #COLUMN_VALUE# subs:
<div class="department">#COLUMN_VALUE# </div>;
Select statement is
select emp.department_id
, EMP.LAST_NAME
from OEHR_EMPLOYEES EMP
Notice that a lov is used to display the department name.