Web layout: Add test when no records are displayed 1

[shewitson]

Hi All

I need to know how to add/display a meaningful message when my web report returns no records. I know you can achieve this with paper-layout reports but the same method does not seem to work for web-layout reports.

I am using Report Builder 9.0.4.0.33.

Your help will be much appreciated.

Regards,
Stewart Hewitson

 

[nagornyi]

Set fill color of the frame that keeps the data to be white, instead of transparent. Put the label "No data found" behind the frame. If there are data, the frame will hide the label, if there are no data, the frame will shrink and reveal the label.

 

[shewitson]

I tried your solution and it work for the paper layout but not for the web layout.

But I worked out a solution..here is it.

step 1. create a summary column (to return data if the report is not empty)
step 2. create a formula column and insert the logic below

if :CS_1 is null then
return ('**** No Data Found. ****');
else
return(null);
--CS1 is the summary column.
step 3. in your web source add the code below at the end of your report

<!-- no data found code -->
<h5><rw:field id="F_CF_2" src="CF_2"></rw:field></h5>

--field id can be name
--field src must be the name of the formula column

Good luck.
Regards,
Stewart Hewitson

 

[nagornyi]

Thanks for sharing this with us.