Problem to create a table in a PDF

[Herick]

Hi all,  I'm starting in developing using Appsheet.  I'm making a little project and I found a problem.

I have 4 tables:  Projeto, Fornecedor,  Insumos, Custos.   The Custos table contais reference to the Projeto, Fornecedor and Insumos tables.

So, when you see the Projeto table,  they show you the Custos table, with their many Insumos, every one with reference to their Fornecedor.

I try to generate a PDF to show a Projeto report, to any change made in the Custos table. 

My File to generate the report only shows one item from the Custos table, when they should show all itens that make reference to the specific Projeto.

I Want a report the closest has is in the UI.

Can somebody help me? Thanks in advance.

[Markus_Malessa · Accepted solution]

Getting really close I think. In your Projeto table you should have a virtual column titled something like "Related Custos" so change your start expression to <<Start: [Related Custos]>>

[Suvrutt_Gurjar]

Please take a look at the  template <<START>> expressions.

Use Start expressions in templates - AppSheet Help

[Herick]

I already tryed but without success.

They only show in the document the Custos item that suffered alteration. I want tho show all that reference the same Projeto.

[Herick]

I altered the template of the table adding the <<start>> but now, the table shows all Custos even those that are not referenced by their specific Projeto.

[Markus_Malessa · Accepted solution]

Getting really close I think. In your Projeto table you should have a virtual column titled something like "Related Custos" so change your start expression to <<Start: [Related Custos]>>

[Herick · Accepted solution]

Thank you very much for your tip.

I create a virtual column on the Projeto table with this code:

SELECT(Custos[Row ID], ([Projeto] = [_THISROW].[Row ID]))

In the report file the start:

<<Start:[Projeto].[Related Custos]>>

The result was the way I wanted. Aprecciate your help. Many thanks!