Add row if the table row count is 0

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?

Find more posts tagged with

Comments

GLO_FR

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

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

Hi, 
that's also a way to do it