<?xml version="1.0" encoding="utf-8"?> <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner"> <Body> <ReportItems> <Tablix Name="Tablix7"> <TablixCorner> <TablixCornerRows> <TablixCornerRow> <TablixCornerCell> <CellContents> <Textbox Name="Textbox262"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value /> <Style> <FontWeight>Bold</FontWeight> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox262</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <BackgroundColor>=First(Fields!Band2Color.Value, "GetColor")</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> <ColSpan>3</ColSpan> </CellContents> </TablixCornerCell> <TablixCornerCell /> <TablixCornerCell /> </TablixCornerRow> <TablixCornerRow> <TablixCornerCell> <CellContents> <Textbox Name="Textbox257"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Enrollment Fees Assessed</Value> <Style> <FontWeight>Bold</FontWeight> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox257</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <BackgroundColor>=First(Fields!Band2Color.Value, "GetColor")</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> <ColSpan>2</ColSpan> </CellContents> </TablixCornerCell> <TablixCornerCell /> <TablixCornerCell> <CellContents> <Textbox Name="Textbox32"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value /> <Style> <FontWeight>Bold</FontWeight> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox32</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCornerCell> </TablixCornerRow> </TablixCornerRows> </TablixCorner> <TablixBody> <TablixColumns> <TablixColumn> <Width>1.1875in</Width> </TablixColumn> <TablixColumn> <Width>1.15625in</Width> </TablixColumn> <TablixColumn> <Width>1.20833in</Width> </TablixColumn> </TablixColumns> <TablixRows> <TablixRow> <Height>0.25in</Height> <TablixCells> <TablixCell> <CellContents> <Textbox Name="Fee_Paid_Amount"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Sum(Fields!Fee_Paid_Amount.Value)</Value> <Style> <Format>C2</Format> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Fee_Paid_Amount</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <BackgroundColor>=First(Fields!BackgroundAlternateColor.Value, "GetColor")</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCell> <TablixCell> <CellContents> <Textbox Name="Textbox273"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=SUM(Fields!Prior_Year_Fee_Paid_Amount.Value)</Value> <Style> <Format>C2</Format> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox273</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <BackgroundColor>=First(Fields!BackgroundAlternateColor.Value, "GetColor")</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCell> <TablixCell> <CellContents> <Textbox Name="Textbox278"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=SUM(Fields!Prior_2Year_Fee_Paid_Amount.Value)</Value> <Style> <Format>C2</Format> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox278</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <BackgroundColor>=First(Fields!BackgroundAlternateColor.Value, "GetColor")</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCell> </TablixCells> </TablixRow> <TablixRow> <Height>0.25in</Height> <TablixCells> <TablixCell> <CellContents> <Textbox Name="Textbox27"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Sum(Fields!Fee_Paid_Amount.Value)</Value> <Style> <FontWeight>Bold</FontWeight> <Format>C2</Format> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox27</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCell> <TablixCell> <CellContents> <Textbox Name="Textbox28"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=SUM(Fields!Prior_Year_Fee_Paid_Amount.Value)</Value> <Style> <FontWeight>Bold</FontWeight> <Format>C2</Format> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox28</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCell> <TablixCell> <CellContents> <Textbox Name="Textbox29"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=SUM(Fields!Prior_2Year_Fee_Paid_Amount.Value)</Value> <Style> <FontWeight>Bold</FontWeight> <Format>C2</Format> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox29</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCell> </TablixCells> </TablixRow> <TablixRow> <Height>0.25in</Height> <TablixCells> <TablixCell> <CellContents> <Textbox Name="Textbox251"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=SUM(Fields!Class_Total_Fees_Not_Paid.Value)</Value> <Style> <FontWeight>Bold</FontWeight> <Format>C2</Format> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox251</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCell> <TablixCell> <CellContents> <Textbox Name="Textbox274"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=SUM(Fields!Prior_Year_Class_Fees_Not_Paid.Value)</Value> <Style> <FontWeight>Bold</FontWeight> <Format>C2</Format> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox274</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCell> <TablixCell> <CellContents> <Textbox Name="Textbox279"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=SUM(Fields!Prior_2Year_Class_Fees_Not_Paid.Value)</Value> <Style> <FontWeight>Bold</FontWeight> <Format>C2</Format> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox279</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCell> </TablixCells> </TablixRow> </TablixRows> </TablixBody> <TablixColumnHierarchy> <TablixMembers> <TablixMember> <TablixHeader> <Size>0.25in</Size> <CellContents> <Textbox Name="Textbox265"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Fields!Term_Title.Value</Value> <Style> <FontWeight>Bold</FontWeight> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox265</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <BackgroundColor>=First(Fields!Band2Color.Value, "GetColor")</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixHeader> <TablixMembers> <TablixMember> <TablixHeader> <Size>0.25in</Size> <CellContents> <Textbox Name="Textbox247"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=SUM(Fields!Class_Total_Fees_Assessed.Value)</Value> <Style> <FontWeight>Bold</FontWeight> <Format>C2</Format> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox247</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixHeader> <TablixMembers> <TablixMember /> </TablixMembers> </TablixMember> </TablixMembers> </TablixMember> <TablixMember> <TablixHeader> <Size>0.25in</Size> <CellContents> <Textbox Name="Textbox270"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Term Year - 1</Value> <Style> <FontWeight>Bold</FontWeight> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox270</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <BackgroundColor>=First(Fields!Band2Color.Value, "GetColor")</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixHeader> <TablixMembers> <TablixMember> <TablixHeader> <Size>0.25in</Size> <CellContents> <Textbox Name="Textbox271"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=SUM(Fields!Prior_Year_Class_Fees_Assessed.Value)</Value> <Style> <FontWeight>Bold</FontWeight> <Format>C2</Format> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox271</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixHeader> <TablixMembers> <TablixMember /> </TablixMembers> </TablixMember> </TablixMembers> </TablixMember> <TablixMember> <TablixHeader> <Size>0.25in</Size> <CellContents> <Textbox Name="Textbox275"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Term Year - 2</Value> <Style> <FontWeight>Bold</FontWeight> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox275</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <BackgroundColor>=First(Fields!Band2Color.Value, "GetColor")</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixHeader> <TablixMembers> <TablixMember> <TablixHeader> <Size>0.25in</Size> <CellContents> <Textbox Name="Textbox276"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=SUM(Fields!Prior_2Year_Class_Fees_Assessed.Value)</Value> <Style> <FontWeight>Bold</FontWeight> <Format>C2</Format> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox276</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixHeader> <TablixMembers> <TablixMember /> </TablixMembers> </TablixMember> </TablixMembers> </TablixMember> </TablixMembers> </TablixColumnHierarchy> <TablixRowHierarchy> <TablixMembers> <TablixMember> <Group Name="Term_SK"> <GroupExpressions> <GroupExpression>=Fields!Term_SK.Value</GroupExpression> </GroupExpressions> </Group> <SortExpressions> <SortExpression> <Value>=Fields!Term_SK.Value</Value> </SortExpression> </SortExpressions> <TablixHeader> <Size>1in</Size> <CellContents> <Textbox Name="Term_SK"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value> Paid Enrollment</Value> <Style> <FontWeight>Bold</FontWeight> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Term_SK</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <BackgroundColor>=First(Fields!Band2Color.Value, "GetColor")</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixHeader> <TablixMembers> <TablixMember> <Group Name="Credit_Non_Credit_Vocational"> <GroupExpressions> <GroupExpression>=Fields!Credit_Non_Credit_Vocational.Value</GroupExpression> </GroupExpressions> </Group> <SortExpressions> <SortExpression> <Value>=Fields!Credit_Non_Credit_Vocational.Value</Value> </SortExpression> </SortExpressions> <TablixHeader> <Size>1in</Size> <CellContents> <Textbox Name="Credit_Non_Credit_Vocational"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Fields!Credit_Non_Credit_Vocational.Value</Value> <Style /> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Credit_Non_Credit_Vocational</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixHeader> <TablixMembers> <TablixMember> <Group Name="Payment_Category_Short"> <GroupExpressions> <GroupExpression>=Fields!Payment_Category_Short.Value</GroupExpression> </GroupExpressions> <Filters> <Filter> <FilterExpression>=IIF(Fields!Fee_Paid_Amount.Value > 0 OR Fields!Prior_Year_Fee_Paid_Amount.Value > 0 OR Fields!Prior_2Year_Fee_Paid_Amount.Value > 0 ,1,0)</FilterExpression> <Operator>Equal</Operator> <FilterValues> <FilterValue DataType="Integer">1</FilterValue> </FilterValues> </Filter> </Filters> </Group> <SortExpressions> <SortExpression> <Value>=Fields!Payment_Source_Code.Value</Value> </SortExpression> </SortExpressions> <TablixHeader> <Size>1in</Size> <CellContents> <Textbox Name="Payment_Category_Short"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Fields!Payment_Category_Short.Value</Value> <Style /> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Payment_Category_Short</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <BackgroundColor>=First(Fields!BackgroundAlternateColor.Value, "GetColor")</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixHeader> <Visibility> <Hidden>true</Hidden> <ToggleItem>Credit_Non_Credit_Vocational</ToggleItem> </Visibility> </TablixMember> <TablixMember> <TablixHeader> <Size>1in</Size> <CellContents> <Textbox Name="Textbox30"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value /> <Style /> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox30</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixHeader> <KeepWithGroup>Before</KeepWithGroup> </TablixMember> </TablixMembers> <Visibility> <Hidden>true</Hidden> <ToggleItem>Term_SK</ToggleItem> </Visibility> </TablixMember> </TablixMembers> </TablixMember> <TablixMember> <TablixHeader> <Size>2in</Size> <CellContents> <Textbox Name="Textbox261"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Assessed Fees Not Paid</Value> <Style> <FontWeight>Bold</FontWeight> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox261</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <BackgroundColor>=First(Fields!Band2Color.Value, "GetColor")</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixHeader> <TablixMembers> <TablixMember> <TablixHeader> <Size>1in</Size> <CellContents> <Textbox Name="Textbox34"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value /> <Style> <FontWeight>Bold</FontWeight> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox34</rd:DefaultName> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixHeader> </TablixMember> </TablixMembers> <KeepWithGroup>Before</KeepWithGroup> </TablixMember> </TablixMembers> </TablixRowHierarchy> <DataSetName>TuitionFeesEnrolledPaid_Query</DataSetName> <Height>1.25in</Height> <Width>6.55208in</Width> <Style> <Border> <Style>None</Style> </Border> </Style> </Tablix> </ReportItems> <Height>1.5in</Height> <Style /> </Body> <Width>6.55208in</Width> <Page> <LeftMargin>1in</LeftMargin> <RightMargin>1in</RightMargin> <TopMargin>1in</TopMargin> <BottomMargin>1in</BottomMargin> <Style /> </Page> <AutoRefresh>0</AutoRefresh> <DataSources> <DataSource Name="RSDS_EnterpriseDW_SSAS"> <DataSourceReference>RSDS_EnterpriseDW_SSAS</DataSourceReference> <rd:SecurityType>None</rd:SecurityType> <rd:DataSourceID>90644677-b268-4954-ade6-f897e1dbc60a</rd:DataSourceID> </DataSource> <DataSource Name="RSDS_EnterpriseDW"> <DataSourceReference>RSDS_EnterpriseDW</DataSourceReference> <rd:SecurityType>None</rd:SecurityType> <rd:DataSourceID>c9efb802-1539-4d90-8e81-0f78400dd64e</rd:DataSourceID> </DataSource> </DataSources> <DataSets> <DataSet Name="TuitionFeesEnrolledPaid_Query"> <Query> <DataSourceName>RSDS_EnterpriseDW_SSAS</DataSourceName> <QueryParameters> <QueryParameter Name="TermTermTitle"> <Value>=Parameters!TermTermTitle.Value</Value> </QueryParameter> <QueryParameter Name="CurriculumCourseLevel"> <Value>=Parameters!CurriculumCourseLevel.Value</Value> </QueryParameter> <QueryParameter Name="CurriculumCreditType"> <Value>=Parameters!CurriculumCreditType.Value</Value> </QueryParameter> </QueryParameters> <CommandText> SELECT NON EMPTY { [Measures].[Prior 2Year Class Fees Paid], [Measures].[Class Total Fees Not Paid], [Measures].[Prior 2Year Fee Paid Amount], [Measures].[Prior Year Class Fees Paid], [Measures].[Fee Paid Amount], [Measures].[Prior Year Fee Paid Amount], [Measures].[Prior Year Class Fees Not Paid], [Measures].[Prior 2Year Class Fees Not Paid], [Measures].[Class Total Fees Assessed], [Measures].[Class Total Fees Paid], [Measures].[Prior 2Year Class Fees Assessed], [Measures].[Prior Year Class Fees Assessed] } ON COLUMNS, NON EMPTY { ([Term].[Term SK].[Term SK].ALLMEMBERS * [Term].[Term Title].[Term Title].ALLMEMBERS * [Curriculum].[Credit Non Credit Vocational].[Credit Non Credit Vocational].ALLMEMBERS * [Payment Source].[Payment Source Code].[Payment Source Code].ALLMEMBERS * [Payment Source].[Payment Category Short].[Payment Category Short].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( -{ [Payment Source].[Payment Source Code].&[6EX] } ) ON COLUMNS FROM ( SELECT ( { [Fee Type].[Fee Category Code].&[C], [Fee Type].[Fee Category Code].&[S] } ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCreditType, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCourseLevel, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Student_Financials]))))) WHERE ( IIF( STRTOSET(@CurriculumCourseLevel, CONSTRAINED).Count = 1, STRTOSET(@CurriculumCourseLevel, CONSTRAINED), [Curriculum].[Course Level].currentmember ), IIF( STRTOSET(@CurriculumCreditType, CONSTRAINED).Count = 1, STRTOSET(@CurriculumCreditType, CONSTRAINED), [Curriculum].[Credit Type].currentmember ), [Fee Type].[Fee Category Code].CurrentMember ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS</CommandText> <rd:DesignerState> <QueryDefinition xmlns="http://schemas.microsoft.com/AnalysisServices/QueryDefinition"> <CommandType>MDX</CommandType> <QuerySpecification xsi:type="MDXQuerySpecification" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <Select> <Items> <Item> <ID xsi:type="Level"> <DimensionName>Term</DimensionName> <HierarchyName>Term SK</HierarchyName> <HierarchyUniqueName>[Term].[Term SK]</HierarchyUniqueName> <LevelName>Term SK</LevelName> <UniqueName>[Term].[Term SK].[Term SK]</UniqueName> </ID> <ItemCaption>Term SK</ItemCaption> <UniqueName>true</UniqueName> </Item> <Item> <ID xsi:type="Level"> <DimensionName>Term</DimensionName> <HierarchyName>Term Title</HierarchyName> <HierarchyUniqueName>[Term].[Term Title]</HierarchyUniqueName> <LevelName>Term Title</LevelName> <UniqueName>[Term].[Term Title].[Term Title]</UniqueName> </ID> <ItemCaption>Term Title</ItemCaption> <UniqueName>true</UniqueName> </Item> <Item> <ID xsi:type="Level"> <DimensionName>Curriculum</DimensionName> <HierarchyName>Credit Non Credit Vocational</HierarchyName> <HierarchyUniqueName>[Curriculum].[Credit Non Credit Vocational]</HierarchyUniqueName> <LevelName>Credit Non Credit Vocational</LevelName> <UniqueName>[Curriculum].[Credit Non Credit Vocational].[Credit Non Credit Vocational]</UniqueName> </ID> <ItemCaption>Credit Non Credit Vocational</ItemCaption> <UniqueName>true</UniqueName> </Item> <Item> <ID xsi:type="Level"> <DimensionName>Payment Source</DimensionName> <HierarchyName>Payment Source Code</HierarchyName> <HierarchyUniqueName>[Payment Source].[Payment Source Code]</HierarchyUniqueName> <LevelName>Payment Source Code</LevelName> <UniqueName>[Payment Source].[Payment Source Code].[Payment Source Code]</UniqueName> </ID> <ItemCaption>Payment Source Code</ItemCaption> <UniqueName>true</UniqueName> </Item> <Item> <ID xsi:type="Level"> <DimensionName>Payment Source</DimensionName> <HierarchyName>Payment Category Short</HierarchyName> <HierarchyUniqueName>[Payment Source].[Payment Category Short]</HierarchyUniqueName> <LevelName>Payment Category Short</LevelName> <UniqueName>[Payment Source].[Payment Category Short].[Payment Category Short]</UniqueName> </ID> <ItemCaption>Payment Category Short</ItemCaption> <UniqueName>true</UniqueName> </Item> <Item> <ID xsi:type="Measure"> <MeasureName>Class Total Fees Assessed</MeasureName> <UniqueName>[Measures].[Class Total Fees Assessed]</UniqueName> </ID> <ItemCaption>Class Total Fees Assessed</ItemCaption> <BackColor>true</BackColor> <ForeColor>true</ForeColor> <FontFamily>true</FontFamily> <FontSize>true</FontSize> <FontWeight>true</FontWeight> <FontStyle>true</FontStyle> <FontDecoration>true</FontDecoration> <FormattedValue>true</FormattedValue> <FormatString>true</FormatString> </Item> <Item> <ID xsi:type="Measure"> <MeasureName>Prior Year Class Fees Assessed</MeasureName> <UniqueName>[Measures].[Prior Year Class Fees Assessed]</UniqueName> </ID> <ItemCaption>Prior Year Class Fees Assessed</ItemCaption> <BackColor>true</BackColor> <ForeColor>true</ForeColor> <FontFamily>true</FontFamily> <FontSize>true</FontSize> <FontWeight>true</FontWeight> <FontStyle>true</FontStyle> <FontDecoration>true</FontDecoration> <FormattedValue>true</FormattedValue> <FormatString>true</FormatString> <DisplayFolder>Fee Calculations</DisplayFolder> </Item> <Item> <ID xsi:type="Measure"> <MeasureName>Prior 2Year Class Fees Assessed</MeasureName> <UniqueName>[Measures].[Prior 2Year Class Fees Assessed]</UniqueName> </ID> <ItemCaption>Prior 2Year Class Fees Assessed</ItemCaption> <BackColor>true</BackColor> <ForeColor>true</ForeColor> <FontFamily>true</FontFamily> <FontSize>true</FontSize> <FontWeight>true</FontWeight> <FontStyle>true</FontStyle> <FontDecoration>true</FontDecoration> <FormattedValue>true</FormattedValue> <FormatString>true</FormatString> <DisplayFolder>Fee Calculations</DisplayFolder> </Item> <Item> <ID xsi:type="Measure"> <MeasureName>Class Total Fees Paid</MeasureName> <UniqueName>[Measures].[Class Total Fees Paid]</UniqueName> </ID> <ItemCaption>Class Total Fees Paid</ItemCaption> <BackColor>true</BackColor> <ForeColor>true</ForeColor> <FontFamily>true</FontFamily> <FontSize>true</FontSize> <FontWeight>true</FontWeight> <FontStyle>true</FontStyle> <FontDecoration>true</FontDecoration> <FormattedValue>true</FormattedValue> <FormatString>true</FormatString> </Item> <Item> <ID xsi:type="Measure"> <MeasureName>Prior Year Class Fees Paid</MeasureName> <UniqueName>[Measures].[Prior Year Class Fees Paid]</UniqueName> </ID> <ItemCaption>Prior Year Class Fees Paid</ItemCaption> <BackColor>true</BackColor> <ForeColor>true</ForeColor> <FontFamily>true</FontFamily> <FontSize>true</FontSize> <FontWeight>true</FontWeight> <FontStyle>true</FontStyle> <FontDecoration>true</FontDecoration> <FormattedValue>true</FormattedValue> <FormatString>true</FormatString> <DisplayFolder>Fee Calculations</DisplayFolder> </Item> <Item> <ID xsi:type="Measure"> <MeasureName>Prior 2Year Class Fees Paid</MeasureName> <UniqueName>[Measures].[Prior 2Year Class Fees Paid]</UniqueName> </ID> <ItemCaption>Prior 2Year Class Fees Paid</ItemCaption> <BackColor>true</BackColor> <ForeColor>true</ForeColor> <FontFamily>true</FontFamily> <FontSize>true</FontSize> <FontWeight>true</FontWeight> <FontStyle>true</FontStyle> <FontDecoration>true</FontDecoration> <FormattedValue>true</FormattedValue> <FormatString>true</FormatString> <DisplayFolder>Fee Calculations</DisplayFolder> </Item> <Item> <ID xsi:type="Measure"> <MeasureName>Class Total Fees Not Paid</MeasureName> <UniqueName>[Measures].[Class Total Fees Not Paid]</UniqueName> </ID> <ItemCaption>Class Total Fees Not Paid</ItemCaption> <BackColor>true</BackColor> <ForeColor>true</ForeColor> <FontFamily>true</FontFamily> <FontSize>true</FontSize> <FontWeight>true</FontWeight> <FontStyle>true</FontStyle> <FontDecoration>true</FontDecoration> <FormattedValue>true</FormattedValue> <FormatString>true</FormatString> </Item> <Item> <ID xsi:type="Measure"> <MeasureName>Prior Year Class Fees Not Paid</MeasureName> <UniqueName>[Measures].[Prior Year Class Fees Not Paid]</UniqueName> </ID> <ItemCaption>Prior Year Class Fees Not Paid</ItemCaption> <BackColor>true</BackColor> <ForeColor>true</ForeColor> <FontFamily>true</FontFamily> <FontSize>true</FontSize> <FontWeight>true</FontWeight> <FontStyle>true</FontStyle> <FontDecoration>true</FontDecoration> <FormattedValue>true</FormattedValue> <FormatString>true</FormatString> <DisplayFolder>Fee Calculations</DisplayFolder> </Item> <Item> <ID xsi:type="Measure"> <MeasureName>Prior 2Year Class Fees Not Paid</MeasureName> <UniqueName>[Measures].[Prior 2Year Class Fees Not Paid]</UniqueName> </ID> <ItemCaption>Prior 2Year Class Fees Not Paid</ItemCaption> <BackColor>true</BackColor> <ForeColor>true</ForeColor> <FontFamily>true</FontFamily> <FontSize>true</FontSize> <FontWeight>true</FontWeight> <FontStyle>true</FontStyle> <FontDecoration>true</FontDecoration> <FormattedValue>true</FormattedValue> <FormatString>true</FormatString> <DisplayFolder>Fee Calculations</DisplayFolder> </Item> <Item> <ID xsi:type="Measure"> <MeasureName>Fee Paid Amount</MeasureName> <UniqueName>[Measures].[Fee Paid Amount]</UniqueName> </ID> <ItemCaption>Fee Paid Amount</ItemCaption> <BackColor>true</BackColor> <ForeColor>true</ForeColor> <FontFamily>true</FontFamily> <FontSize>true</FontSize> <FontWeight>true</FontWeight> <FontStyle>true</FontStyle> <FontDecoration>true</FontDecoration> <FormattedValue>true</FormattedValue> <FormatString>true</FormatString> </Item> <Item> <ID xsi:type="Measure"> <MeasureName>Prior Year Fee Paid Amount</MeasureName> <UniqueName>[Measures].[Prior Year Fee Paid Amount]</UniqueName> </ID> <ItemCaption>Prior Year Fee Paid Amount</ItemCaption> <BackColor>true</BackColor> <ForeColor>true</ForeColor> <FontFamily>true</FontFamily> <FontSize>true</FontSize> <FontWeight>true</FontWeight> <FontStyle>true</FontStyle> <FontDecoration>true</FontDecoration> <FormattedValue>true</FormattedValue> <FormatString>true</FormatString> <DisplayFolder>Fee Calculations</DisplayFolder> </Item> <Item> <ID xsi:type="Measure"> <MeasureName>Prior 2Year Fee Paid Amount</MeasureName> <UniqueName>[Measures].[Prior 2Year Fee Paid Amount]</UniqueName> </ID> <ItemCaption>Prior 2Year Fee Paid Amount</ItemCaption> <BackColor>true</BackColor> <ForeColor>true</ForeColor> <FontFamily>true</FontFamily> <FontSize>true</FontSize> <FontWeight>true</FontWeight> <FontStyle>true</FontStyle> <FontDecoration>true</FontDecoration> <FormattedValue>true</FormattedValue> <FormatString>true</FormatString> <DisplayFolder>Fee Calculations</DisplayFolder> </Item> </Items> </Select> <From>Student_Financials</From> <Filter> <FilterItems> <FilterItem> <HierarchyUniqueName>[Term].[Term Title]</HierarchyUniqueName> <Condition xsi:type="EqualTo"> <Members /> <Parametrized>true</Parametrized> </Condition> </FilterItem> <FilterItem> <HierarchyUniqueName>[Curriculum].[Course Level]</HierarchyUniqueName> <Condition xsi:type="EqualTo"> <Members /> <Parametrized>true</Parametrized> </Condition> </FilterItem> <FilterItem> <HierarchyUniqueName>[Curriculum].[Credit Type]</HierarchyUniqueName> <Condition xsi:type="EqualTo"> <Members /> <Parametrized>true</Parametrized> </Condition> </FilterItem> <FilterItem> <HierarchyUniqueName>[Fee Type].[Fee Category Code]</HierarchyUniqueName> <Condition xsi:type="EqualTo"> <Members> <Member> <MemberUniqueName>[Fee Type].[Fee Category Code].&[C]</MemberUniqueName> </Member> <Member> <MemberUniqueName>[Fee Type].[Fee Category Code].&[S]</MemberUniqueName> </Member> </Members> </Condition> </FilterItem> <FilterItem> <HierarchyUniqueName>[Payment Source].[Payment Source Code]</HierarchyUniqueName> <Condition xsi:type="NotEqualTo"> <Members> <Member> <MemberUniqueName>[Payment Source].[Payment Source Code].&[6EX]</MemberUniqueName> </Member> </Members> </Condition> </FilterItem> </FilterItems> </Filter> <Calculations /> <Aggregates /> <QueryProperties /> </QuerySpecification> <Query> <Statement> SELECT NON EMPTY { [Measures].[Prior 2Year Class Fees Paid], [Measures].[Class Total Fees Not Paid], [Measures].[Prior 2Year Fee Paid Amount], [Measures].[Prior Year Class Fees Paid], [Measures].[Fee Paid Amount], [Measures].[Prior Year Fee Paid Amount], [Measures].[Prior Year Class Fees Not Paid], [Measures].[Prior 2Year Class Fees Not Paid], [Measures].[Class Total Fees Assessed], [Measures].[Class Total Fees Paid], [Measures].[Prior 2Year Class Fees Assessed], [Measures].[Prior Year Class Fees Assessed] } ON COLUMNS, NON EMPTY { ([Term].[Term SK].[Term SK].ALLMEMBERS * [Term].[Term Title].[Term Title].ALLMEMBERS * [Curriculum].[Credit Non Credit Vocational].[Credit Non Credit Vocational].ALLMEMBERS * [Payment Source].[Payment Source Code].[Payment Source Code].ALLMEMBERS * [Payment Source].[Payment Category Short].[Payment Category Short].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( -{ [Payment Source].[Payment Source Code].&[6EX] } ) ON COLUMNS FROM ( SELECT ( { [Fee Type].[Fee Category Code].&[C], [Fee Type].[Fee Category Code].&[S] } ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCreditType, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CurriculumCourseLevel, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Student_Financials]))))) WHERE ( IIF( STRTOSET(@CurriculumCourseLevel, CONSTRAINED).Count = 1, STRTOSET(@CurriculumCourseLevel, CONSTRAINED), [Curriculum].[Course Level].currentmember ), IIF( STRTOSET(@CurriculumCreditType, CONSTRAINED).Count = 1, STRTOSET(@CurriculumCreditType, CONSTRAINED), [Curriculum].[Credit Type].currentmember ), [Fee Type].[Fee Category Code].CurrentMember ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS</Statement> <ParameterDefinitions> <ParameterDefinition> <Name>TermTermTitle</Name> <DefaultValues /> <Caption>Term.Term Title</Caption> <HierarchyUniqueName>[Term].[Term Title]</HierarchyUniqueName> <ParameterValuesQuery> <Statement>WITH MEMBER [Measures].[ParameterCaption] AS [Term].[Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Term].[Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Term].[Term Title].ALLMEMBERS ON ROWS FROM [Student_Financials]</Statement> <ParameterizedStatement> <ReferencedParameters /> </ParameterizedStatement> </ParameterValuesQuery> <MultipleValues>true</MultipleValues> </ParameterDefinition> <ParameterDefinition> <Name>CurriculumCourseLevel</Name> <DefaultValues /> <Caption>Course Level</Caption> <HierarchyUniqueName>[Curriculum].[Course Level]</HierarchyUniqueName> <ParameterValuesQuery> <Statement>WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Course Level].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Course Level].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Course Level].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Course Level].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Student_Financials])</Statement> <ParameterizedStatement> <Statement>WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Course Level].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Course Level].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Course Level].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Course Level].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Student_Financials])</Statement> <ReferencedParameters> <ReferencedParameter> <Name>TermTermTitle</Name> </ReferencedParameter> </ReferencedParameters> </ParameterizedStatement> </ParameterValuesQuery> <MultipleValues>true</MultipleValues> </ParameterDefinition> <ParameterDefinition> <Name>CurriculumCreditType</Name> <DefaultValues /> <Caption>Credit Type</Caption> <HierarchyUniqueName>[Curriculum].[Credit Type]</HierarchyUniqueName> <ParameterValuesQuery> <Statement>WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Credit Type].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Credit Type].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Credit Type].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Credit Type].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumCourseLevel, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Student_Financials]))</Statement> <ParameterizedStatement> <Statement>WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Credit Type].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Credit Type].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Credit Type].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Credit Type].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumCourseLevel, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Student_Financials]))</Statement> <ReferencedParameters> <ReferencedParameter> <Name>TermTermTitle</Name> </ReferencedParameter> <ReferencedParameter> <Name>CurriculumCourseLevel</Name> </ReferencedParameter> </ReferencedParameters> </ParameterizedStatement> </ParameterValuesQuery> <MultipleValues>true</MultipleValues> </ParameterDefinition> </ParameterDefinitions> </Query> </QueryDefinition> </rd:DesignerState> </Query> <Fields> <Field Name="Term_SK"> <DataField><?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="[Term].[Term SK].[Term SK]" /></DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="Class_Total_Fees_Assessed"> <DataField><?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].[Class Total Fees Assessed]" /></DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="Payment_Source_Code"> <DataField><?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 Source].[Payment Source Code].[Payment Source Code]" /></DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="Credit_Non_Credit_Vocational"> <DataField><?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="[Curriculum].[Credit Non Credit Vocational].[Credit Non Credit Vocational]" /></DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="Term_Title"> <DataField><?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="[Term].[Term Title].[Term Title]" /></DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="Payment_Category_Short"> <DataField><?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 Source].[Payment Category Short].[Payment Category Short]" /></DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="Prior_Year_Class_Fees_Assessed"> <DataField><?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].[Prior Year Class Fees Assessed]" /></DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="Prior_2Year_Class_Fees_Assessed"> <DataField><?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].[Prior 2Year Class Fees Assessed]" /></DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="Class_Total_Fees_Paid"> <DataField><?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].[Class Total Fees Paid]" /></DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="Prior_Year_Class_Fees_Paid"> <DataField><?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].[Prior Year Class Fees Paid]" /></DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="Prior_2Year_Class_Fees_Paid"> <DataField><?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].[Prior 2Year Class Fees Paid]" /></DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="Class_Total_Fees_Not_Paid"> <DataField><?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].[Class Total Fees Not Paid]" /></DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="Prior_Year_Class_Fees_Not_Paid"> <DataField><?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].[Prior Year Class Fees Not Paid]" /></DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="Prior_2Year_Class_Fees_Not_Paid"> <DataField><?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].[Prior 2Year Class Fees Not Paid]" /></DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="Fee_Paid_Amount"> <DataField><?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].[Fee Paid Amount]" /></DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="Prior_Year_Fee_Paid_Amount"> <DataField><?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].[Prior Year Fee Paid Amount]" /></DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="Prior_2Year_Fee_Paid_Amount"> <DataField><?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].[Prior 2Year Fee Paid Amount]" /></DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> </Fields> </DataSet> <DataSet Name="TermTermTitle"> <Query> <DataSourceName>RSDS_EnterpriseDW_SSAS</DataSourceName> <CommandText>WITH MEMBER [Measures].[ParameterCaption] AS [Term].[Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Term].[Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Term].[Term Title].ALLMEMBERS ON ROWS FROM [Student_Financials]</CommandText> <rd:DesignerState> <QueryDefinition xmlns="http://schemas.microsoft.com/AnalysisServices/QueryDefinition"> <CommandType>MDX</CommandType> <Type>Query</Type> <QuerySpecification xsi:type="MDXQuerySpecification" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <Select> <Items> <Item> <ID xsi:type="Measure"> <MeasureName>ParameterCaption</MeasureName> <UniqueName>[Measures].[ParameterCaption]</UniqueName> </ID> <ItemCaption>ParameterCaption</ItemCaption> <FormattedValue>true</FormattedValue> </Item> <Item> <ID xsi:type="Measure"> <MeasureName>ParameterValue</MeasureName> <UniqueName>[Measures].[ParameterValue]</UniqueName> </ID> <ItemCaption>ParameterValue</ItemCaption> <FormattedValue>true</FormattedValue> </Item> <Item> <ID xsi:type="Measure"> <MeasureName>ParameterLevel</MeasureName> <UniqueName>[Measures].[ParameterLevel]</UniqueName> </ID> <ItemCaption>ParameterLevel</ItemCaption> <FormattedValue>true</FormattedValue> </Item> </Items> </Select> <From>Student_Financials</From> <Filter> <FilterItems /> </Filter> <Calculations /> <Aggregates /> <QueryProperties /> </QuerySpecification> <Query> <Statement>WITH MEMBER [Measures].[ParameterCaption] AS [Term].[Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Term].[Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Term].[Term Title].ALLMEMBERS ON ROWS FROM [Student_Financials]</Statement> <ParameterDefinitions /> </Query> </QueryDefinition> </rd:DesignerState> <rd:AutoGenerated>true</rd:AutoGenerated> <rd:Hidden>true</rd:Hidden> </Query> <Fields> <Field Name="ParameterCaption"> <DataField><?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]" /></DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="ParameterValue"> <DataField><?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]" /></DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="ParameterLevel"> <DataField><?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]" /></DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="ParameterCaptionIndented"> <Value>=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.Value</Value> <rd:TypeName>System.String</rd:TypeName> </Field> </Fields> </DataSet> <DataSet Name="CurriculumCourseLevel"> <Query> <DataSourceName>RSDS_EnterpriseDW_SSAS</DataSourceName> <QueryParameters> <QueryParameter Name="TermTermTitle"> <Value>=Parameters!TermTermTitle.Value</Value> </QueryParameter> </QueryParameters> <CommandText>WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Course Level].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Course Level].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Course Level].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Course Level].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Student_Financials])</CommandText> <rd:DesignerState> <QueryDefinition xmlns="http://schemas.microsoft.com/AnalysisServices/QueryDefinition"> <CommandType>MDX</CommandType> <Type>Query</Type> <QuerySpecification xsi:type="MDXQuerySpecification" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <Select> <Items> <Item> <ID xsi:type="Measure"> <MeasureName>ParameterCaption</MeasureName> <UniqueName>[Measures].[ParameterCaption]</UniqueName> </ID> <ItemCaption>ParameterCaption</ItemCaption> <FormattedValue>true</FormattedValue> </Item> <Item> <ID xsi:type="Measure"> <MeasureName>ParameterValue</MeasureName> <UniqueName>[Measures].[ParameterValue]</UniqueName> </ID> <ItemCaption>ParameterValue</ItemCaption> <FormattedValue>true</FormattedValue> </Item> <Item> <ID xsi:type="Measure"> <MeasureName>ParameterLevel</MeasureName> <UniqueName>[Measures].[ParameterLevel]</UniqueName> </ID> <ItemCaption>ParameterLevel</ItemCaption> <FormattedValue>true</FormattedValue> </Item> </Items> </Select> <From>Student_Financials</From> <Filter> <FilterItems /> </Filter> <Calculations /> <Aggregates /> <QueryProperties /> </QuerySpecification> <Query> <Statement>WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Course Level].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Course Level].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Course Level].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Course Level].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Student_Financials])</Statement> <ParameterDefinitions> <ParameterDefinition> <Name>TermTermTitle</Name> <DefaultValues /> <Caption>Term.Term Title</Caption> <HierarchyUniqueName>[Term].[Term Title]</HierarchyUniqueName> <ParameterValuesQuery> <Statement>WITH MEMBER [Measures].[ParameterCaption] AS [Term].[Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Term].[Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Term].[Term Title].ALLMEMBERS ON ROWS FROM [Student_Financials]</Statement> <ParameterizedStatement> <ReferencedParameters /> </ParameterizedStatement> </ParameterValuesQuery> <MultipleValues>true</MultipleValues> </ParameterDefinition> </ParameterDefinitions> </Query> </QueryDefinition> </rd:DesignerState> <rd:AutoGenerated>true</rd:AutoGenerated> <rd:Hidden>true</rd:Hidden> </Query> <Fields> <Field Name="ParameterCaption"> <DataField><?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]" /></DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="ParameterValue"> <DataField><?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]" /></DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="ParameterLevel"> <DataField><?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]" /></DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="ParameterCaptionIndented"> <Value>=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.Value</Value> <rd:TypeName>System.String</rd:TypeName> </Field> </Fields> </DataSet> <DataSet Name="CurriculumCreditType"> <Query> <DataSourceName>RSDS_EnterpriseDW_SSAS</DataSourceName> <QueryParameters> <QueryParameter Name="TermTermTitle"> <Value>=Parameters!TermTermTitle.Value</Value> </QueryParameter> <QueryParameter Name="CurriculumCourseLevel"> <Value>=Parameters!CurriculumCourseLevel.Value</Value> </QueryParameter> </QueryParameters> <CommandText>WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Credit Type].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Credit Type].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Credit Type].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Credit Type].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumCourseLevel, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Student_Financials]))</CommandText> <rd:DesignerState> <QueryDefinition xmlns="http://schemas.microsoft.com/AnalysisServices/QueryDefinition"> <CommandType>MDX</CommandType> <Type>Query</Type> <QuerySpecification xsi:type="MDXQuerySpecification" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <Select> <Items> <Item> <ID xsi:type="Measure"> <MeasureName>ParameterCaption</MeasureName> <UniqueName>[Measures].[ParameterCaption]</UniqueName> </ID> <ItemCaption>ParameterCaption</ItemCaption> <FormattedValue>true</FormattedValue> </Item> <Item> <ID xsi:type="Measure"> <MeasureName>ParameterValue</MeasureName> <UniqueName>[Measures].[ParameterValue]</UniqueName> </ID> <ItemCaption>ParameterValue</ItemCaption> <FormattedValue>true</FormattedValue> </Item> <Item> <ID xsi:type="Measure"> <MeasureName>ParameterLevel</MeasureName> <UniqueName>[Measures].[ParameterLevel]</UniqueName> </ID> <ItemCaption>ParameterLevel</ItemCaption> <FormattedValue>true</FormattedValue> </Item> </Items> </Select> <From>Student_Financials</From> <Filter> <FilterItems /> </Filter> <Calculations /> <Aggregates /> <QueryProperties /> </QuerySpecification> <Query> <Statement>WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Credit Type].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Credit Type].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Credit Type].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Credit Type].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumCourseLevel, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Student_Financials]))</Statement> <ParameterDefinitions> <ParameterDefinition> <Name>TermTermTitle</Name> <DefaultValues /> <Caption>Term.Term Title</Caption> <HierarchyUniqueName>[Term].[Term Title]</HierarchyUniqueName> <ParameterValuesQuery> <Statement>WITH MEMBER [Measures].[ParameterCaption] AS [Term].[Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Term].[Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Term].[Term Title].ALLMEMBERS ON ROWS FROM [Student_Financials]</Statement> <ParameterizedStatement> <ReferencedParameters /> </ParameterizedStatement> </ParameterValuesQuery> <MultipleValues>true</MultipleValues> </ParameterDefinition> <ParameterDefinition> <Name>CurriculumCourseLevel</Name> <DefaultValues /> <Caption>Course Level</Caption> <HierarchyUniqueName>[Curriculum].[Course Level]</HierarchyUniqueName> <ParameterValuesQuery> <Statement>WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Course Level].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Course Level].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Course Level].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Course Level].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Student_Financials])</Statement> <ParameterizedStatement> <Statement>WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Course Level].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Course Level].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Course Level].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Course Level].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Student_Financials])</Statement> <ReferencedParameters> <ReferencedParameter> <Name>TermTermTitle</Name> </ReferencedParameter> </ReferencedParameters> </ParameterizedStatement> </ParameterValuesQuery> <MultipleValues>true</MultipleValues> </ParameterDefinition> </ParameterDefinitions> </Query> </QueryDefinition> </rd:DesignerState> <rd:AutoGenerated>true</rd:AutoGenerated> <rd:Hidden>true</rd:Hidden> </Query> <Fields> <Field Name="ParameterCaption"> <DataField><?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]" /></DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="ParameterValue"> <DataField><?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]" /></DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="ParameterLevel"> <DataField><?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]" /></DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="ParameterCaptionIndented"> <Value>=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.Value</Value> <rd:TypeName>System.String</rd:TypeName> </Field> </Fields> </DataSet> <DataSet Name="GetColor"> <Query> <DataSourceName>RSDS_EnterpriseDW</DataSourceName> <CommandText>SELECT BackgroundColor, BackgroundAlternateColor, Band1Color, Band2Color, Band3Color, Band4Color, Band5Color, Band6Color FROM Configuration_Color WHERE (ReportType = 'StudentFinancials')</CommandText> </Query> <Fields> <Field Name="BackgroundColor"> <DataField>BackgroundColor</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="BackgroundAlternateColor"> <DataField>BackgroundAlternateColor</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="Band1Color"> <DataField>Band1Color</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="Band2Color"> <DataField>Band2Color</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="Band3Color"> <DataField>Band3Color</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="Band4Color"> <DataField>Band4Color</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="Band5Color"> <DataField>Band5Color</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="Band6Color"> <DataField>Band6Color</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> </Fields> </DataSet> </DataSets> <ReportParameters> <ReportParameter Name="TermTermTitle"> <DataType>String</DataType> <DefaultValue> <Values> <Value>[Term].[Term Title].&[20132]</Value> </Values> </DefaultValue> <Prompt>Term.Term Title</Prompt> <ValidValues> <DataSetReference> <DataSetName>TermTermTitle</DataSetName> <ValueField>ParameterValue</ValueField> <LabelField>ParameterCaptionIndented</LabelField> </DataSetReference> </ValidValues> </ReportParameter> <ReportParameter Name="CurriculumCourseLevel"> <DataType>String</DataType> <DefaultValue> <Values> <Value>[Curriculum].[Course Level].[All]</Value> </Values> </DefaultValue> <Prompt>Course Level</Prompt> <ValidValues> <DataSetReference> <DataSetName>CurriculumCourseLevel</DataSetName> <ValueField>ParameterValue</ValueField> <LabelField>ParameterCaptionIndented</LabelField> </DataSetReference> </ValidValues> <MultiValue>true</MultiValue> </ReportParameter> <ReportParameter Name="CurriculumCreditType"> <DataType>String</DataType> <DefaultValue> <Values> <Value>[Curriculum].[Credit Type].[All]</Value> </Values> </DefaultValue> <Prompt>Credit Type</Prompt> <ValidValues> <DataSetReference> <DataSetName>CurriculumCreditType</DataSetName> <ValueField>ParameterValue</ValueField> <LabelField>ParameterCaptionIndented</LabelField> </DataSetReference> </ValidValues> <MultiValue>true</MultiValue> </ReportParameter> </ReportParameters> <rd:ReportUnitType>Inch</rd:ReportUnitType> <rd:ReportID>8673de80-e40b-4a32-ba63-32462f87acb2</rd:ReportID> </Report>