Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Supress blank line when subreport returns nothing

Author  Topic 

e.roc
Starting Member

5 Posts

Posted - 2010-05-18 : 14:47:40
Subreport does not show up at all when there is no data - which is fine. However it still leaves a blank line on the report where the subreport would have been. Does anyone know how to supress the blank line under these conditions? Thanks!

savior faire
Posting Yak Master

194 Posts

Posted - 2010-05-18 : 18:30:47
In Books Online:
ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10rs_1devconc/html/f254e957-127a-453a-8170-2d8772baccfa.htm

______________________________________________
Talk sense to a fool and he calls you foolish.
Go to Top of Page

e.roc
Starting Member

5 Posts

Posted - 2010-05-20 : 11:45:32
The link only discusses the NoRows property which lets me put text there in the blank space. However I am trying to supress the blank space altogether.
Go to Top of Page
   

- Advertisement -