Trying to Get Rid of White Space in SSRS Report

reporting-servicesssrs-2008

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

Best Answer

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.

Related Solutions

SSRS no data in report

A tablix object is related to the underlying dataset, so if there's no data, there's no table in the output.

Other than using the NowRowsMessage property, the only other way I can think of to enforce this would be to ensure your query returns an empty value placeholder when there are now rows returned. This way you would have, in essence, a single data row.

You could then try and add a conditional expression on the table (i.e. on the Visibility property of the details row) to prevent any rows containing your placeholder from showing up.

So in your query you could have:

IF (@@ROWCOUNT= 0)
BEGIN

SELECT 
'[IAMEMPTY]' as [Col1]
,'[IAMEMPTY]' as [Col2]
,'[IAMEMPTY]' as [Col3]

END

And then in the Visibility property of your table's detail row:

=Iif(Fields!Col1.Value = "[IAMEMPTY]",True,False)

EDIT: Alternatively, to check if the DataSet is empty in SSRS and show a rectangle containing your message/headers (as mentioned in TooSik's comment), you could set up a rectangle with this in the Visibility expression:

=Iif(Rownumber("Dataset_Name")=0, False,True)

Sql-server – Tablix: Repeat header rows on each page not working – Report Builder 3.0

It depends on the tablix structure you are using. In a table, for example, you do not have column groups, so Reporting Services does not recognize which textboxes are the column headers and setting RepeatColumnHeaders property to True doesn't work.

Instead, you need to:

Open Advanced Mode in the Groupings pane. (Click the arrow to the right of the Column Groups and select Advanced Mode.)
In the Row Groups area (not Column Groups), click on a Static group, which highlights the corresponding textbox in the tablix. Click through each Static group until it highlights the leftmost column header. This is generally the first Static group listed.
In the Properties window, set the RepeatOnNewPage property to True.
Make sure that the KeepWithGroup property is set to After.

The KeepWithGroup property specifies which group to which the static member needs to stick. If set to After then the static member sticks with the group after it, or below it, acting as a group header. If set to Before, then the static member sticks with the group before, or above it, acting as a group footer. If set to None, Reporting Services decides where to put the static member.

Now when you view the report, the column headers repeat on each page of the tablix.

This video shows how to set it exactly as the answer described.

Related Topic

SSRS 2008 Removing white space when hiding elements