Row |
Cell |
Textbox40 |
Textbox |
Count |
|
Cell |
Textbox1 |
Textbox |
Reference Number |
|
Cell |
Textbox3 |
Textbox |
Course Id |
|
Cell |
Textbox5 |
Textbox |
Class Title |
|
Cell |
Textbox7 |
Textbox |
Campus |
|
Cell |
Textbox20 |
Textbox |
Session |
|
Cell |
Textbox22 |
Textbox |
Class Status |
|
Cell |
Textbox13 |
Textbox |
Enrollment |
|
Cell |
Textbox11 |
Textbox |
Max Size |
|
Cell |
Textbox9 |
Textbox |
Occupancy |
Row |
Cell |
Textbox41 |
Textbox |
=RowNumber("dsClassCapacityDetails") |
|
Cell |
Reference_Number |
Textbox |
=Fields!Reference_Number.Value |
|
Cell |
Course_Id |
Textbox |
=Fields!Course_Id.Value |
|
Cell |
Class_Title |
Textbox |
=Fields!Class_Title.Value |
|
Cell |
Campus |
Textbox |
=Fields!Campus.Value |
|
Cell |
Session |
Textbox |
=Fields!Session.Value |
|
Cell |
Class_Status |
Textbox |
=Fields!Class_Status.Value |
|
Cell |
Enrollment |
Textbox |
=Fields!Enrollment.Value |
|
Cell |
Maximum_Class_Size |
Textbox |
=CInt(Fields!Maximum_Class_Size.Value) |
|
Cell |
Textbox10 |
Textbox |
=IIF(IsNothing(Fields!Enrollment.Value)
, 0, IIF(IsNothing(Fields!Maximum_Class_Size.Value) OR Fields!Maximum_Class_Size.Value = 0, 1 ,Fields!Enrollment.Value / Fields!Maximum_Class_Size.Value
)
) |
Row |
Cell |
Textbox42 |
Textbox |
|
|
Cell |
Textbox28 |
Textbox |
|
|
Cell |
Textbox29 |
Textbox |
|
|
Cell |
Textbox30 |
Textbox |
|
|
Cell |
Textbox31 |
Textbox |
|
|
Cell |
Textbox32 |
Textbox |
|
|
Cell |
Textbox35 |
Textbox |
|
|
Cell |
Textbox36 |
Textbox |
=Sum(Fields!Enrollment.Value) |
|
Cell |
Textbox37 |
Textbox |
=Sum(CInt(Fields!Maximum_Class_Size.Value), "dsClassCapacityDetails") |
|
Cell |
Textbox38 |
Textbox |
=Sum(Fields!Enrollment.Value)
/
Sum(CInt(Fields!Maximum_Class_Size.Value),
"dsClassCapacityDetails") |