to display no data message in report

[Mohit]

I created a report

using sqlDataSource with parametrized store procedure,

 

Is

 

it possible to show a "no data exists" message if the query returns no data?

 

[Steve]

Hello Mohit,

Currently there is no out of the box solution to show a "No records found" message when there is no data. However we have this feature logged in our Feature Tracking System and we will introduce the new 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 a Binding with Property Path - Parent.Visible and Expression - =Count(1) = 0. To hide the Detail section when there are no records found you have to add a Binding with Property Path - Parent.Visible and Expression set to =Count(1) > 0.

Kind regards,
Steve
the Telerik team

[ankit]

I tried do do what you said, but was not able to implement that..
Is there a video where you have set some thing similar. Then i can use that in order to implement this..

It will be a good feature to have. Do you have any idea when this will be available?

[Steve]

Hi Mohit,

I have attached a working sample using the approach described in my previous post. We're aware that this is a good feature and we would implement it for subsequent version, but cannot engage with a timeframe at this time.

All the best,
Steve
the Telerik team

[Patrick]

Steve,
Would you please upload that .zip file including the .sln and .csproj files? Thanks!

-- Patrick

[Steve]

Hi Patrick,

Go ahead and paste the report in the report class library part of our report examples that are shipped with the product.

Regards,
Steve
the Telerik team

[Daniel]

Hi,

4 years later and this is still not implemented now!?

Forthermore I don't understand why report header/footer are not created/printed with an empty datasource !?
Currently the end-user sees only an complete empty page and therefore associating this with an error. 

Regards,
Daniel

[Stef]

Hello Daniel,

In the latest Telerik Reporting versions if the report's data source returns zero records there will be printed the ReportHeader/Footer sections and any static GroupHeader/Footer sections.

If you have not chance to upgrade, please give a try to Telerik Reporting Q1 2015 SP1 v9.0.15.324 and upgrade the current projects.

Regards,
Stef
Telerik

 

 

[Frank]

Where exactly would that be?

 

Thanks.

[Stef]

Hi Frank,

In latest Telerik Reporting versions, if the report's DataSource retrieves no records, static sections still will be rendered, allowing you to add a message in the report and display it.

My recommendation is to use the latest available Telerik Reporting Q2 2015 SP1 v9.1.15.731 (will be available for download by the end of the day - July 31st).

Regards,
Stef
Telerik

[frank]

this is a lame implementation. It seems like most people are going to want the report header but also the page header/footer when its empty. seems like you could make an easier way to set the page header/footer to show even if its empty dataset...

[Stef]

Hello frank,

Page sections and static report sections like ReportHeader/Footer and GroupHeader/Footer, where the group is created not based on data) are rendered.

The attached video can be previewed in IE browser and illustrates the result.


If you need to display a NoDataMessage, please check How to show 'No Data Message' or hide an item in case of No data.

Regards,
Stef
Telerik by Progress