Opened vs Resolved Issues (Table Report)

This particular example will generate a table report showing the number of opened issues vs number of resolved issues for a given list of projects.

string [] projects = argv[ 0 ];
string [] resolvedIssues;
string [] openedIssues;
for (string p in projects) {
     resolvedIssues[p] += countIssues( "project = " + p + " AND status in (Done, Closed, Resolved)" );
     openedIssues[p] += countIssues( "project = " + p + " AND status not in (Done, Closed, Resolved)" );
}

SILReportingHeader [] headers; // the hearders of the table

SILReportingHeader h1;
h1.name = "Opened Issues" ;
h1.sortable = "sortable" ;
h1.color = "white" ;
h1.bgColor = "#79aadb" ;
headers += h1;

SILReportingHeader h2;
h2.name = "Resolved Issues" ;
h2.sortable = "sortable" ;
h2.color = "white" ;
h2.bgColor = "#79aadb" ;
headers += h2;

string [][] rows; // populating the rows
for (string p in projects){
     rows += {openedIssues[p], resolvedIssues[p]};
}

SILReportingTable table;
table.headers = headers;
table.rows = rows;

return table;

For more information about the predefined structures that comes in help for the table reports check the predefined structure types page.