Need Help.....(

AppSheet AppSheet Q&A
,
1

I tried to make a report based on ORDER ID, but I had difficulties.
Purchase data appear as much as transaction details.

2X_8_87566ae4a1ea92f67f34eb0668126616183ff5dc.jpeg
2X_8_87566ae4a1ea92f67f34eb0668126616183ff5dc.jpeg1280×720 130 KB

2X_1_113812bf655cecf513e3b28f1085d6a966c723c7.jpeg
2X_1_113812bf655cecf513e3b28f1085d6a966c723c7.jpeg576×1024 46 KB

2

Try moving the <End>> tag after the table in your template.

3

thanks steve,

now i will try to moving <> after table ( detail transaction )

2X_1_1a12ac991260116627f16cd5979503dfccd14132.png
2X_1_1a12ac991260116627f16cd5979503dfccd14132.png1366×768 62.2 KB

but output report

2X_b_bb6b8cd7456fe18176b9ff4de22bab74eb61b423.png
2X_b_bb6b8cd7456fe18176b9ff4de22bab74eb61b423.png1366×768 74.7 KB

maybe any wrong with my expression ?

4

Try this: in your first <<Start>> statement, add TRUE as a third argument to SELECT():

<<Start:SELECT(order list[OrderDetail Id], AND(IN([OrderDetail Id], [_THISROW].[Related orderlists]),[status]="open"), TRUE)>>

See also:

5

Thank you very much steve…
i will try to read more expression on appsheet…

1 Like