if HasFinalisation then (reporting.queries.client.lookupaccountingperioddata("ClientSummaryTab|ClientDetails|Officers|Officers|Officers|*:filter[*|General|Signatory|Current Period=Balance Sheet,*|General|Signatory|Current Period=Both]:filter[*|General|Cessation|Current Period> '"+ reporting.queries.client.lookupaccountingperioddata("Disclosure|General|FinalisationDates|FinalisationDates|Trustees|Current Period")[0].Value +"',*|General|Cessation|Current Period=null]:filter[*|General|Commencement|Current Period<= '"+ reporting.queries.client.lookupaccountingperioddata("Disclosure|General|FinalisationDates|FinalisationDates|Trustees|Current Period")[0].Value +"',*|General|Commencement|Current Period=null]",null,true))
else
(reporting.queries.client.lookupaccountingperioddata("ClientSummaryTab|ClientDetails|Officers|Officers|Officers|*:filter[*|General|Signatory|Current Period=Balance Sheet,*|General|Signatory|Current Period=Both]:filter[*|General|Cessation|Current Period> '"+ reportHelper.Currentperiod.EndDate+"',*|General|Cessation|Current Period=null]:filter[*|General|Commencement|Current Period<= '"+ reportHelper.Currentperiod.EndDate+"',*|General|Commencement|Current Period=null]",null,true))