SSRS Conditionally remove rows from a table

visual-studio-2010 reporting-services properties rows ssrs-tablix
SteveAnselment picture SteveAnselment · Oct 4, 2013 · Viewed 9.6k times · Source

enter image description here

Preview Mode as is now

I am new to SSRS and need to get this working for my project(work not school)

I have implemented the data to be hidden on expression 

=IIF(Fields!Offset1.Value = "",true,false)

Problem is that It leaves the empty space where those values would have been in my Report. I need the space to disappear too. Any help would be GREATLY appreciated!!

EDIT: Forgot to mention that I am getting my data from a MS Access DB (if that matters)

Answer

SteveAnselment picture SteveAnselment · Oct 4, 2013

After much head scratching and thinking about it differently. @django made me think visibility not hidden properties. I righ clicked the row header tab and clicked on the Row Visability... option. That brings up the Change display options dialog box. I selected the Show or hide based on an expression andthen the fx button to build the expression. The expression i used was

=IIF(ISNOTHING(Fields!Offset1.value),true,false)

clicked OK

Ran Preview and this is what i got as a result: Finished Product!!

Related questions

I lost datasets pane in Visual Studio

I'm developing a report in the Business Intelligence studio and I lost my dataset. The pane was near toolbox, and it is gone. What is the name of the pane I should to reopen?

Read More
SSRS error on preview : "The size necessary to buffer the XML content exceeded the buffer quota" hides original error

I understand that there is definitely something wrong with my report (e.g. columns missmatcch) and I need to correct it but what I see is the WCF error message that hides actual problem and exactly this hiding irritates me …

Read More
How I can format date in report to appear exactly as I want - RDLC

I have a report in my application and this report will show a long date from db and I used this expression to make it shorter: =FormatDateTime(Fields!StatementDate.Value,DateFormat.ShortDate) and the date will show like this : 1/1/2010 I …

Read More