February 19, 2009 at 10:44 am
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!
February 19, 2009 at 12:47 pm
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