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.
Solved! Go to 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]>>
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!
User | Count |
---|---|
16 | |
10 | |
10 | |
8 | |
3 |