Solved: Report generation Template to include all columns ... - Page 2

Kams1 · 04-29-2025 05:37 PM

I am developing a financial management app. I have a number of tables which are working just fine, in particular I have two tables Transaction and Items. the relationship is properly set to ref, but when i generate a report template some child columns are not included. and again, when I populate the system, actual variables do not populate the child table. photo number 6 is the google sheet child table. please assist. Thanks, in advance

a_aleinikov

Hi ,

To include all child table columns in your report template:

– Make sure your <<Start>> expression points to the related child records, e.g., <<Start:[Related Items]>>.
– Inside the <<Start>>, list every needed column explicitly with its template tag (e.g., <<[ColumnName]>>).
– Check that your Ref relationship is correct and that the child table’s column names match exactly.
– If actual variables don’t populate, confirm they are included in the SELECT or list reference feeding the template.

View solution in original post

Report generation Template to include all columns of child table