Report generation Template to include all columns of child table

[Kams1]

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

  

[WillowMobileSys]

---

@Kams1 wrote:

but when i generate a report template some child columns are not included

---

What does "some" mean?  Could you show an example image of the issue you are seeing?

[Kams1]

@WillowMobileSys this is google sheet child table and the template tagging for child variables looks like this. 

Leaving out all the other column

[Kams1]

@WillowMobileSys child table has 13 columns. But doc report generation template only 5 columns.

[WillowMobileSys]

Your images are too small to be read.  However, I can tell in your template example that there are only 5 columns implemented in the table.  Nothing is done automatically.  If you want all 13 columns included in the generated PDF, you will need to explicitly include all 13 columns in your PDF template.

I hope this helps!

[Kams1]

@WillowMobileSys , Thanks for your reply. Kindly advise how do I explicitly add columns, that's where I have a challenge. I have been using Start/end syntax to include a column of interest, but its not working. is there any other way to include a column explicitly. Looking forward to hearing from you Colleague.  

[a_aleinikov · Accepted solution]

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.