AnsweredAssumed Answered

Creating a Report based on related tables

Question asked by cristian.stanimir on May 11, 2018
Latest reply on May 11, 2018 by ThierryGuemboura


Hello Everyone,

 

My problem is this...

I have a Table0 (parent) and table1, table2, table3.... table15 (child tables) all from 1 to 15 ar related to Table0. In Table0 I have a PK (ClientID - set as UUID) and the rest have FK(ClientID).

I want to generate a report that shows clients name from Table0 and ALL records from the related tables. Problem is if I use list view and put the client field in the header and all the related fields from the related tables in the body section I only get the one record per line.   I my case Table1 could have 5 records, Table 3 could have 2 records  related to that clientID.  How can I build the report to show all records from the related tables for one specific client.

 

Also be exportable to excel and work with webdirect  (.tab since excel is not supported)  because the reports will be generated by the user and user access is via browser.

 

Thanks.

Outcomes