Assuming proofs is required, the following 2 results were found.
This article serves to describe several workarounds or proofs of concept. Why? We have a first report which acts like a search page. You enter the student you are looking for by reference or name and if there is only 1 result in the results page, then...
= ifnull(r_Result.get("Modified_Time"),r_Result.get("Added_Time")).toTime().toString("dd/MM/yyyy hh:mm a"); // // future proofs v_ExchangeRate = if(v_ExchangeRate == 0,1,v_ExchangeRate); // // transforms if(r_Result.get("Valid_Till") != null) {...