Printing a subset of child records given a condition

[Containium_Trad]

Good Day

I need some assistance with Filtering a subset of child records from a order. The filtering is based on a status column in the child record not the parent record. I want to show only the selected child records based on the given condition in a report. I have used the following formula which the documentation indicates should work however it checks the Parent record not the child subset. I want to be able to print the report from the Parent record. Any help would be greatly appreciated.

<<Start: SELECT(Orders[Order Id], AND(IN([Order Id],[_THISROW].[Related Orders]), [Order Status] = "Open"))>>

[Suvrutt_Gurjar]

Could you share your current template and mention what you wish to achieve based on that template?

[Containium_Trad]

Hi Suvrutt,

For now i have defaulted to the standard way of printing all the child records. See below.

I know that this template will not be able to print condition based child rows that i want the report to print.

I have tried using the below statement but it also does not work as i would like it to.

<<Start: SELECT(Orders[Order Id], AND(IN([Order Id],[_THISROW].[Related Orders]), [Order Status] = "Open"))>>

[Suvrutt_Gurjar]

Thank you. What column from child table you wish to use in condition to limit those records?

[Containium_Trad]

The field is not visible above but it is '[STATUS]="PAID".

[Suvrutt_Gurjar · Accepted solution]

Thank you. Instead of current <<START>> expression, please try 

<<Start:SELECT([Related FINANCEs][Child Table Key], [Status] = "PAID")>>

[Containium_Trad]

Hi Suvrutt,

Excellent, thanks that worked.

[nicolasfsamaja]

Hi to all!
I have an app that has Sales and a Child that has the Products Sold.
I would like to print only the first Product sold (in another page the second)... 
How do I do that? 
Thanks