Add row if the table row count is 0

zharenkov · November 17, 2014

Hello,
I've got the report with report parameters startDate and endDate. In some cases the table may be empty(e.g. time period is too short). So in report only headers of the table are shown. I want to add a row in this empty table with message in one cell, e.g. "There is no data for this period" or something like this.
How can I do that?
 
I tried to add condition in fetch() script like this
<pre class="_prettyXprint _lang-nocode">
if (totalrows == 0) {
row["serviceName"] = "There is no data";
return(true);
}

if (currentrow >= totalrows) {
return(false);
}

var rowValue = resultInfo.get(currentrow);

row["serviceName"] = rowValue[0];
row["ogvName"] = rowValue[1];
row["ddl"] = rowValue[2];
row["avgTime"] = rowValue[3];
row["countPs"] = rowValue[4];

currentrow = currentrow + 1;

return(true);
</pre>
but it doesn't work. Is any simple solution for this problem?

GLO_FR · November 17, 2014

Hi,
 
I don't think that the fetch event is the right place because, if you haven't any row in your DS, you will probalbly don't have any fetch.
 
The easiest way is to to test the rownum and to dynamically set the header.
When the DS is empty the rownum is -1
 
Here is a basic example

zharenkov · November 17, 2014

Thanks. I added an additional row in my table and set its visiblity like this
<pre class="_prettyXprint _lang-nocode">
if(row.__rownum >= 0){
true
}else{
false
}

</pre>
It works fine.

GLO_FR · November 17, 2014

Hi, 
that's also a way to do it

Add row if the table row count is 0

Comments

Categories