Problem to create a table in a PDF

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.

Herick_0-1705423902512.png

 

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

Herick_1-1705423992846.png

Can somebody help me? Thanks in advance.

Solved Solved
0 5 454
2 ACCEPTED SOLUTIONS

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]>>

View solution in original post

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!

 

View solution in original post

5 REPLIES 5
Top Labels in this Space