Business Intelligence Blogs

View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.

SQL Server Reporting Services - Displaying some message within a Tablix if there is no data.

  • 14 January 2011
  • Author: Anil
  • Number of views: 4154
  • 0 Comments

Hello all,

This is my first article that i am trying to write .I am encourage to write this article after joining the BIDN's network and reading a lot of articles regarding different topic. so, this may be simply for one but for someone it will be helpful for those who don't know how to do it ..

while working in .rdl design using BIDS , I need to display certain message within a tablix toolbar if the table doesn't contain's any data to display or there is no row count. In normal it will display the data if there is certain to display but if there is not any data to display then we have to display the message as like i.e "No data qualifies for this section"

For this we need to add a new row within a same table and set the properties of 'Hidden' field as =IIF(Count("DSName")>0,true,false)

Then within a same row we need to add a 'Placeholder' by right clicking within a row and set its properties value expression as 

=IIF(count(Fields!Row1.Value,"DSName")>0,"","No data qualifies for this section")

Also in another terms,

Remove no rows property for the table,added another table header row with the expression

=IIF(count(Fields!Row1.Value,"DSName")>0,"","No data qualifies for this section")

and set visibility hidden expression for the added table header row as

=IIF(Count("DSName")>0,true,false)

Replace"DSName" with your datasetName.

Hope this will help for someone .. :) !!!..

You can see some snapshot as:

           You can see output as if there is no output:

                                

Thanks,

Anil Maharjan

Print
Tags:
Rate this article:
5.0
Anil

AnilAnil

Highly motivated Business Intelligence Engineer having leadership abilities and team work skills as well as the ability to accomplish tasks under minimal direction and supervision. Has more than 5 years of development & implementation experience in HealthCare Data Analytics and Telecommunication

Other posts by Anil

Full biography Contact author

Please login or register to post comments.