Conditionally display message if no results found

[Jordan]

Hi,

I am currently evaluating Telerik reporting.  We will be generating reports that are both used in an MVC webapp and emailed to people as part of overnight batch processes.

I want to conditionally display a message in the report if no results have been found. I have looked at this thread but this doesn't suit my needs. Are there any other ways of doing this? eg by counting the number of records in the report and displaying a message if the count == 0?

many thanks,
Jordan.

[Peter]

Hello Jordan,

 

Currently there is no out of the box solution to show a message when there is no data. We have this feature logged in our features list and we will introduce this option with a subsequent version of Telerik Reporting.

In the meantime there is a workaround you can use instead. Just add a TextBox item within a Report Header section. Then set the textbox value to "No Data Found". To hide the Report Header section when the datasource returns data, add the following Binding to the textbox item:

Property Path	Expression
Parent.Visible	=Count(1) = 0

To hide the Detail section when there are no records found you have to add the following Binding:

Property Path	Expression
Parent.Visible	=Count(1) > 0

All the best,
Peter
the Telerik team

[Jordan]

Hi Peter,

Many thanks for the reply.

Just out of interest, why do you pass "1" to the Count() function? Is that a shortcut/alias to getting the result set?

cheers,
Jordan.

[Steve]

Hello Jordan,

Yes, count of constant gives you the whole result set.

Best wishes,
Steve
the Telerik team