Unable to retrieve TypeId from DocuRef table for SSRS report

[Ventainais]

Thank You for the reply.

The date variables are correct.

NAME: endDateTime
VALUE:17.10.2019 20:18:39

NAME: startDateTime
VALUE: 17.10.2018 20:18:39

I use them to fetch DocuRef records which are a year old from current day and have TypeId == URL.
The "or" statement is used without the date period.

The complete requirement for data selection is as follows:

Report should show all active BP (CustTable.Blocked=“no“ and VendTable. Blocked =“no“) related records in DocuRef table
where DocuRef.Type= “URL” if primary address (DirPartyPostalAddressView IsPrimary=”YES”)
country has mark “YES” “Sanctioned country” and last screening date is older than one year from today
and all active debtors and vendors (CustTable.Blocked=“no“ and VendTable. Blocked =“no“) records
with primary address (DirPartyPostalAddressView IsPrimary=”YES”)
country has mark “YES” “Sanctioned country” and without related records in DocuRef table where DocuRef.Type= “URL”.

I think the while select statement looks correct.

I am just testing on CustTable.