Reporting Service Table control - question...is this possible?!?

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