Reporting Services – Sub Report | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Reporting Services – Sub Report

Hi, I have a main report which passes parameters to two subreports to display the corresponding data. Both the SubReports have its Header and Details section. Now the problem is that if one of the Sub report doesnt have any data the entire subreport isnt displayed. Even though the data isn’t there i want atleast the Header to be displayed. I tried some options but it didnt worked out. if anyone has a solution for this pls let me know asap. Thanks…
Why don’t you create a Textbox(saying "No data Exists") on your Subreport; visibility of which is toggled by count of data on your subreport (you can make a separate dataset just to find count)? HTH Harsh