iterating through table control in report...

  • 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 OverageOverage

    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!

  • 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 OverageOverage

    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