CODEWITHSUNDEEP
ssrs-2008reporting-services
Malachi
Malachi

Reputation: 3221

Trying to Get Rid of White Space in SSRS Report

I have a Report where I need to Hide Duplicates but unfortunately I now have white space in the Returned Data where the Duplicate Records used to be.

How do I remedy this so my Report doesn't look so unprofessional?

I have searched the internet and found answers for hiding rows where there is no data, but in my report there is data that I don't want to show. I would just take it out of the Query but the way the Tables are set up that is not an option.

EDIT I am working with a Tablix, there is no ConsumeContainerWhitespace property that I have been able to find. this is not a case of an extra page being added at the end of the report on Export. I have blank spaces in between records.

EDIT 

=iif(Fields!CaseNbr.Value = Previous(Fields!CaseNbr.Value), True, False)

that is the code that I have written into the Hidden Property under Visibility in the Properties Section of The Row of Placeholders for my Data. this leaves empty Cells in the table of information where the duplicate information is being hidden.

My Table looks like this:

Name            Title
Malione         Programmer

Manny           Watchman

Upvotes: 2

Views: 33975

Answers (4)

Branston
Branston

Reputation: 1

I recently had this issue and what I found was that if I set the visibility of a rectangle to an expression and simply set the expression to =true, the rectangle shrank appropriately. I also had the report set to ConsumeContainerWhitespace although I'm not sure this is required in every case.

Upvotes: 0

rherling
rherling

Reputation: 34

The answer to your question can be found here.

http://www.sqldev.org/sql-server-reporting-services/hidden-rows-still-displayed-9660.shtml

You are likely entering your expression in the text visibility properties instead of the row group visibility. Using the row group will remove the entire row, text and white space.

Upvotes: 1

Pratik
Pratik

Reputation: 1512

To avoid the whitespaces you can use the builtin trim function and it will trim all the whitespaces. For more details of SSRS function you can refer here

Upvotes: 0

Stacia
Stacia

Reputation: 7218

This might help: http://blog.datainspirations.com/2011/03/18/the-case-of-the-extra-page/

First thing to try is the ConsumeContainerWhitespace property I mention at the end.

Upvotes: 2

Related Questions