Hi All,

I have 3 tables with the relevent structure below:

table: items -> cols: id, name, groupid
table: group1 -> cols: id, name, highgroupid
table: highergroup -> cols: id, name

I am trying to create a report with nested groups as follows:

Highergroup ID, Name
-- Group1 ID, Name
---- item ID, Name

The problem is that when i create two nested groups in the group expert nothing shows up in the report. If I only create a single group (group1), that grouping works fine, but when i include the highergroup nothing is shown.  All tables have been linked correctly in the database expert.

Any ideas?