<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2016/01/reportdefinition">
  <DataSources>
    <DataSource Name="src">
      <ConnectionProperties><DataProvider>SQL</DataProvider><ConnectString /></ConnectionProperties>
    </DataSource>
  </DataSources>
  <DataSets>
    <DataSet Name="Sales">
      <Query><DataSourceName>src</DataSourceName><CommandText /></Query>
      <Fields>
        <Field Name="Month"><DataField>Month</DataField></Field>
        <Field Name="Revenue"><DataField>Revenue</DataField></Field>
        <Field Name="Price"><DataField>Price</DataField></Field>
        <Field Name="Units"><DataField>Units</DataField></Field>
      </Fields>
    </DataSet>
  </DataSets>
  <ReportSections>
    <ReportSection>
      <Body>
        <ReportItems>
          <Chart Name="Revenue">
            <ChartCategoryHierarchy>
              <ChartMembers>
                <ChartMember>
                  <Group Name="Months"><GroupExpressions><GroupExpression>=Fields!Month.Value</GroupExpression></GroupExpressions></Group>
                  <Label>=Fields!Month.Value</Label>
                </ChartMember>
              </ChartMembers>
            </ChartCategoryHierarchy>
            <ChartSeriesHierarchy><ChartMembers><ChartMember><Label>Revenue</Label></ChartMember></ChartMembers></ChartSeriesHierarchy>
            <ChartData>
              <ChartSeriesCollection>
                <ChartSeries Name="RevenueSeries">
                  <ChartDataPoints>
                    <ChartDataPoint>
                      <ChartDataPointValues><Y>=Sum(Fields!Revenue.Value)</Y></ChartDataPointValues>
                      <ChartDataLabel>
                        <Visible>true</Visible>
                        <UseValueAsLabel>true</UseValueAsLabel>
                        <Style><Format>N0</Format></Style>
                      </ChartDataLabel>
                      <Style><Color>#2E6DB4</Color></Style>
                      <ChartMarker><Type>Circle</Type><Size>7pt</Size></ChartMarker>
                    </ChartDataPoint>
                  </ChartDataPoints>
                  <Type>Line</Type>
                  <Subtype>Plain</Subtype>
                </ChartSeries>
              </ChartSeriesCollection>
            </ChartData>
            <ChartAreas>
              <ChartArea Name="Default">
                <ChartCategoryAxes><ChartAxis Name="Primary"><Visible>True</Visible></ChartAxis></ChartCategoryAxes>
                <ChartValueAxes><ChartAxis Name="Primary"><Visible>True</Visible></ChartAxis></ChartValueAxes>
              </ChartArea>
            </ChartAreas>
            <ChartLegends><ChartLegend Name="Legend"><Hidden>false</Hidden></ChartLegend></ChartLegends>
            <ChartTitles><ChartTitle Name="RevenueTitle"><Caption>Revenue by month</Caption></ChartTitle></ChartTitles>
            <DataSetName>Sales</DataSetName>
            <Top>0in</Top><Left>0in</Left><Height>2.6in</Height><Width>5in</Width>
          </Chart>
          <Chart Name="PriceUnits">
            <ChartCategoryHierarchy>
              <ChartMembers>
                <ChartMember>
                  <Group Name="Points"><GroupExpressions><GroupExpression>=Fields!Month.Value</GroupExpression></GroupExpressions></Group>
                  <Label>=Fields!Month.Value</Label>
                </ChartMember>
              </ChartMembers>
            </ChartCategoryHierarchy>
            <ChartSeriesHierarchy><ChartMembers><ChartMember><Label>Units at price</Label></ChartMember></ChartMembers></ChartSeriesHierarchy>
            <ChartData>
              <ChartSeriesCollection>
                <ChartSeries Name="UnitsSeries">
                  <ChartDataPoints>
                    <ChartDataPoint>
                      <ChartDataPointValues><X>=Sum(Fields!Price.Value)</X><Y>=Sum(Fields!Units.Value)</Y></ChartDataPointValues>
                      <Style><Color>#C04000</Color></Style>
                      <ChartMarker><Type>Diamond</Type><Size>8pt</Size></ChartMarker>
                    </ChartDataPoint>
                  </ChartDataPoints>
                  <Type>Scatter</Type>
                  <Subtype>Plain</Subtype>
                </ChartSeries>
              </ChartSeriesCollection>
            </ChartData>
            <ChartAreas>
              <ChartArea Name="Default">
                <ChartCategoryAxes><ChartAxis Name="Primary"><Visible>True</Visible></ChartAxis></ChartCategoryAxes>
                <ChartValueAxes><ChartAxis Name="Primary"><Visible>True</Visible></ChartAxis></ChartValueAxes>
              </ChartArea>
            </ChartAreas>
            <ChartLegends><ChartLegend Name="Legend"><Hidden>true</Hidden></ChartLegend></ChartLegends>
            <ChartTitles><ChartTitle Name="PriceTitle"><Caption>Units sold against price</Caption></ChartTitle></ChartTitles>
            <DataSetName>Sales</DataSetName>
            <Top>2.8in</Top><Left>0in</Left><Height>2.6in</Height><Width>5in</Width>
          </Chart>
        </ReportItems>
        <Height>5.4in</Height>
      </Body>
      <Width>5in</Width>
      <Page>
        <PageHeight>6in</PageHeight><PageWidth>5.5in</PageWidth>
        <LeftMargin>0.25in</LeftMargin><RightMargin>0.25in</RightMargin><TopMargin>0.25in</TopMargin><BottomMargin>0.25in</BottomMargin>
      </Page>
    </ReportSection>
  </ReportSections>
  <Language>en-US</Language>
</Report>
