<p>Hi,</p>
<p> </p>
<p>Using:</p>
<p>Actuate BIRT Designer Professional<br>
Version: 4.4.0<br>
Build id: v20150710</p>
<p> </p>
<p>Based on user name, I am trying to show only a subset of records from database.</p>
<p>Report is preview from BIRT/Acuate designer.</p>
<p> </p>
<p>My Data Set sql is:</p>
<p> </p>
<p><span style="color:#008000;">select *<br>
from CMO_BAL<br>
INNER JOIN ACCOUNT_ACCESS<br>
ON CMO_BAL.AC_NO=ACCOUNT_ACCESS.ACCOUNT_NUMBER<br>
WHERE ACCOUNT_ACCESS.USER_NAME= "id787"</span></p>
<p> </p>
<p>I placed my javascript in events, beforOpen, afterOpen but it is not working.</p>
<p>My Javascript code here:</p>
<p> </p>
<p><span style="color:#008000;">var userID = actuate.getUserId();<br>
if (userID == "anonymous"){<br>
userID = "Treasurer"; }<br>
this.queryText=this.queryText.replace("id787", userID);</span><br>
</p>
<p>Please help.</p>
<p>and tell me what I am doing wrong.</p>
<p> </p>
<p>Thank you.</p>
<p> </p>
