0RSDS_EnterpriseDW_SSASNone95e0f472-c858-414f-a622-ca1d5b24daa5RSDS_EnterpriseDWNone7b945d79-7e23-4349-9363-1c3a7b045fcaRSDS_EnterpriseDW_SSAS=Parameters!PaymentDateFiscalYear.Value=Parameters!PayableOrigin.Value SELECT NON EMPTY { [Measures].[Pay Amount] } ON COLUMNS, NON EMPTY { ([Payable].[Origin].[Origin].ALLMEMBERS * [Payable].[Reference Type].[Reference Type].ALLMEMBERS * [Payment Date].[Calendar Period].[Calendar Period].ALLMEMBERS * [Payee].[Payee Id].[Payee Id].ALLMEMBERS * [Payee].[Payee Name].[Payee Name].ALLMEMBERS * [Payment Date].[Date Name].[Date Name].ALLMEMBERS * [Payable].[Reference Number].[Reference Number].ALLMEMBERS * [Payable].[Payment Type].[Payment Type].ALLMEMBERS * [Payable].[Payment Type Number].[Payment Type Number].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( { [Payee].[Payee Type Code].&[S] } ) ON COLUMNS FROM ( SELECT ( { [Payable].[Payable Status Code].&[PD] } ) ON COLUMNS FROM ( SELECT ( STRTOSET(@PayableOrigin, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@PaymentDateFiscalYear, CONSTRAINED) ) ON COLUMNS FROM [PayablesPurchaseOrder])))) WHERE ( IIF( STRTOSET(@PaymentDateFiscalYear, CONSTRAINED).Count = 1, STRTOSET(@PaymentDateFiscalYear, CONSTRAINED), [Payment Date].[Fiscal Year].currentmember ), [Payable].[Payable Status Code].&[PD], [Payee].[Payee Type Code].&[S] ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGSMDXPayablesPurchaseOrder[Payment Date].[Fiscal Year][Payment Date].[Fiscal Year].&[FY 2013]true[Payable].[Origin][Payable].[Origin].[All]true[Payable].[Payable Status Code][Payable].[Payable Status Code].&[PD][Payee].[Payee Type Code][Payee].[Payee Type Code].&[S] SELECT NON EMPTY { [Measures].[Pay Amount] } ON COLUMNS, NON EMPTY { ([Payable].[Origin].[Origin].ALLMEMBERS * [Payable].[Reference Type].[Reference Type].ALLMEMBERS * [Payment Date].[Calendar Period].[Calendar Period].ALLMEMBERS * [Payee].[Payee Id].[Payee Id].ALLMEMBERS * [Payee].[Payee Name].[Payee Name].ALLMEMBERS * [Payment Date].[Date Name].[Date Name].ALLMEMBERS * [Payable].[Reference Number].[Reference Number].ALLMEMBERS * [Payable].[Payment Type].[Payment Type].ALLMEMBERS * [Payable].[Payment Type Number].[Payment Type Number].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( { [Payee].[Payee Type Code].&[S] } ) ON COLUMNS FROM ( SELECT ( { [Payable].[Payable Status Code].&[PD] } ) ON COLUMNS FROM ( SELECT ( STRTOSET(@PayableOrigin, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@PaymentDateFiscalYear, CONSTRAINED) ) ON COLUMNS FROM [PayablesPurchaseOrder])))) WHERE ( IIF( STRTOSET(@PaymentDateFiscalYear, CONSTRAINED).Count = 1, STRTOSET(@PaymentDateFiscalYear, CONSTRAINED), [Payment Date].[Fiscal Year].currentmember ), [Payable].[Payable Status Code].&[PD], [Payee].[Payee Type Code].&[S] ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGSPaymentDateFiscalYear[Payment Date].[Fiscal Year].&[FY 2013]
Payment Date.Fiscal Year
[Payment Date].[Fiscal Year]WITH MEMBER [Measures].[ParameterCaption] AS [Payment Date].[Fiscal Year].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Payment Date].[Fiscal Year].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Payment Date].[Fiscal Year].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Payment Date].[Fiscal Year].ALLMEMBERS ON ROWS FROM [PayablesPurchaseOrder]truePayableOrigin[Payable].[Origin].[All]
Origin
[Payable].[Origin]WITH MEMBER [Measures].[ParameterCaption] AS [Payable].[Origin].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Payable].[Origin].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Payable].[Origin].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Payable].[Origin].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@PaymentDateFiscalYear, CONSTRAINED) ) ON COLUMNS FROM [PayablesPurchaseOrder])WITH MEMBER [Measures].[ParameterCaption] AS [Payable].[Origin].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Payable].[Origin].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Payable].[Origin].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Payable].[Origin].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@PaymentDateFiscalYear, CONSTRAINED) ) ON COLUMNS FROM [PayablesPurchaseOrder])PaymentDateFiscalYeartrue<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Payable].[Origin].[Origin]" />System.String<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Payable].[Reference Type].[Reference Type]" />System.String<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Payee].[Payee Id].[Payee Id]" />System.String<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Payment Date].[Calendar Period].[Calendar Period]" />System.String<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Payee].[Payee Name].[Payee Name]" />System.String<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Payment Date].[Date Name].[Date Name]" />System.String<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Payable].[Payment Type].[Payment Type]" />System.String<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Payable].[Reference Number].[Reference Number]" />System.String<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[Pay Amount]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Payable].[Payment Type Number].[Payment Type Number]" />System.StringRSDS_EnterpriseDWSELECT BackgroundColor, BackgroundAlternateColor, Band1Color, Band2Color, Band3Color, Band4Color, Band5Color, Band6Color
FROM Configuration_Color
WHERE (ReportType = 'GeneralLedger')BackgroundColorSystem.StringBackgroundAlternateColorSystem.StringBand1ColorSystem.StringBand2ColorSystem.StringBand3ColorSystem.StringBand4ColorSystem.StringBand5ColorSystem.StringBand6ColorSystem.StringRSDS_EnterpriseDWSELECT ImageType, ImageLocation, SuggestedImageSize
FROM Configuration_Image
WHERE (ImageType = 'Banner')ImageTypeSystem.StringImageLocationSystem.StringSuggestedImageSizeSystem.StringRSDS_EnterpriseDW_SSASWITH MEMBER [Measures].[ParameterValue]
AS [Payment Date].[Fiscal Year].CURRENTMEMBER.UNIQUENAME
SELECT
[Measures].[ParameterValue] ON COLUMNS,
[Payment Date].[Fiscal Year].Children ON ROWS
FROM [PayablesPurchaseOrder]
WHERE [Payment Date].[Is Current Fiscal Year].&[Y]MDXQueryPayablesPurchaseOrderWITH MEMBER [Measures].[ParameterValue]
AS [Payment Date].[Fiscal Year].CURRENTMEMBER.UNIQUENAME
SELECT
[Measures].[ParameterValue] ON COLUMNS,
[Payment Date].[Fiscal Year].Children ON ROWS
FROM [PayablesPurchaseOrder]
WHERE [Payment Date].[Is Current Fiscal Year].&[Y]<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Payment Date].[Fiscal Year].[Fiscal Year]" />System.String<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterValue]" />System.Int32RSDS_EnterpriseDW_SSASWITH
MEMBER [Measures].[ParameterCaption] AS
[Date].[Fiscal Year].CurrentMember.Member_Caption
MEMBER [Measures].[ParameterValue] AS
[Date].[Fiscal Year].CurrentMember.UniqueName
MEMBER [Measures].[ParameterLevel] AS
[Date].[Fiscal Year].CurrentMember.Level.Ordinal
SELECT
{
[Measures].[ParameterCaption]
,[Measures].[ParameterValue]
,[Measures].[ParameterLevel]
} ON COLUMNS,
ORDER(
{[Date].[Fiscal Year].Children},[Measures].[ParameterCaption], DESC
) ON ROWS
FROM
(
SELECT
{
([Date].[Fiscal Year].[Fiscal Year].Members
,[Date].[Is Current Fiscal Year].&[Y]
,[Date].[Is Available For Finance].&[Y])
,
([Date].[Fiscal Year].[Fiscal Year].Members
,[Date].[Is Current Fiscal Year].Children
,[Date].[Is Available For Finance].&[Y]
)
} ON COLUMNS
FROM [Executive_Integrated_Financials]
)MDXQueryExecutive_Integrated_FinancialsWITH
MEMBER [Measures].[ParameterCaption] AS
[Date].[Fiscal Year].CurrentMember.Member_Caption
MEMBER [Measures].[ParameterValue] AS
[Date].[Fiscal Year].CurrentMember.UniqueName
MEMBER [Measures].[ParameterLevel] AS
[Date].[Fiscal Year].CurrentMember.Level.Ordinal
SELECT
{
[Measures].[ParameterCaption]
,[Measures].[ParameterValue]
,[Measures].[ParameterLevel]
} ON COLUMNS,
ORDER(
{[Date].[Fiscal Year].Children},[Measures].[ParameterCaption], DESC
) ON ROWS
FROM
(
SELECT
{
([Date].[Fiscal Year].[Fiscal Year].Members
,[Date].[Is Current Fiscal Year].&[Y]
,[Date].[Is Available For Finance].&[Y])
,
([Date].[Fiscal Year].[Fiscal Year].Members
,[Date].[Is Current Fiscal Year].Children
,[Date].[Is Available For Finance].&[Y]
)
} ON COLUMNS
FROM [Executive_Integrated_Financials]
)<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Date].[Fiscal Year].[Fiscal Year]" />System.String<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterCaption]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterValue]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterLevel]" />System.Int32=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.ValueRSDS_EnterpriseDW_SSASWITH
MEMBER [Measures].[ParameterCaption] AS
[Payment Date].[Fiscal Year].CurrentMember.Member_Caption
MEMBER [Measures].[ParameterValue] AS
[Payment Date].[Fiscal Year].CurrentMember.UniqueName
MEMBER [Measures].[ParameterLevel] AS
[Payment Date].[Fiscal Year].CurrentMember.Level.Ordinal
SELECT
{
[Measures].[ParameterCaption]
,[Measures].[ParameterValue]
,[Measures].[ParameterLevel]
} ON COLUMNS,
ORDER(
{[Payment Date].[Fiscal Year].Children},[Measures].[ParameterCaption], DESC
) ON ROWS
FROM
(
SELECT
{
([Payment Date].[Fiscal Year].[Fiscal Year].Members
,[Payment Date].[Is Current Fiscal Year].&[Y]
,[Payment Date].[Is Available For Finance].&[Y])
,
([Payment Date].[Fiscal Year].[Fiscal Year].Members
,[Payment Date].[Is Current Fiscal Year].Children
,[Payment Date].[Is Available For Finance].&[Y]
)
} ON COLUMNS
FROM [PayablesPurchaseOrder]
)MDXQueryPayablesPurchaseOrderWITH
MEMBER [Measures].[ParameterCaption] AS
[Payment Date].[Fiscal Year].CurrentMember.Member_Caption
MEMBER [Measures].[ParameterValue] AS
[Payment Date].[Fiscal Year].CurrentMember.UniqueName
MEMBER [Measures].[ParameterLevel] AS
[Payment Date].[Fiscal Year].CurrentMember.Level.Ordinal
SELECT
{
[Measures].[ParameterCaption]
,[Measures].[ParameterValue]
,[Measures].[ParameterLevel]
} ON COLUMNS,
ORDER(
{[Payment Date].[Fiscal Year].Children},[Measures].[ParameterCaption], DESC
) ON ROWS
FROM
(
SELECT
{
([Payment Date].[Fiscal Year].[Fiscal Year].Members
,[Payment Date].[Is Current Fiscal Year].&[Y]
,[Payment Date].[Is Available For Finance].&[Y])
,
([Payment Date].[Fiscal Year].[Fiscal Year].Members
,[Payment Date].[Is Current Fiscal Year].Children
,[Payment Date].[Is Available For Finance].&[Y]
)
} ON COLUMNS
FROM [PayablesPurchaseOrder]
)true<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Payment Date].[Fiscal Year].[Fiscal Year]" />System.String<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterCaption]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterValue]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterLevel]" />System.Int32=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.ValueSystem.StringRSDS_EnterpriseDW_SSAS=Parameters!PaymentDateFiscalYear.ValueWITH MEMBER [Measures].[ParameterCaption] AS [Payable].[Origin].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Payable].[Origin].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Payable].[Origin].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Payable].[Origin].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@PaymentDateFiscalYear, CONSTRAINED) ) ON COLUMNS FROM [PayablesPurchaseOrder])MDXQueryPayablesPurchaseOrderWITH MEMBER [Measures].[ParameterCaption] AS [Payable].[Origin].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Payable].[Origin].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Payable].[Origin].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Payable].[Origin].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@PaymentDateFiscalYear, CONSTRAINED) ) ON COLUMNS FROM [PayablesPurchaseOrder])PaymentDateFiscalYear[Payment Date].[Fiscal Year].&[FY 2013]
Payment Date.Fiscal Year
[Payment Date].[Fiscal Year]WITH MEMBER [Measures].[ParameterCaption] AS [Payment Date].[Fiscal Year].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Payment Date].[Fiscal Year].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Payment Date].[Fiscal Year].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Payment Date].[Fiscal Year].ALLMEMBERS ON ROWS FROM [PayablesPurchaseOrder]truetruetrue<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterCaption]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterValue]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterLevel]" />System.Int32=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.ValueSystem.StringtruetrueOriginTextbox1=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pttruetrueReference TypeTextbox3=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pttruetruePeriodTextbox2=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pttruetrueStudent IDTextbox6=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pttruetrueStudent NameTextbox18=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pttruetruePayment DateTextbox12=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pttruetrueReference NumberTextbox35=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pttruetruePayment TypeTextbox16=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pt1.25in0.25intruetrue=Sum(Fields!Pay_Amount.Value)Textbox412pt2pt2pt2pt0.25intruetrue=Sum(Fields!Pay_Amount.Value)Textbox39=First(Fields!Band3Color.Value, "GetColors")2pt2pt2pt2pt0.25intruetrue=Sum(Fields!Pay_Amount.Value)Textbox322pt2pt2pt2pt0.25intruetrue=Sum(Fields!Pay_Amount.Value)Textbox26=First(Fields!Band2Color.Value, "GetColors")2pt2pt2pt2pt0.25intruetruePayment AmountTextbox7=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pt=Fields!Origin.Value=Fields!Origin.Value1.81187intruetrue=Fields!Origin.ValueOrigin=First(Fields!Band2Color.Value, "GetColors")2pt2pt2pt2pt=Fields!Reference_Type.Value=Fields!Reference_Type.Value2.20833intruetrue=Fields!Reference_Type.ValueReference_Type2pt2pt2pt2pt=Fields!Calendar_Period.Value=Fields!Calendar_Period.Value1intruetrue=Fields!Calendar_Period.ValueCalendar_Period=First(Fields!Band3Color.Value, "GetColors")2pt2pt2pt2pt=Fields!Payee_Id.Value=Fields!Payee_Id.Value1.05208intruetrue=Fields!Payee_Id.ValuePayee_Id2pt2pt2pt2pt=Fields!Payee_Name.Value=Fields!Payee_Name.Value2.07292intruetrue=Fields!Payee_Name.ValuePayee_Name2pt2pt2pt2pt=Fields!Date_Name.Value=Fields!Date_Name.Value0.90625intruetrue=Fields!Date_Name.ValueDate_Name2pt2pt2pt2pt=Fields!Reference_Number.Value=Fields!Reference_Number.Value1.83333intruetrue=Fields!Reference_Number.ValueReference_Number2pt2pt2pt2pt=Fields!Payment_Type.Value=Fields!Payment_Type.Value1.83209intruetrue=Fields!Payment_Type.ValuePayment_Type2pt2pt2pt2pttrueCalendar_PeriodtrueReference_TypetrueCalendar_PeriodtrueCalendar_PeriodtrueCalendar_Period1.05208intruetrueTextbox40=First(Fields!Band3Color.Value, "GetColors")2pt2pt2pt2pt2.07292intruetrueTextbox21=First(Fields!Band3Color.Value, "GetColors")2pt2pt2pt2pt0.90625intruetrueTextbox27=First(Fields!Band3Color.Value, "GetColors")2pt2pt2pt2pt1.83333intruetrueTextbox28=First(Fields!Band3Color.Value, "GetColors")2pt2pt2pt2pt1.83209intruetrueTextbox36=First(Fields!Band3Color.Value, "GetColors")2pt2pt2pt2ptBeforetrueReference_Type1intruetrueTextbox52pt2pt2pt2pt1.05208intruetrueTextbox332pt2pt2pt2pt2.07292intruetrueTextbox292pt2pt2pt2pt0.90625intruetrueTextbox302pt2pt2pt2pt1.83333intruetrueTextbox372pt2pt2pt2pt1.83209intruetrueTextbox312pt2pt2pt2ptBeforetrueOrigin2.20833intruetrueTextbox34=First(Fields!Band2Color.Value, "GetColors")2pt2pt2pt2pt1intruetrueTextbox8=First(Fields!Band2Color.Value, "GetColors")2pt2pt2pt2pt1.05208intruetrueTextbox22=First(Fields!Band2Color.Value, "GetColors")2pt2pt2pt2pt2.07292intruetrueTextbox23=First(Fields!Band2Color.Value, "GetColors")2pt2pt2pt2pt0.90625intruetrueTextbox24=First(Fields!Band2Color.Value, "GetColors")2pt2pt2pt2pt1.83333intruetrueTextbox38=First(Fields!Band2Color.Value, "GetColors")2pt2pt2pt2pt1.83209intruetrueTextbox25=First(Fields!Band2Color.Value, "GetColors")2pt2pt2pt2ptBeforeStudentPayments_Query1.16667in1.25in13.96687inExternal=First(Fields!ImageLocation.Value, "GetImage")FitProportional2.37437in0.5in7.17708in1HETGrouptruetruePayments to Students by Origin and Reference TypeTextbox40.68625in3.36333in0.25in5.52145in22pt2pt2pt2pt2.41667in13.97729in1in1in1in1inStringDefaultFiscalYearParameterValueFiscal YearPaymentDateFiscalYearParameterValueParameterCaptionIndentedString[Payable].[Origin].[All]OriginPayableOriginParameterValueParameterCaptionIndentedtruePrivate bOddRow As Boolean
Function AlternateColor (ByVal OddColor As String, ByVal EvenColor As String, ByVal Toggle As Boolean) As String
If Toggle Then bOddRow = Not bOddRow
If bOddRow Then
Return OddColor
Else
Return EvenColor
End If
End FunctionInchba2cb72b-2313-457d-8a5d-af4cb89bf676