Enrollment
 Tablix1 (Tablix)
Home  Diagrams  Documents  Images  Enrollment  Reports  Data Sources 
Current Path:  Enrollment   FTE Summary Report.rdl   Tablix1
  Properties
Property Value
DataSetName FTESummary
Top 1.31125in
Height 1.25in
Width 19.72916in
Style None
Left 0.31126in
ZIndex
Column Count 15
  Tablix Body
Body Item Body Item Content Name Content Type Content Value
Row Cell Textbox17 Textbox Enrolled FTE
Cell Textbox12 Textbox Enrolled FTE Prior Year Term
Cell Textbox19 Textbox FTE Difference
Cell Textbox24 Textbox FTE Difference %
Cell Textbox1 Textbox EOT FTE
Cell Textbox6 Textbox Paid Enrolled FTE
Cell Textbox29 Textbox Paid Enrolled FTE Prior Year Term
Cell Textbox34 Textbox Paid FTE Difference
Cell Textbox5 Textbox Paid FTE % Difference
Cell Textbox40 Textbox EOT Paid Full Time Equivalent
Cell Textbox45 Textbox Headcount
Cell Textbox50 Textbox Headcount Prior Year Term
Cell Textbox65 Textbox Headcount Difference
Cell Textbox70 Textbox Headcount % Difference
Cell Textbox55 Textbox EOT Headcount
Row Cell Textbox120 Textbox =Sum(Fields!Full_Time_Equivalent.Value)
Cell Textbox14 Textbox =Sum(Fields!Prior_Full_Time_Equivalent.Value)
Cell Textbox20 Textbox =Sum(Fields!FTEDifference.Value)
Cell Textbox25 Textbox =IIf(IsNothing(sum(Fields!Prior_Full_Time_Equivalent.Value)), "", sum(Fields!FTEDifference.Value) / sum(Fields!Prior_Full_Time_Equivalent.Value))
Cell Textbox2 Textbox =Sum(Fields!EOT_Full_Time_Equivalent.Value)
Cell Textbox8 Textbox =Sum(Fields!Paid_Full_Time_Equivalent.Value)
Cell Textbox30 Textbox =Sum(Fields!Prior_Paid_Full_Time_Equivalent.Value)
Cell Textbox35 Textbox =Sum(Fields!PaidFTEDifference.Value)
Cell Textbox23 Textbox =IIf(IsNothing(sum(Fields!Prior_Paid_Full_Time_Equivalent.Value)), "", sum(Fields!PaidFTEDifference.Value) / sum(Fields!Prior_Paid_Full_Time_Equivalent.Value))
Cell Textbox41 Textbox =Sum(Fields!EOT_Paid_Full_Time_Equivalent.Value)
Cell Textbox46 Textbox =Sum(Fields!Headcount.Value)
Cell Textbox51 Textbox =Sum(Fields!Prior_Headcount.Value)
Cell Textbox66 Textbox =Sum(Fields!HeadcountDifference.Value)
Cell Textbox71 Textbox =IIf(IsNothing(sum(Fields!Prior_Headcount.Value)), "", sum(Fields!HeadcountDifference.Value) / sum(Fields!Prior_Headcount.Value))
Cell Textbox56 Textbox =Sum(Fields!EOT_Headcount.Value)
Row Cell Textbox111 Textbox =Sum(Fields!Full_Time_Equivalent.Value)
Cell Textbox15 Textbox =Sum(Fields!Prior_Full_Time_Equivalent.Value)
Cell Textbox21 Textbox =Sum(Fields!FTEDifference.Value)
Cell Textbox26 Textbox =IIf(IsNothing(sum(Fields!Prior_Full_Time_Equivalent.Value)), "", sum(Fields!FTEDifference.Value) / sum(Fields!Prior_Full_Time_Equivalent.Value))
Cell Textbox3 Textbox =Sum(Fields!EOT_Full_Time_Equivalent.Value)
Cell Textbox10 Textbox =Sum(Fields!Paid_Full_Time_Equivalent.Value)
Cell Textbox31 Textbox =Sum(Fields!Prior_Paid_Full_Time_Equivalent.Value)
Cell Textbox36 Textbox =Sum(Fields!PaidFTEDifference.Value)
Cell Textbox33 Textbox =IIf(IsNothing(sum(Fields!Prior_Paid_Full_Time_Equivalent.Value)), "", sum(Fields!PaidFTEDifference.Value) / sum(Fields!Prior_Paid_Full_Time_Equivalent.Value))
Cell Textbox42 Textbox =Sum(Fields!EOT_Paid_Full_Time_Equivalent.Value)
Cell Textbox47 Textbox =Sum(Fields!Headcount.Value)
Cell Textbox52 Textbox =Sum(Fields!Prior_Headcount.Value)
Cell Textbox67 Textbox =Sum(Fields!HeadcountDifference.Value)
Cell Textbox72 Textbox =IIf(IsNothing(sum(Fields!Prior_Headcount.Value)), "", sum(Fields!HeadcountDifference.Value) / sum(Fields!Prior_Headcount.Value))
Cell Textbox57 Textbox =Sum(Fields!EOT_Headcount.Value)
Row Cell Textbox102 Textbox =Sum(Fields!Full_Time_Equivalent.Value)
Cell Textbox16 Textbox =Sum(Fields!Prior_Full_Time_Equivalent.Value)
Cell Textbox22 Textbox =Sum(Fields!FTEDifference.Value)
Cell Textbox27 Textbox =IIf(IsNothing(sum(Fields!Prior_Full_Time_Equivalent.Value)), "", sum(Fields!FTEDifference.Value) / sum(Fields!Prior_Full_Time_Equivalent.Value))
Cell Textbox4 Textbox =Sum(Fields!EOT_Full_Time_Equivalent.Value)
Cell Textbox18 Textbox =Sum(Fields!Paid_Full_Time_Equivalent.Value)
Cell Textbox32 Textbox =Sum(Fields!Prior_Paid_Full_Time_Equivalent.Value)
Cell Textbox37 Textbox =Sum(Fields!PaidFTEDifference.Value)
Cell Textbox38 Textbox =IIf(IsNothing(sum(Fields!Prior_Paid_Full_Time_Equivalent.Value)), "", sum(Fields!PaidFTEDifference.Value) / sum(Fields!Prior_Paid_Full_Time_Equivalent.Value))
Cell Textbox43 Textbox =Sum(Fields!EOT_Paid_Full_Time_Equivalent.Value)
Cell Textbox48 Textbox =Sum(Fields!Headcount.Value)
Cell Textbox53 Textbox =Sum(Fields!Prior_Headcount.Value)
Cell Textbox68 Textbox =Sum(Fields!HeadcountDifference.Value)
Cell Textbox73 Textbox =IIf(IsNothing(sum(Fields!Prior_Headcount.Value)), "", sum(Fields!HeadcountDifference.Value) / sum(Fields!Prior_Headcount.Value))
Cell Textbox58 Textbox =Sum(Fields!EOT_Headcount.Value)
Row Cell Textbox126 Textbox =Sum(Fields!Full_Time_Equivalent.Value)
Cell Prior_Full_Time_Equivalent Textbox =Sum(Fields!Prior_Full_Time_Equivalent.Value)
Cell FTEDifference Textbox =Sum(Fields!FTEDifference.Value)
Cell Textbox28 Textbox =IIf(IsNothing(sum(Fields!Prior_Full_Time_Equivalent.Value)), "", sum(Fields!FTEDifference.Value) / sum(Fields!Prior_Full_Time_Equivalent.Value))
Cell EOT_Full_Time_Equivalent Textbox =Sum(Fields!EOT_Full_Time_Equivalent.Value)
Cell Paid_Full_Time_Equivalent Textbox =Sum(Fields!Paid_Full_Time_Equivalent.Value)
Cell Prior_Paid_Full_Time_Equivalent Textbox =Sum(Fields!Prior_Paid_Full_Time_Equivalent.Value)
Cell PaidFTEDifference Textbox =Sum(Fields!PaidFTEDifference.Value)
Cell Textbox39 Textbox =IIf(IsNothing(sum(Fields!Prior_Paid_Full_Time_Equivalent.Value)), "", sum(Fields!PaidFTEDifference.Value) / sum(Fields!Prior_Paid_Full_Time_Equivalent.Value))
Cell EOT_Paid_Full_Time_Equivalent Textbox =Sum(Fields!EOT_Paid_Full_Time_Equivalent.Value)
Cell Headcount Textbox =Sum(Fields!Headcount.Value)
Cell Prior_Headcount Textbox =Sum(Fields!Prior_Headcount.Value)
Cell HeadcountDifference Textbox =Sum(Fields!HeadcountDifference.Value)
Cell Textbox74 Textbox =IIf(IsNothing(sum(Fields!Prior_Headcount.Value)), "", sum(Fields!HeadcountDifference.Value) / sum(Fields!Prior_Headcount.Value))
Cell EOT_Headcount Textbox =Sum(Fields!EOT_Headcount.Value)
  Row Hierarchy
Row Item Member Item Name/Count Expression Type Name Value
Member Header Textbox Textbox7 FTE Classification
Member Group FTE_Classification =Fields!FTE_Classification.Value
  Column Hierarchy
Row Item Member Item Name/Count Expression Type Name Value
Member
Member
Member
Member
Member
Member
Member
Member
Member
Member
Member
Member
Member
Member
Member
Powered by BI Documenter