Master-detail with filtering

dronerat

Hello!
I`m trying to create a master-detail report.Everything works fine except i want to hide some of the records based on a field.
For example
I have 2 tables:

Table1
Table2

And table1 is master and table2 is detail. The master fields are Number=Number. I want to hide all the records from table2 that the field Date Is Null.
When i try to make filter on the detail table i get "Filter property cannot be used for detail tables."

I am using Delphi7.

gordk

assuming your tfrxreportcomponent engine is set to default convertnulls to 0
in the report write code for the obp event of the detail band.

bandname.visible := (<datasetname."fieldname"> > 0);