<p>I have a report with 3 parameters. I need to create a script that reads data from this report and stores it in database. The script be scheduled to run as a Windows job. I get no errors but the code does not reach dispalyData(rs)</p>
<p> </p>
<div>function getResultset( )</div>
<div>{</div>
<div>actuate.authenticate</div>
<div> ("<a class="bbc_url" href="
http://xxxxx:8700/iportal",null,"username","password">http://xxxxx:8700/iportal" ,</a> null, "username", "password", null, getResultset1, errorHandler);</div>
<div>}</div>
<div> </div>
<div>function getResultset1( )</div>
<div>{</div>
<div>file = "/xxxxx/xxxxxx/xxxxx/xxxxxxxxxxxx.rptdocument";</div>
<div>var requestOpts = new actuate.RequestOptions( );</div>
<div>requestOpts.setRepositoryType(actuate.RequestOptions.REPOSITORY_ENCYCLOPEDIA );</div>
<div>requestOpts.setCustomParameters({PIYearParam: "2016",PIMonthParam: "7",DayType: "1"});</div>
<div>var dataservice = new actuate.DataService();</div>
<div>dataservice.setService("<a class="bbc_url" href="
http://xxxxx:8700/iportal",requestOpts">http://xxxxx:8700/iportal",requestOpts</a>);<span> </span></div>
<div>var request = new actuate.data.Request("bookmarkName",1,100);</div>
<div>dataservice.downloadResultSet(file, request, displayData, errorHandler);</div>
<div>alert("At the end.");</div>
<div>}</div>
<div> </div>
<div>function displayData(rs)</div>
<div>{</div>
<div>alert("In Display Data");</div>
<div>var columns = rs.getColumnNames( );</div>
<div>while (rs.next( )){</div>
<div>for (var i = 0; i < columns.length; i++){</div>
<div>document.writeln(rs.getValue(columns
));</div>
<div>}</div>
<div>}</div>
<div>}</div>
<div> </div>
<div>function errorHandler(exception)</div>
<div>{</div>
<div>alert("Your application encountered an exception: \n" +<span> </span>exception.getMessage());</div>
<div>}</div>
