<?xml version="1.0" encoding="utf-8"?>
<Report ScriptLanguage="CSharp" ReportInfo.Created="08/20/2012 15:14:53" ReportInfo.Modified="09/17/2017 14:29:59" ReportInfo.CreatorVersion="2013.2.5.0">
  <ScriptText>using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Windows.Forms;
using System.Drawing;
using System.Data;
using FastReport;
using FastReport.Data;
using FastReport.Dialog;
using FastReport.Barcode;
using FastReport.Table;
using FastReport.Utils;

namespace FastReport
{
  public class ReportScript
  {
    public decimal sfl(decimal yj,decimal sj)
    {
      decimal result =0;
      if(yj==0)
        result =100;
      else
        result = sj/yj*100;
      return result;        
    }
  }
}
</ScriptText>
  <Dictionary>
    <TableDataSource Name="交费率综合统计情况" ReferenceName="Data.交费率综合统计情况" DataType="System.Int32" Enabled="true">
      <Column Name="PLOTID" DataType="System.String"/>
      <Column Name="PLOTNAME" DataType="System.String"/>
      <Column Name="GBID" DataType="System.String"/>
      <Column Name="GB" DataType="System.String"/>
      <Column Name="YJHS" DataType="System.Int32"/>
      <Column Name="WJHS" DataType="System.Int32"/>
      <Column Name="SJHS" DataType="System.Int32"/>
      <Column Name="YJJE" DataType="System.Decimal"/>
      <Column Name="WJJE" DataType="System.Decimal"/>
      <Column Name="SJJE" DataType="System.Decimal"/>
      <Column Name="JFL" DataType="System.Decimal"/>
    </TableDataSource>
    <TableDataSource Name="查询条件" ReferenceName="Data.查询条件" DataType="System.Int32" Enabled="true">
      <Column Name="小区" DataType="System.String"/>
      <Column Name="物业类型" DataType="System.String"/>
      <Column Name="物业状态" DataType="System.String"/>
      <Column Name="收费类型" DataType="System.String"/>
      <Column Name="收费项目" DataType="System.String"/>
      <Column Name="统计日期1" DataType="System.String"/>
      <Column Name="统计日期2" DataType="System.String"/>
      <Column Name="分析角度" DataType="System.String"/>
      <Column Name="当前操作员" DataType="System.String"/>
      <Column Name="收费截止日" DataType="System.String"/>
    </TableDataSource>
    <Total Name="Totalyjhs" Expression="[交费率综合统计情况.YJHS]" Evaluator="Data1" PrintOn="DataFooter1"/>
    <Total Name="Totalwjhs" Expression="[交费率综合统计情况.WJHS]" Evaluator="Data1" PrintOn="DataFooter1"/>
    <Total Name="Totalsjhs" Expression="[交费率综合统计情况.SJHS]" Evaluator="Data1" PrintOn="DataFooter1"/>
    <Total Name="Totalyjje" Expression="[交费率综合统计情况.YJJE]" Evaluator="Data1" PrintOn="DataFooter1"/>
    <Total Name="Totalwjje" Expression="[交费率综合统计情况.WJJE]" Evaluator="Data1" PrintOn="DataFooter1"/>
    <Total Name="Totalsjje" Expression="[交费率综合统计情况.SJJE]" Evaluator="Data1" PrintOn="DataFooter1"/>
  </Dictionary>
  <ReportPage Name="Page1" RawPaperSize="9" LeftMargin="5" TopMargin="5" RightMargin="5" BottomMargin="5" FirstPageSource="1" OtherPagesSource="1">
    <ReportTitleBand Name="ReportTitle1" Width="756" Height="47.25">
      <TextObject Name="Text1" Width="756" Height="28.35" Text="[查询条件.分析角度]交费率综合统计表" HorzAlign="Center" VertAlign="Center" Font="宋体, 14pt, style=Bold"/>
      <TextObject Name="Text30" Left="557.55" Width="198.45" Height="28.35" Text="时间段：[查询条件.统计日期1]至[查询条件.统计日期2]" VertAlign="Center" Font="宋体, 9pt"/>
    </ReportTitleBand>
    <PageHeaderBand Name="PageHeader1" Top="51.25" Width="756" Height="66.15">
      <TextObject Name="Text4" Top="37.8" Width="94.5" Height="28.35" Border.Lines="All" Text="小区名称" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
      <TextObject Name="Text6" Left="94.5" Top="37.8" Width="94.5" Height="28.35" Border.Lines="All" Text="分析角度" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
      <TextObject Name="Text8" Left="255.15" Top="37.8" Width="66.15" Height="28.35" Border.Lines="All" Text="未交户数" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
      <TextObject Name="Text10" Left="321.3" Top="37.8" Width="66.15" Height="28.35" Border.Lines="All" Text="已交户数" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
      <TextObject Name="Text14" Left="481.95" Top="37.8" Width="94.5" Height="28.35" Border.Lines="All" Text="未交金额" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
      <TextObject Name="Text16" Left="576.45" Top="37.8" Width="94.5" Height="28.35" Border.Lines="All" Text="已交金额" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
      <TextObject Name="Text18" Left="387.45" Top="37.8" Width="94.5" Height="28.35" Border.Lines="All" Text="应交金额" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
      <TextObject Name="Text20" Left="670.95" Top="37.8" Width="85.05" Height="28.35" Border.Lines="All" Text="交费率%" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
      <TextObject Name="Text2" Width="756" Height="37.8" Text="小区：[查询条件.小区] 物业类型：[查询条件.物业类型] 物业状态：[查询条件.物业状态] 收费类型：[查询条件.收费类型] 收费项目：[查询条件.收费项目] " Font="宋体, 9pt"/>
      <TextObject Name="Text12" Left="189" Top="37.8" Width="66.15" Height="28.35" Border.Lines="All" Text="应收户数" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
    </PageHeaderBand>
    <DataBand Name="Data1" Top="121.4" Width="756" Height="28.35" DataSource="交费率综合统计情况">
      <TextObject Name="Text3" Width="94.5" Height="28.35" Border.Lines="All" Text="[交费率综合统计情况.PLOTNAME]" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
      <TextObject Name="Text5" Left="94.5" Width="94.5" Height="28.35" Border.Lines="All" Text="[交费率综合统计情况.GB]" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
      <TextObject Name="Text7" Left="255.15" Width="66.15" Height="28.35" Border.Lines="All" Text="[交费率综合统计情况.WJHS]" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
      <TextObject Name="Text9" Left="321.3" Width="66.15" Height="28.35" Border.Lines="All" Text="[交费率综合统计情况.SJHS]" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
      <TextObject Name="Text13" Left="481.95" Width="94.5" Height="28.35" Border.Lines="All" Text="[交费率综合统计情况.WJJE]" Format="Currency" Format.UseLocale="true" HorzAlign="Right" VertAlign="Center" WordWrap="false" Font="宋体, 9pt" Trimming="EllipsisCharacter"/>
      <TextObject Name="Text15" Left="576.45" Width="94.5" Height="28.35" Border.Lines="All" Text="[交费率综合统计情况.SJJE]" Format="Currency" Format.UseLocale="true" HorzAlign="Right" VertAlign="Center" WordWrap="false" Font="宋体, 9pt" Trimming="EllipsisCharacter"/>
      <TextObject Name="Text17" Left="387.45" Width="94.5" Height="28.35" Border.Lines="All" Text="[交费率综合统计情况.YJJE]" Format="Currency" Format.UseLocale="true" HorzAlign="Right" VertAlign="Center" WordWrap="false" Font="宋体, 9pt" Trimming="EllipsisCharacter"/>
      <TextObject Name="Text19" Left="670.95" Width="85.05" Height="28.35" Border.Lines="All" Text="[交费率综合统计情况.JFL]" Format="Number" Format.UseLocale="true" HorzAlign="Right" VertAlign="Center" WordWrap="false" Font="宋体, 9pt" Trimming="EllipsisCharacter"/>
      <TextObject Name="Text11" Left="189" Width="66.15" Height="28.35" Border.Lines="All" Text="[交费率综合统计情况.YJHS]" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
      <DataFooterBand Name="DataFooter1" Top="153.75" Width="756" Height="28.35">
        <TextObject Name="Text22" Width="189" Height="28.35" Border.Lines="All" Text="合计：" HorzAlign="Right" VertAlign="Center" Font="宋体, 9pt"/>
        <TextObject Name="Text23" Left="255.15" Width="66.15" Height="28.35" Border.Lines="All" Text="[Totalwjhs]" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
        <TextObject Name="Text24" Left="321.3" Width="66.15" Height="28.35" Border.Lines="All" Text="[Totalsjhs]" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
        <TextObject Name="Text25" Left="189" Width="66.15" Height="28.35" Border.Lines="All" Text="[Totalyjhs]" HorzAlign="Center" VertAlign="Center" Font="宋体, 9pt"/>
        <TextObject Name="Text26" Left="481.95" Width="94.5" Height="28.35" Border.Lines="All" Text="[Totalwjje]" Format="Currency" Format.UseLocale="true" HorzAlign="Right" VertAlign="Center" WordWrap="false" Font="宋体, 9pt" Trimming="EllipsisCharacter"/>
        <TextObject Name="Text27" Left="576.45" Width="94.5" Height="28.35" Border.Lines="All" Text="[Totalsjje]" Format="Currency" Format.UseLocale="true" HorzAlign="Right" VertAlign="Center" WordWrap="false" Font="宋体, 9pt" Trimming="EllipsisCharacter"/>
        <TextObject Name="Text28" Left="387.45" Width="94.5" Height="28.35" Border.Lines="All" Text="[Totalyjje]" Format="Currency" Format.UseLocale="true" HorzAlign="Right" VertAlign="Center" WordWrap="false" Font="宋体, 9pt" Trimming="EllipsisCharacter"/>
        <TextObject Name="Text29" Left="670.95" Width="85.05" Height="28.35" Border.Lines="All" Text="[sfl([Totalyjje],[Totalsjje])]" Format="Number" Format.UseLocale="true" HorzAlign="Right" VertAlign="Center" WordWrap="false" Font="宋体, 9pt" Trimming="EllipsisCharacter"/>
      </DataFooterBand>
    </DataBand>
    <PageFooterBand Name="PageFooter1" Top="186.1" Width="756" Height="18.9">
      <TextObject Name="Text21" Left="491.4" Width="226.8" Height="18.9" Text="操作员：[查询条件.当前操作员]" VertAlign="Center" Font="宋体, 9pt"/>
    </PageFooterBand>
  </ReportPage>
</Report>
