I have a report with 4 tables (Category, SRZ,TraNag, VatNag, in Database expert, last 3 are connected with full outher join with Categoryid. The report is grouped by categoryid. SRZ,TraNag, VatNag are bound by date in select expert ( date in range). If there is a document in that range it shows category id and another field from one or all 3 remainging tables. I would like the report to show all records that give answer in the given date range. So far First date range in TraNag is checked and then if it is true the following two date ranges are checked.
If I add a new Category id and a docuemt e.g. in SRZ it does not show me the record even though the date range condition is true.

Is there a way to have conditions in the select expert written so that no matter which table has a racord in the given date range  it shows the record from table /s . Not only if TraNag has the condition evaluated as true.

Hope that without select expert conditions somebody can give me the answer.If no I can provide those

Does it matter in which order I put them? Stil if I add new cathegory ID it stops checking on first condition being true.