Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2010
    Posts
    3

    Unanswered: Hiding the white space when individual cells are hidden in a table

    Hi All,

    I need some help on how to eliminate the white space when I hide individual cells.

    EG.

    I have:

    Phase 1 Phase 2
    A D
    B E
    C F

    When I hide certain cells leaves the white space

    Phase 1 Phase 2
    D
    B
    C F

    What i want is

    Phase 1 Phase 2
    B D
    C F


    I have used the visibility property on the individual cell to hide it if it meets a certain criteria but how do I remove the white space?

    I am using MS Visual Studio 2005 with SQL reporting services

  2. #2
    Join Date
    Oct 2010
    Posts
    3
    Sorry that didn't turn out right

    what i have is

    Phase 1
    A

    C

    but I want

    Phase 1
    A
    C

    Any help would be appreciated

  3. #3
    Join Date
    Nov 2004
    Posts
    1,427
    Provided Answers: 4
    Code:
    SELECT [Phase 1]
    FROM MyTable
    WHERE COALESCE(RTRIM([Phase 1]), '') <> ''
    With kind regards . . . . . SQL Server 2000/2005/2012
    Wim

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

  4. #4
    Join Date
    Oct 2010
    Posts
    3
    not quite sure where I would put that??

    I am using Microsoft Visual Studio 2005, report builder with SQL.

    This shows the white space I get:
    error.bmp

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •