CODEWITHSUNDEEP
reporting-servicesheightreportssrs-2008-r2ssrs-2012
Stanislovas Kalašnikovas
Stanislovas Kalašnikovas

Reputation: 9053

SSRS. How to change height of row via expression?

I'm creating report with MS Visual Studio 2012. How to change rows width dynamically (via expression)?

Should be something like this: IFF(Visible.False) THEN (row.Height = 0)

What I'm trying to achive? I'm using expression to hide cells If they are empty. If all cells in row are empty should change row's width to 0.

This is how It looks for now (pink are hidden rows): ![hidden rows][1]

And this is how It should be:

![hidden rows should be][2]

In design It looks like:

![design][3]

As you see here are 2 rows. If [Tikrinimas2] and [Tikrinimas3] are nulls hidding first row in other way second row is hidden.

Upvotes: 3

Views: 6171

Answers (2)

Rednaxel
Rednaxel

Reputation: 968

you can't change the height of a row with expressions, but you can hide rows or columns.

Check this out SSRS 2008:How to hide a table row (Conditionally) based on category field

Upvotes: 1

mindparse
mindparse

Reputation: 7225

Rather than trying to set the row height dynamically, you can set an expression on the Hidden property of the second row in designer. Something like this:

=IIF(isNothing(Fields!Tikrinimas2.Value), TRUE, FALSE)

That should do the job for you.

Upvotes: 2

Related Questions