No Data Available

Hi,

When I run a report and there is no data to be displayed, I want the report to
show the HEADER and FOOTER as normal, but the detail portion of the report should show "No Data Available".

How do I accomplish this?

Thanks
Nurani Sivakumar

Find more posts tagged with

Comments

mwilliams

Hi Nurani,<br />
<br />
This post from the devShare should help you out with that. There are other ways besides this as well, but this is one.<br />
<br />
<a class='bbc_url' href='http://www.birt-exchange.com/devshare/designing-birt-reports/522-birt-display-quot-no-data-quot-when-table-is-empty-example/#description'>BIRT Display "No Data" When Table Is Empty Example - Designs & Code - BIRT Exchange</a>

nuraniuscc

Hi Mike,

I cut and paste the XML code onto an existing report just to see How the
report layout would look and I get an error saying "Error is XML File".

All I did is copy an existing report and called it "Test". Then deleted the old
XML code and copied this into it. Is that the way we do it?

Also, Is there another (Easier) way to get this issue (No Data Available) addressed.

Thanks
Nurani Sivakumar

mwilliams

Nurani,

You should have just been able to save the report to your workspace and opened it within the designer. You shouldn't have to copy the XML source over to another report.

I'll look into a "simpler" way to put "no data" into your table.

nuraniuscc

Ok, I am back on this.

Are you saying "Just copy the XML file into my Report Workspace" and all is
fine.

Should I copy this to each and every report. If so, Where should I copy it to?

Thanks
Nurani Sivakumar

mwilliams

Nurani,

That file is a report design. You can open it up and see what was done to make the report display "No Data" if there is no data and apply this same idea to your report design. Hope this helps.

nuraniuscc

Hi Mike,

I get errors when I try to open the Layout for this file. Also, by looking at the
XML File I can't understand Head and Tail of it.

Also, I am new to Java and Eclipse, Birt etc.

So, If you could, Please attach the actual report layout and point me to the
place where this logic (No Data Found) is being coded.

Is there a simpler way to approach this for anyone new to this like myself?
I know you talked about finding an easier solution to this earlier in the Post.

Thanks. Your help is much appreciated

Nurani Sivakumar

mwilliams

Nurani,

I downloaded and saved the report design in my BIRT 2.3.0 workspace and opened it in the designer and it worked just fine. Not sure what issue you're having with it.

nuraniuscc

Hi Mike,

Can you send me the attachment again. I am getting error messages while
opening the file that you sent earlier.

Thanks
Nurani Sivakumar

mwilliams

Nurani,

Are you trying to open the attachment, or are you saving it to your workspace that you use with BIRT?

nuraniuscc

Hi Mike,

This document is in my work space and I was just looking through it. Maybe
inadvertently I might have edited it.

I was going to look at the Layout. (That's when I got the error message)

Also, I am not quite clear in my understanding. I was thinking that the logic for "No Data Available" (Your attachment) had to be included in all of my reports.

Apparently that's not the case.

So How do I exactly avail this logic from your attachment.

Thanks
Nurani Sivakumar

mwilliams

Nurani,

You just need to open the report design and see what was done to cause the no data available string to be visible and apply that logic to your own reports. For every report you want this feature in, you'll have to duplicate the logic.

nuraniuscc

Hi Mike,

The reportdesign document that you sent earlier has got corrupted. Can you send me the report design doc again?

I see it's something to do with CountofRows(). Is there a direct way, easier way for me to code this in a script and Display the message, I want to display.

Thanks
Nurani Sivakumar

nuraniuscc

Hi,

Can you please reply to my question above?

Thanks
Nurani Sivakumar

mwilliams

Nurani,

I just downloaded the report design and ran it from the link I provided. It works as expected. What is the issue you're having with it?