Integrated Financials
 Tablix2 (Tablix)
Home  Diagrams  Documents  Images  Integrated Financials  Reports  Data Sources 
Current Path:  Integrated Financials   Monthly_Accumulators_GLC.rdl   Tablix2
  Properties
Property Value
DataSetName Monthly_Accumulator_Query
Top 0.74875in
Height 2.25in
Width 16.55456in
Style None
Left
ZIndex 1
Column Count 15
  Tablix Body
Body Item Body Item Content Name Content Type Content Value
Row Cell Textbox154 Textbox =Sum(Fields!Budget_Amount.Value)
Cell Jul_Amt Textbox =Sum(Fields!Jul_Amt.Value)
Cell Aug_Amt Textbox =Sum(Fields!Aug_Amt.Value)
Cell Sep_Amt Textbox =Sum(Fields!Sep_Amt.Value)
Cell Oct_Amt Textbox =Sum(Fields!Oct_Amt.Value)
Cell Nov_Amt Textbox =Sum(Fields!Nov_Amt.Value)
Cell Dec_Amt Textbox =Sum(Fields!Dec_Amt.Value)
Cell Jan_Amt Textbox =Sum(Fields!Jan_Amt.Value)
Cell Feb_Amt Textbox =Sum(Fields!Feb_Amt.Value)
Cell Mar_Amt Textbox =Sum(Fields!Mar_Amt.Value)
Cell Apr_Amt Textbox =Sum(Fields!Apr_Amt.Value)
Cell May_Amt Textbox =Sum(Fields!May_Amt.Value)
Cell Jun_Amt Textbox =Sum(Fields!Jun_Amt.Value)
Cell Textbox88 Textbox =IIF(IsNothing(SUM(Fields!Summary_Amount.Value)),0,SUM(Fields!Summary_Amount.Value))
Cell Textbox92 Textbox =Sum(Fields!Budget_Amount.Value) - SUM(Fields!Summary_Amount.Value)
Row Cell Textbox257 Textbox =Sum(Fields!Budget_Amount.Value,"Glc1")
Cell Jul_Amt2 Textbox =Sum(Fields!Jul_Amt.Value)
Cell Aug_Amt2 Textbox =Sum(Fields!Aug_Amt.Value)
Cell Sep_Amt2 Textbox =Sum(Fields!Sep_Amt.Value)
Cell Oct_Amt2 Textbox =Sum(Fields!Oct_Amt.Value)
Cell Nov_Amt2 Textbox =Sum(Fields!Nov_Amt.Value)
Cell Dec_Amt2 Textbox =Sum(Fields!Dec_Amt.Value)
Cell Jan_Amt2 Textbox =Sum(Fields!Jan_Amt.Value)
Cell Feb_Amt2 Textbox =Sum(Fields!Feb_Amt.Value)
Cell Mar_Amt2 Textbox =Sum(Fields!Mar_Amt.Value)
Cell Apr_Amt2 Textbox =Sum(Fields!Apr_Amt.Value)
Cell May_Amt2 Textbox =Sum(Fields!May_Amt.Value)
Cell Jun_Amt2 Textbox =Sum(Fields!Jun_Amt.Value)
Cell Textbox259 Textbox =IIF(IsNothing(SUM(Fields!Summary_Amount.Value)),0,SUM(Fields!Summary_Amount.Value))
Cell Textbox260 Textbox =Sum(Fields!Budget_Amount.Value,"Glc1") - SUM(Fields!Summary_Amount.Value)
Row Cell Textbox238 Textbox
Cell Textbox13 Textbox =IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Glc1")) or Sum(Fields!Budget_Amount.Value, "Glc1") = 0, 0, Sum(Fields!Jul_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Glc1"))
Cell Textbox15 Textbox =IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Glc1")) Or Sum(Fields!Budget_Amount.Value, "Glc1") = 0, 0, Sum(Fields!Aug_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Glc1"))
Cell Textbox20 Textbox =IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Glc1")) Or Sum(Fields!Budget_Amount.Value, "Glc1") = 0, 0, Sum(Fields!Sep_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Glc1"))
Cell Textbox21 Textbox =IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Glc1")) or Sum(Fields!Budget_Amount.Value, "Glc1") = 0, 0, Sum(Fields!Oct_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Glc1"))
Cell Textbox22 Textbox =IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Glc1")) or Sum(Fields!Budget_Amount.Value, "Glc1") = 0, 0, Sum(Fields!Nov_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Glc1"))
Cell Textbox24 Textbox =IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Glc1")) or Sum(Fields!Budget_Amount.Value, "Glc1") = 0, 0, Sum(Fields!Dec_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Glc1"))
Cell Textbox28 Textbox =IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Glc1")) or Sum(Fields!Budget_Amount.Value, "Glc1") = 0, 0, Sum(Fields!Jan_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Glc1"))
Cell Textbox29 Textbox =IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Glc1")) or Sum(Fields!Budget_Amount.Value, "Glc1") = 0, 0, Sum(Fields!Feb_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Glc1"))
Cell Textbox31 Textbox =IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Glc1")) or Sum(Fields!Budget_Amount.Value, "Glc1") = 0, 0, Sum(Fields!Mar_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Glc1"))
Cell Textbox32 Textbox =IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Glc1")) or Sum(Fields!Budget_Amount.Value, "Glc1") = 0, 0, Sum(Fields!Apr_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Glc1"))
Cell Textbox33 Textbox =IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Glc1")) or Sum(Fields!Budget_Amount.Value, "Glc1") = 0, 0, Sum(Fields!May_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Glc1"))
Cell Textbox35 Textbox =IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Glc1")) or Sum(Fields!Budget_Amount.Value, "Glc1") = 0, 0, Sum(Fields!Jun_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Glc1"))
Cell Textbox240 Textbox =IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Glc1")) or Sum(Fields!Budget_Amount.Value, "Glc1") = 0, 0, Sum(Fields!Summary_Amount.Value) / Sum(Fields!Budget_Amount.Value, "Glc1"))
Cell Textbox241 Textbox =IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Glc1")) or Sum(Fields!Budget_Amount.Value, "Glc1") = 0, 0, (Sum(Fields!Budget_Amount.Value, "Glc1") - Sum(Fields!Summary_Amount.Value)) / Sum(Fields!Budget_Amount.Value, "Glc1"))
Row Cell Textbox322 Textbox
Cell Textbox14 Textbox
Cell Textbox23 Textbox
Cell Textbox34 Textbox
Cell Textbox43 Textbox
Cell Textbox52 Textbox
Cell Textbox63 Textbox
Cell Textbox77 Textbox
Cell Textbox97 Textbox
Cell Textbox106 Textbox
Cell Textbox115 Textbox
Cell Textbox124 Textbox
Cell Textbox133 Textbox
Cell Textbox324 Textbox
Cell Textbox325 Textbox
Row Cell Textbox267 Textbox =Sum(Fields!Budget_Amount.Value,"Gl_Class_Code")
Cell Jul_Amt4 Textbox =Sum(Fields!Jul_Amt.Value)
Cell Aug_Amt4 Textbox =Sum(Fields!Aug_Amt.Value)
Cell Sep_Amt4 Textbox =Sum(Fields!Sep_Amt.Value)
Cell Oct_Amt4 Textbox =Sum(Fields!Oct_Amt.Value)
Cell Nov_Amt4 Textbox =Sum(Fields!Nov_Amt.Value)
Cell Dec_Amt4 Textbox =Sum(Fields!Dec_Amt.Value)
Cell Jan_Amt4 Textbox =Sum(Fields!Jan_Amt.Value)
Cell Feb_Amt4 Textbox =Sum(Fields!Feb_Amt.Value)
Cell Mar_Amt4 Textbox =Sum(Fields!Mar_Amt.Value)
Cell Apr_Amt4 Textbox =Sum(Fields!Apr_Amt.Value)
Cell May_Amt4 Textbox =Sum(Fields!May_Amt.Value)
Cell Jun_Amt4 Textbox =Sum(Fields!Jun_Amt.Value)
Cell Textbox269 Textbox =SUM(Fields!Summary_Amount.Value,"Gl_Class_Code")
Cell Textbox270 Textbox =Sum(Fields!Budget_Amount.Value,"Gl_Class_Code") - SUM(Fields!Summary_Amount.Value,"Gl_Class_Code")
Row Cell Textbox242 Textbox
Cell Textbox16 Textbox =IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Gl_Class_Code")) or Sum(Fields!Budget_Amount.Value, "Gl_Class_Code") = 0, 0, Sum(Fields!Jul_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Gl_Class_Code"))
Cell Textbox25 Textbox =IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Gl_Class_Code")) or Sum(Fields!Budget_Amount.Value, "Gl_Class_Code") = 0, 0, Sum(Fields!Aug_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Gl_Class_Code"))
Cell Textbox36 Textbox =IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Gl_Class_Code")) or Sum(Fields!Budget_Amount.Value, "Gl_Class_Code") = 0, 0, Sum(Fields!Sep_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Gl_Class_Code"))
Cell Textbox45 Textbox =IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Gl_Class_Code")) or Sum(Fields!Budget_Amount.Value, "Gl_Class_Code") = 0, 0, Sum(Fields!Oct_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Gl_Class_Code"))
Cell Textbox54 Textbox =IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Gl_Class_Code")) or Sum(Fields!Budget_Amount.Value, "Gl_Class_Code") = 0, 0, Sum(Fields!Nov_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Gl_Class_Code"))
Cell Textbox67 Textbox =IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Gl_Class_Code")) or Sum(Fields!Budget_Amount.Value, "Gl_Class_Code") = 0, 0, Sum(Fields!Dec_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Gl_Class_Code"))
Cell Textbox84 Textbox =IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Gl_Class_Code")) or Sum(Fields!Budget_Amount.Value, "Gl_Class_Code") = 0, 0, Sum(Fields!Jan_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Gl_Class_Code"))
Cell Textbox99 Textbox =IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Gl_Class_Code")) or Sum(Fields!Budget_Amount.Value, "Gl_Class_Code") = 0, 0, Sum(Fields!Feb_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Gl_Class_Code"))
Cell Textbox108 Textbox =IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Gl_Class_Code")) or Sum(Fields!Budget_Amount.Value, "Gl_Class_Code") = 0, 0, Sum(Fields!Mar_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Gl_Class_Code"))
Cell Textbox117 Textbox =IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Gl_Class_Code")) or Sum(Fields!Budget_Amount.Value, "Gl_Class_Code") = 0, 0, Sum(Fields!Apr_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Gl_Class_Code"))
Cell Textbox126 Textbox =IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Gl_Class_Code")) or Sum(Fields!Budget_Amount.Value, "Gl_Class_Code") = 0, 0, Sum(Fields!May_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Gl_Class_Code"))
Cell Textbox135 Textbox =IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Gl_Class_Code")) or Sum(Fields!Budget_Amount.Value, "Gl_Class_Code") = 0, 0, Sum(Fields!Jun_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Gl_Class_Code"))
Cell Textbox230 Textbox =IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Gl_Class_Code")) or Sum(Fields!Budget_Amount.Value, "Gl_Class_Code") = 0, 0, Sum(Fields!Summary_Amount.Value,"Gl_Class_Code") / Sum(Fields!Budget_Amount.Value, "Gl_Class_Code"))
Cell Textbox231 Textbox =IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Gl_Class_Code")) or Sum(Fields!Budget_Amount.Value, "Gl_Class_Code") = 0, 0, (Sum(Fields!Budget_Amount.Value, "Gl_Class_Code") - Sum(Fields!Summary_Amount.Value)) / Sum(Fields!Budget_Amount.Value, "Gl_Class_Code"))
Row Cell Textbox312 Textbox
Cell Textbox17 Textbox
Cell Textbox26 Textbox
Cell Textbox37 Textbox
Cell Textbox46 Textbox
Cell Textbox55 Textbox
Cell Textbox69 Textbox
Cell Textbox85 Textbox
Cell Textbox100 Textbox
Cell Textbox109 Textbox
Cell Textbox118 Textbox
Cell Textbox127 Textbox
Cell Textbox136 Textbox
Cell Textbox314 Textbox
Cell Textbox315 Textbox
Row Cell Textbox156 Textbox Budget
Cell Textbox11 Textbox July
Cell Textbox40 Textbox August
Cell Textbox41 Textbox September
Cell Textbox42 Textbox October
Cell Textbox49 Textbox November
Cell Textbox58 Textbox December
Cell Textbox73 Textbox January
Cell Textbox93 Textbox February
Cell Textbox103 Textbox March
Cell Textbox112 Textbox April
Cell Textbox121 Textbox May
Cell Textbox130 Textbox June
Cell Textbox90 Textbox Actual
Cell Textbox94 Textbox Balance
  Row Hierarchy
Row Item Member Item Name/Count Expression Type Name Value
Member Group Gl_Class_Code =Fields!Gl_Class_Code.Value
  Column Hierarchy
Row Item Member Item Name/Count Expression Type Name Value
Member Header Textbox Textbox153 Budget
Member Header Textbox Textbox10 July
Member Header Textbox Textbox19 August
Member Header Textbox Textbox30 September
Member Header Textbox Textbox39 October
Member Header Textbox Textbox48 November
Member Header Textbox Textbox57 December
Member Header Textbox Textbox71 January
Member Header Textbox Textbox89 February
Member Header Textbox Textbox102 March
Member Header Textbox Textbox111 April
Member Header Textbox Textbox120 May
Member Header Textbox Textbox129 June
Member Header Textbox Textbox87 Actual
Member Header Textbox Textbox91 Balance
Powered by BI Documenter