Hiding a subreport - How to suppress the blank line ??

Hot Topic

The connection manager 'OLEDB' is not properly installed on this computer
xml to relational tables
General Network Error OpenXML
SQL Server and Windows Update
Semi-additive measures in AS2005 Standard Edition
Error when create a Server object using SMO
SQL Server 2000 and SQL Server 2005 have the different behavior
Stored Procedure
Is this possible?
memory usage of aspnet_wp.exe

SQL Server

A Problems after the install of the Hotfix
Synchronization of Business Contacts in Outlook with Small Business Accounting
get unspecified error when browsing data of CUBE
Reporting Services portal
openquery update and optimistic concurrency
View sort order problems
strange refresh of the parameter area
Excel 2003 and nonemptycrossjoin
Where can I find the infamous Microsoft.SQLServer.Broker download?
About plug-in algorithms in SQL Server 2005

Hiding a subreport - How to suppress the blank line ??

Hi, I have a main report with several subreports in a list. If I hide a subreport that contains no data by using the "visibility" attribute, there s always a blank line left in the list. Is there any way to suppress that blank line


Answer this question

Hiding a subreport - How to suppress the blank line ??

  • Denis Silva

    Common guys, any "Pro" out there has got to know how to do that !
    Or is it just impossible
    I postet on several forums and a lot of people have this problem, too, but noone seems to have a solution for this.

  • Anna1234

    Hi,

    Right click on the field and go to expression.

    In expression type the below

    =IIF(Field!FieldName="",true,false)

    Regards,

    Prashant

  • Smriti

    Hi,

    I have the same problem. I am using a sub report with a table. Even, if I reduce the height to maximum extent, it still adds up and creates blank space. Is there any other way

    Can I suppress a single cell of the table if it is blank

    Thanks in advance !!!



  • BlackStallion

    What is the actual expression to "Hide the table row when theres no data in your subreport"

    Thanks,

    Pete

  • xxxxxxxxxxx

    hi nic

    Create an Empty Row in yout table.

    Embed the sub-report in this table row.

    Hide the table row when theres no data in your subreport.

    And it will hide the extra space

  • Pascal Hoffmann

    Thanks, I tried that before, but that doesn’t solve my problem.
    Even when I minimize the height of the line in the main report or the sub report itself, there’s still a noticable blank line. In my case, I’ve got like 6 or more sub reports in that table and even minimized there’s too much blank space if more than one sub reports are hidden.
    Isn’t there any way to completley hide the line, where the sub report would have been

  • jpopp

    Minimize the size(width and height) of the sub report to the maximum extent.

    sincerely,

    Amde
  • Hiding a subreport - How to suppress the blank line ??
Answer this question