I am new to reporting services and I need to do a "suppress row" function as
used in Crystal Reports.

I need to hide or suppress an entire row based on a conditional expression.
For example, and expression would read =Iif(Fields!sample.value=0, suppress
row, don't suppress row) Thanks for your help.

Don

I get an error message with my syntax. I tried

=Iif(Fields!sample.value="N/A", TRUE)

and it is reporting "Not a valid value". Do I need to convert the data type
or something? Thanks.

Don



[quoted text, click to view]

Never mind. I thought it working now. Thnaks everyone.

Don

[quoted text, click to view]

[quoted text, click to view]

Hi dbj,
Just set the Visible property for your row using the expression above and
you are done.

Regards,

--
Martin Kulov
http://www.codeattest.com/blogs/martin

MCAD Charter Member
MCSD.NET Early Achiever
MCSD

Martin,

we are having problem in suppresing the row in matrix.
unfortunately, in matrix visibility property isn't availble when row is
selected.
only if text boxes within the row are selected - the visibility property
appears.
when we place the condition in the hidden propetry- the row would appear to
be empty, but the row isn't supressed. The empty space still is there. Do you
know how to get rid of the empty space?

Example:
What we have is:
01/01/2000 02/01/2000 03/01/2000
Fee 1 2 3
Accel 0 0 0
Repro 4 5 6

What we need is:
01/01/2000 02/01/2000 03/01/2000
Fee 1 2 3
Repro 4 5 6

What we get is when setting hidden property to true when it's 0:
01/01/2000 02/01/2000 03/01/2000
Fee 1 2 3

Repro 4 5 6

Thanks in advance.











[quoted text, click to view]