salesbyyear.srd

c#源代码

<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<SharpReport>
   <section name="SharpReportCore.ReportSettings">
      <SqlParams>
         <params>
            <DataType value="DateTime"/>
            <DefaultValue value="01.10.1996 00:00:00"/>
            <ParameterDirection value="Input"/>
            <Nullable value="False"/>
            <ParameterName value="@Beginning_Date"/>
            <Prompt value=""/>
         </params>
         <params>
            <DataType value="DateTime"/>
            <DefaultValue value="31.12.1996 00:00:00"/>
            <ParameterDirection value="Input"/>
            <Nullable value="False"/>
            <ParameterName value="@Ending_Date"/>
            <Prompt value=""/>
         </params>
      </SqlParams>
      <ReportType value="DataReport"/>
      <CommandText value="[Sales by Year]"/>
      <CommandType value="StoredProcedure"/>
      <DataModel value="PullData"/>
      <DefaultFont value="Microsoft Sans Serif, 16pt"/>
      <ReportName value="SharpReport1"/>
      <DefaultMargins value="50; 50; 50; 50"/>
   </section>
   <section name="ReportHeader">
      <BackColor value="Color [Window]"/>
      <Size value="{Width=803, Height=36}"/>
      <CanGrow value="False"/>
      <CanShrink value="False"/>
      <Name value="ReportHeader"/>
      <PageBreakAfter value="False"/>
      <PageBreakBefore value="False"/>
      <Location value="{X=0,Y=0}"/>
      <controls/>
   </section>
   <section name="ReportPageHeader">
      <BackColor value="Color [Window]"/>
      <Size value="{Width=803, Height=94}"/>
      <CanGrow value="False"/>
      <CanShrink value="False"/>
      <Name value="ReportPageHeader"/>
      <PageBreakAfter value="False"/>
      <PageBreakBefore value="False"/>
      <Location value="{X=0,Y=0}"/>
      <controls>
         <control type="SharpReport.ReportItems.ReportTextItem" basetype="SharpReportCore.BaseTextItem">
            <Size value="{Width=715, Height=34}"/>
            <Location value="{X=50,Y=0}"/>
            <Font value="Microsoft Sans Serif, 16pt"/>
            <Text value="SalesByYear / Stored Procedure with 2 Parameters"/>
            <FormatString value=""/>
            <StringAlignment value="Center"/>
            <StandartStringFormat value="[StringFormat, FormatFlags=FitBlackBox, LineLimit, NoClip]"/>
            <Site value=""/>
            <DrawBorder value="False"/>
            <ForeColor value="Color [ControlText]"/>
            <Visible value="True"/>
            <CanGrow value="False"/>
            <CanShrink value="False"/>
            <Name value="ReportTextItem"/>
            <PageBreakAfter value="False"/>
            <PageBreakBefore value="False"/>
            <BackColor value="Color [LightGray]"/>
         </control>
         <control type="SharpReport.ReportItems.ReportTextItem" basetype="SharpReportCore.BaseTextItem">
            <Size value="{Width=173, Height=25}"/>
            <Location value="{X=50,Y=40}"/>
            <Font value="Microsoft Sans Serif, 16pt"/>
            <Text value="ShippedDate"/>
            <FormatString value=""/>
            <StringAlignment value="Near"/>
            <StandartStringFormat value="[StringFormat, FormatFlags=FitBlackBox, LineLimit, NoClip]"/>
            <Site value=""/>
            <DrawBorder value="False"/>
            <ForeColor value="Color [ControlText]"/>
            <Visible value="True"/>
            <CanGrow value="False"/>
            <CanShrink value="False"/>
            <Name value="ReportTextItem"/>
            <PageBreakAfter value="False"/>
            <PageBreakBefore value="False"/>
            <BackColor value="Color [White]"/>
         </control>
         <control type="SharpReport.ReportItems.ReportTextItem" basetype="SharpReportCore.BaseTextItem">
            <Size value="{Width=113, Height=27}"/>
            <Location value="{X=289,Y=40}"/>
            <Font value="Microsoft Sans Serif, 16pt"/>
            <Text value="OrderID"/>
            <FormatString value=""/>
            <StringAlignment value="Far"/>
            <StandartStringFormat value="[StringFormat, FormatFlags=FitBlackBox, LineLimit, NoClip]"/>
            <Site value=""/>
            <DrawBorder value="False"/>
            <ForeColor value="Color [ControlText]"/>
            <Visible value="True"/>
            <CanGrow value="False"/>
            <CanShrink value="False"/>
            <Name value="ReportTextItem"/>
            <PageBreakAfter value="False"/>
            <PageBreakBefore value="False"/>
            <BackColor value="Color [White]"/>
         </control>
         <control type="SharpReport.ReportItems.ReportTextItem" basetype="SharpReportCore.BaseTextItem">
            <Size value="{Width=173, Height=25}"/>
            <Location value="{X=412,Y=40}"/>
            <Font value="Microsoft Sans Serif, 16pt"/>
            <Text value="Subtotal"/>
            <FormatString value=""/>
            <StringAlignment value="Far"/>
            <StandartStringFormat value="[StringFormat, FormatFlags=FitBlackBox, LineLimit, NoClip]"/>
            <Site value=""/>
            <DrawBorder value="False"/>
            <ForeColor value="Color [ControlText]"/>
            <Visible value="True"/>
            <CanGrow value="False"/>
            <CanShrink value="False"/>
            <Name value="ReportTextItem"/>
            <PageBreakAfter value="False"/>
            <PageBreakBefore value="False"/>
            <BackColor value="Color [White]"/>
         </control>
         <control type="SharpReport.ReportItems.ReportTextItem" basetype="SharpReportCore.BaseTextItem">
            <Size value="{Width=173, Height=25}"/>
            <Location value="{X=593,Y=40}"/>
            <Font value="Microsoft Sans Serif, 16pt"/>
            <Text value="Year"/>
            <FormatString value=""/>
            <StringAlignment value="Far"/>
            <StandartStringFormat value="[StringFormat, FormatFlags=FitBlackBox, LineLimit, NoClip]"/>
            <Site value=""/>
            <DrawBorder value="False"/>
            <ForeColor value="Color [ControlText]"/>
            <Visible value="True"/>
            <CanGrow value="False"/>
            <CanShrink value="False"/>
            <Name value="ReportTextItem"/>
            <PageBreakAfter value="False"/>
            <PageBreakBefore value="False"/>
            <BackColor value="Color [White]"/>
         </control>
         <control type="SharpReport.ReportItems.ReportLineItem" basetype="SharpReportCore.BaseLineItem">
            <Size value="{Width=721, Height=12}"/>
            <Location value="{X=50,Y=77}"/>
            <Thickness value="1"/>
            <DashStyle value="Solid"/>
            <Site value=""/>
            <DrawBorder value="False"/>
            <ForeColor value="Color [ControlText]"/>
            <Font value="Microsoft Sans Serif, 8.25pt"/>
            <Visible value="True"/>
            <CanGrow value="False"/>
            <CanShrink value="False"/>
            <Name value="ReportLineControl"/>
            <PageBreakAfter value="False"/>
            <PageBreakBefore value="False"/>
            <BackColor value="Color [White]"/>
         </control>
      </controls>
   </section>
   <section name="ReportDetail">
      <BackColor value="Color [Window]"/>
      <Size value="{Width=803, Height=36}"/>
      <CanGrow value="False"/>
      <CanShrink value="False"/>
      <Name value="ReportDetail"/>
      <PageBreakAfter value="False"/>
      <PageBreakBefore value="False"/>
      <Location value="{X=0,Y=0}"/>
      <controls>
         <control type="SharpReport.ReportItems.ReportDataItem" basetype="SharpReportCore.BaseDataItem">
            <Size value="{Width=242, Height=29}"/>
            <Location value="{X=50,Y=5}"/>
            <Font value="Microsoft Sans Serif, 16pt"/>
            <Text value="ShippedDate"/>
            <ColumnName value="ShippedDate"/>
            <DataType value="System.DateTime"/>
            <BaseTableName value="Orders"/>
            <FormatString value="dd.MMM.yyyy"/>
            <StringAlignment value="Near"/>
            <StandartStringFormat value="[StringFormat, FormatFlags=FitBlackBox, LineLimit, NoClip]"/>
            <Site value=""/>
            <DrawBorder value="False"/>
            <ForeColor value="Color [ControlText]"/>
            <Visible value="True"/>
            <CanGrow value="False"/>
            <CanShrink value="False"/>
            <Name value="ReportDbTextItem"/>
            <PageBreakAfter value="False"/>
            <PageBreakBefore value="False"/>
            <BackColor value="Color [White]"/>
         </control>
         <control type="SharpReport.ReportItems.ReportDataItem" basetype="SharpReportCore.BaseDataItem">
            <Size value="{Width=109, Height=25}"/>
            <Location value="{X=294,Y=5}"/>
            <Font value="Microsoft Sans Serif, 16pt"/>
            <Text value="OrderID"/>
            <ColumnName value="OrderID"/>
            <DataType value="System.Int32"/>
            <BaseTableName value="Orders"/>
            <FormatString value=""/>
            <StringAlignment value="Far"/>
            <StandartStringFormat value="[StringFormat, FormatFlags=FitBlackBox, LineLimit, NoClip]"/>
            <Site value=""/>
            <DrawBorder value="False"/>
            <ForeColor value="Color [ControlText]"/>
            <Visible value="True"/>
            <CanGrow value="False"/>
            <CanShrink value="False"/>
            <Name value="ReportDbTextItem"/>
            <PageBreakAfter value="False"/>
            <PageBreakBefore value="False"/>
            <BackColor value="Color [White]"/>
         </control>
         <control type="SharpReport.ReportItems.ReportDataItem" basetype="SharpReportCore.BaseDataItem">
            <Size value="{Width=173, Height=25}"/>
            <Location value="{X=412,Y=5}"/>
            <Font value="Microsoft Sans Serif, 16pt"/>
            <Text value="Subtotal"/>
            <ColumnName value="Subtotal"/>
            <DataType value="System.Decimal"/>
            <BaseTableName value=""/>
            <FormatString value="0.00"/>
            <StringAlignment value="Far"/>
            <StandartStringFormat value="[StringFormat, FormatFlags=FitBlackBox, LineLimit, NoClip]"/>
            <Site value=""/>
            <DrawBorder value="False"/>
            <ForeColor value="Color [ControlText]"/>
            <Visible value="True"/>
            <CanGrow value="False"/>
            <CanShrink value="False"/>
            <Name value="ReportDbTextItem"/>
            <PageBreakAfter value="False"/>
            <PageBreakBefore value="False"/>
            <BackColor value="Color [White]"/>
         </control>
         <control type="SharpReport.ReportItems.ReportDataItem" basetype="SharpReportCore.BaseDataItem">
            <Size value="{Width=173, Height=25}"/>
            <Location value="{X=593,Y=5}"/>
            <Font value="Microsoft Sans Serif, 16pt"/>
            <Text value="Year"/>
            <ColumnName value="Year"/>
            <DataType value="System.String"/>
            <BaseTableName value=""/>
            <FormatString value=""/>
            <StringAlignment value="Far"/>
            <StandartStringFormat value="[StringFormat, FormatFlags=FitBlackBox, LineLimit, NoClip]"/>
            <Site value=""/>
            <DrawBorder value="False"/>
            <ForeColor value="Color [ControlText]"/>
            <Visible value="True"/>
            <CanGrow value="False"/>
            <CanShrink value="False"/>
            <Name value="ReportDbTextItem"/>
            <PageBreakAfter value="False"/>
            <PageBreakBefore value="False"/>
            <BackColor value="Color [White]"/>
         </control>
      </controls>
   </section>
   <section name="ReportPageFooter">
      <BackColor value="Color [Window]"/>
      <Size value="{Width=803, Height=36}"/>
      <CanGrow value="False"/>
      <CanShrink value="False"/>
      <Name value="ReportPageFooter"/>
      <PageBreakAfter value="False"/>
      <PageBreakBefore value="False"/>
      <Location value="{X=0,Y=0}"/>
      <controls>
         <control type="SharpReport.ReportItems.Functions.PageNumber" basetype="SharpReportCore.BasePageNumber">
            <Size value="{Width=181, Height=25}"/>
            <Location value="{X=50,Y=0}"/>
            <Font value="Microsoft Sans Serif, 16pt"/>
            <Text value="Seiten Nummer"/>
            <FormatString value=""/>
            <StringAlignment value="Near"/>
            <StandartStringFormat value="[StringFormat, FormatFlags=FitBlackBox, LineLimit, NoClip]"/>
            <Site value=""/>
            <DrawBorder value="False"/>
            <ForeColor value="Color [ControlText]"/>
            <Visible value="True"/>
            <CanGrow value="False"/>
            <CanShrink value="False"/>
            <Name value="PageNumber"/>
            <PageBreakAfter value="False"/>
            <PageBreakBefore value="False"/>
            <BackColor value="Color [White]"/>
         </control>
      </controls>
   </section>
   <section name="ReportFooter">
      <BackColor value="Color [Window]"/>
      <Size value="{Width=803, Height=36}"/>
      <CanGrow value="False"/>
      <CanShrink value="False"/>
      <Name value="ReportFooter"/>
      <PageBreakAfter value="False"/>
      <PageBreakBefore value="False"/>
      <Location value="{X=0,Y=0}"/>
      <controls/>
   </section>
</SharpReport>