<p>I'm trying to write script by selecting data source.</p><p>Data Source has many tables. I'm looking for a particular column in particular table.</p><p>If that column is null execute one query else execute different query</p><p>I wrote following sample selecting data source in beforeOpen method</p><p> </p><p>var reportRunnable = reportContext.getReportRunnable();
var reportDesign = reportRunnable.getDesignInstance();
var table = reportDesign.getTable(organisation);
if(table.row[time]!= null)
{
select id, time - time1 from tablename;
}
else
{
select id, time1 from tablename
}</p><p> </p><p>If time column is not null in table organisation, i wanted to perform one query execution else other one.</p><p>can some one tell whats mistake i'm doing? Its giving failed to execute script.</p>
