Integrated Financials
 Tablix2 (Tablix)
Home  Diagrams  Documents  Images  Integrated Financials  Reports  Data Sources 
Current Path:  Integrated Financials   HRBudgetVsActual.rdl   Tablix2
  Properties
Property Value
DataSetName PercentageSpendingCurrentFY_Query
Top
Height 0.75in
Width 7.61458in
Style None
Left
ZIndex
Column Count 3
  Tablix Body
Body Item Body Item Content Name Content Type Content Value
Row Cell JournalToPeriodAmount Textbox =Sum(Fields!Budget_Amount.Value)
Cell JournalToPeriodAmount2 Textbox =Sum(Fields!Actuals_Amount.Value)
Cell JournalToPeriodAmount3 Textbox =Iif(IsNothing(Sum(Fields!Budget_Amount.Value)) or Sum(Fields!Budget_Amount.Value) = "0","",Sum(Fields!Actuals_Amount.Value) / Sum(Fields!Budget_Amount.Value))
Row Cell Textbox57 Textbox =Sum(Fields!Budget_Amount.Value)
Cell Textbox58 Textbox =Sum(Fields!Actuals_Amount.Value)
Cell JournalToPeriodAmount4 Textbox =Iif(IsNothing(Sum(Fields!Budget_Amount.Value)) or Sum(Fields!Budget_Amount.Value) = "0","",Sum(Fields!Actuals_Amount.Value) / Sum(Fields!Budget_Amount.Value))
  Row Hierarchy
Row Item Member Item Name/Count Expression Type Name Value
Member Group Hr_Time_Status =Fields!Hr_Time_Status.Value
Header Textbox Hr_Time_Status =Fields!Hr_Time_Status.Value
  Column Hierarchy
Row Item Member Item Name/Count Expression Type Name Value
Member Header Textbox Textbox37 Budget
Member Header Textbox Textbox2 YTD Spent
Member Header Textbox Textbox7 Percentage
Powered by BI Documenter