Post reply

iterating through table control in report...

  • February 19, 2009 at 10:44 am

    #206725

    hi there,

    I am using a table control in my report. Here, For one of the fields, I want to get following:

    This field shows overAge indicator for students for each grade. I am calculating this field in SQL Query.It can have any Integer values.

    So, it can have values like 0 if student is not overage.. Or it can contain values like 1 ,2 etc as well.

    I have a table footer where I am getting total( OR summary) of indicators. For this particular field, If there is any value greater than 1 then I wanna display 'X' in the summary footer. If not, then it would remain blank.

    Sample values:

    Student1 Student2 Student3

    grade overage Overage Overage

    02 0 1 1

    03 0 1 2

    04 1 1 2

    ----- ------- -----

    [blank] [blank] X

    I am trying to figure out how can I do this?

    I tried using:

    =IIF(fields!YearsOverage.Value>1,"X","")

    But this doesn't work ..

    please advise.

    Thanks!

  • February 19, 2009 at 12:47 pm

    #947054

    sql-oholic (2/19/2009)

    hi there,

    I am using a table control in my report. Here, For one of the fields, I want to get following:

    This field shows overAge indicator for students for each grade. I am calculating this field in SQL Query.It can have any Integer values.

    So, it can have values like 0 if student is not overage.. Or it can contain values like 1 ,2 etc as well.

    I have a table footer where I am getting total( OR summary) of indicators. For this particular field, If there is any value greater than 1 then I wanna display 'X' in the summary footer. If not, then it would remain blank.

    Sample values:

    Student1 Student2 Student3

    grade overage Overage Overage

    02 0 1 1

    03 0 1 2

    04 1 1 2

    ----- ------- -----

    [blank] [blank] X

    I am trying to figure out how can I do this?

    I tried using:

    =IIF(fields!YearsOverage.Value>1,"X","")

    But this doesn't work ..

    please advise.

    Thanks!

    Try changing your IF logic to =IIF(SUM(fields!YearsOverage.Value) > 1,"X","")

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply