Hi, on my local SSRS (RDLC), I have a table which presents several
items, however these are not sequential data from a table on my DB, are
fields of only one row of a table on my DB. More specificly, I have a
table with the fields issue1, description1, issue2,
description2...until 6! I want to present those fields six times (the
same times as they appear on the DB), however, I only want them to
appear is the issuex (which is an integer) is greater than 0. So to
guarantee that each field only appears one time, I do this:
=First(Fields!issue1.Value)
to each table line
And
what I want to do on each line is IIF(Fields!issue1.Value >
0,True,False) to make that line visible or not, however, if I apply
this to a line it automatically applies it to the complete table, and
if only one of this conditions returns false the complete table becomes
invisible.
Is there anyway to make this work dynamically?!?Thanks a lot!
The first mistake in your hidden expression is that your true and false results are exchanged. As per your first sentence, you want to show the row when issue>0 which means hidden should be false. so your hidden expression for table row should like this: IIf(Fields!issue1.Value>0, false, true)
To achieve the result you want, create 6 table detail rows and control the visibility of these rows based on the corresponding issue number. For example, first row will check for issue1 > 0, second row will check for issue 2 >0 etc until 6th row..
Shyam
