This is a migrated thread and some comments may be shown as answers.

to display no data message in report

11 Answers 273 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Mohit
Top achievements
Rank 1
Mohit asked on 16 Jun 2011, 12:15 PM

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?

 

11 Answers, 1 is accepted

Sort by
0
Steve
Telerik team
answered on 20 Jun 2011, 09:32 AM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
0
ankit
Top achievements
Rank 1
answered on 22 Jun 2011, 06:27 PM
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?
0
Steve
Telerik team
answered on 23 Jun 2011, 07:24 AM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
0
Patrick
Top achievements
Rank 1
answered on 20 Jul 2011, 10:20 PM
Steve,
Would you please upload that .zip file including the .sln and .csproj files? Thanks!

-- Patrick
0
Steve
Telerik team
answered on 21 Jul 2011, 08:09 AM
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

Register for the Q2 2011 What's New Webinar Week. Mark your calendar for the week starting July 18th and book your seat for a walk through of all the exciting stuff we will ship with the new release!

0
Daniel
Top achievements
Rank 1
answered on 16 Apr 2015, 08:42 PM

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

0
Stef
Telerik team
answered on 21 Apr 2015, 07:24 AM
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
 

See What's Next in App Development. Register for TelerikNEXT.

 
0
Frank
Top achievements
Rank 1
answered on 29 Jul 2015, 08:13 PM

Where exactly would that be?

 

Thanks.

0
Stef
Telerik team
answered on 31 Jul 2015, 01:38 PM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
0
frank
Top achievements
Rank 1
answered on 13 Dec 2016, 09:08 PM
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...
0
Stef
Telerik team
answered on 14 Dec 2016, 09:22 AM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
General Discussions
Asked by
Mohit
Top achievements
Rank 1
Answers by
Steve
Telerik team
ankit
Top achievements
Rank 1
Patrick
Top achievements
Rank 1
Daniel
Top achievements
Rank 1
Stef
Telerik team
Frank
Top achievements
Rank 1
frank
Top achievements
Rank 1
Share this question
or