Print No Data Set Band for Empty Dataset

Question

I have a report which has a dataset. I want to print No Data Band whenever the query in the dataset returns 0 records (empty dataset).

I have set the "When No Data" to "No Data Section". But it doesn't seem to be working.

Any Suggestions?

score 15 · Accepted Answer · edited Apr 26 '16 at 18:08

15

In order to print No data band whenever the query in the dataset returns 0 records(empty dataset) follow these steps:-

Go to Report Inspector and add No Data band in the report
Put static text, such as No Data Found
Right-click the report to open the report property section
Set When No Data property to No Data Section

After adding No data band whenever query will return 0 record "No Data" band will display the static text.

edited Apr 26 '16 at 18:08

Dave Jarvis

30,436
41
178
315

answered Dec 18 '13 at 04:52

Sharad

3,562
6
37
59

this seems to only apply to iReport ? – Don Cheadle Oct 10 '16 at 15:02

score 2 · Answer 2 · answered Mar 27 '17 at 13:25

For those like myself, who do not use JasperSoft or older iReport and directly work with XML, do the following:

<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports"
              xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
              xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports
   http://jasperreports.sourceforge.net/xsd/jasperreport.xsd"
              whenNoDataType="NoDataSection"
              name="freport" pageWidth="595" pageHeight="842" 
              columnWidth="555" leftMargin="20" rightMargin="20"
              topMargin="20" bottomMargin="20">

Add whenNoDataType="NoDataSection" to the <jasperReport> element.

<noData>
    <band height="15">
        <staticText>
            <reportElement x="0" y="0" width="200" height="15"/>
            <box>
                <bottomPen lineWidth="1.0" lineColor="#CCCCCC"/>
            </box>
            <textElement />
            <text><![CDATA[The report has no data]]> </text>
        </staticText>
    </band>
</noData>

Add <noData> element below the detail band.

ziMtyth · Answer 3 · 2018-04-04T07:20:33.370

1

When I've tried the solution proposed by @Sharad I have found another way, in my approach no need to add No Data band:

Right-click the report to open the report property section
Set When No Data property to All Sections, No Detail

The final result will be the same report with no detail. In my case it responds to my needs perfectly.

PS: I used iReport 4.0.2

edited Apr 04 '18 at 07:20

answered Apr 01 '18 at 08:52

ziMtyth

1,008
16
32

Print No Data Set Band for Empty Dataset

3 Answers3