517 lines
22 KiB
XML
517 lines
22 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
|
|
<DataSources>
|
|
<DataSource Name="Sauder_NKC">
|
|
<rd:DataSourceID>2999847b-ad29-438e-96ab-bea40c862ca4</rd:DataSourceID>
|
|
<DataSourceReference>Sauder_NKC</DataSourceReference>
|
|
</DataSource>
|
|
</DataSources>
|
|
<rd:ReportID>77c2fb97-bbf0-4e2e-b4c4-c4959aac6fcc</rd:ReportID>
|
|
<Width>5in</Width>
|
|
<Body>
|
|
<Height>1.5in</Height>
|
|
<ColumnSpacing>0.5in</ColumnSpacing>
|
|
<ReportItems>
|
|
<Textbox Name="textbox1">
|
|
<Style>
|
|
<FontFamily>Tahoma</FontFamily>
|
|
<FontSize>20pt</FontSize>
|
|
<Color>SteelBlue</Color>
|
|
<FontWeight>Bold</FontWeight>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
<PaddingBottom>2pt</PaddingBottom>
|
|
</Style>
|
|
<rd:DefaultName>textbox1</rd:DefaultName>
|
|
<Value>Report1</Value>
|
|
<CanGrow>true</CanGrow>
|
|
<Height>0.36in</Height>
|
|
</Textbox>
|
|
<List Name="List1">
|
|
<Style>
|
|
<FontFamily>Tahoma</FontFamily>
|
|
<FontSize>14pt</FontSize>
|
|
<Color>SlateGray</Color>
|
|
</Style>
|
|
<ReportItems>
|
|
<Textbox Name="PlaceCod">
|
|
<Style>
|
|
<FontFamily>Tahoma</FontFamily>
|
|
<FontSize>14pt</FontSize>
|
|
<Color>SlateGray</Color>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
<PaddingBottom>2pt</PaddingBottom>
|
|
</Style>
|
|
<rd:DefaultName>PlaceCod</rd:DefaultName>
|
|
<Value>=Fields!PlaceCod.Value</Value>
|
|
<CanGrow>true</CanGrow>
|
|
<Height>0.27in</Height>
|
|
</Textbox>
|
|
<Table Name="table1">
|
|
<Top>0.5in</Top>
|
|
<Style />
|
|
<Header>
|
|
<RepeatOnNewPage>true</RepeatOnNewPage>
|
|
<TableRows>
|
|
<TableRow>
|
|
<TableCells>
|
|
<TableCell>
|
|
<ReportItems>
|
|
<Textbox Name="textbox2">
|
|
<Style>
|
|
<BackgroundColor>SteelBlue</BackgroundColor>
|
|
<FontFamily>Tahoma</FontFamily>
|
|
<FontSize>11pt</FontSize>
|
|
<FontWeight>Bold</FontWeight>
|
|
<Color>White</Color>
|
|
<BorderStyle>
|
|
<Default>Solid</Default>
|
|
</BorderStyle>
|
|
<BorderColor>
|
|
<Default>LightGrey</Default>
|
|
</BorderColor>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
<PaddingBottom>2pt</PaddingBottom>
|
|
</Style>
|
|
<rd:DefaultName>textbox2</rd:DefaultName>
|
|
<Value>Data Ora Rif</Value>
|
|
<CanGrow>true</CanGrow>
|
|
<Height>0.22in</Height>
|
|
<Width>1in</Width>
|
|
</Textbox>
|
|
</ReportItems>
|
|
</TableCell>
|
|
<TableCell>
|
|
<ReportItems>
|
|
<Textbox Name="textbox3">
|
|
<Style>
|
|
<BackgroundColor>SteelBlue</BackgroundColor>
|
|
<FontFamily>Tahoma</FontFamily>
|
|
<FontSize>11pt</FontSize>
|
|
<FontWeight>Bold</FontWeight>
|
|
<Color>White</Color>
|
|
<BorderStyle>
|
|
<Default>Solid</Default>
|
|
</BorderStyle>
|
|
<BorderColor>
|
|
<Default>LightGrey</Default>
|
|
</BorderColor>
|
|
<TextAlign>Right</TextAlign>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
<PaddingBottom>2pt</PaddingBottom>
|
|
</Style>
|
|
<rd:DefaultName>textbox3</rd:DefaultName>
|
|
<Value>Itm Prod</Value>
|
|
<CanGrow>true</CanGrow>
|
|
<Height>0.22in</Height>
|
|
<Width>1in</Width>
|
|
</Textbox>
|
|
</ReportItems>
|
|
</TableCell>
|
|
<TableCell>
|
|
<ReportItems>
|
|
<Textbox Name="textbox4">
|
|
<Style>
|
|
<BackgroundColor>SteelBlue</BackgroundColor>
|
|
<FontFamily>Tahoma</FontFamily>
|
|
<FontSize>11pt</FontSize>
|
|
<FontWeight>Bold</FontWeight>
|
|
<Color>White</Color>
|
|
<BorderStyle>
|
|
<Default>Solid</Default>
|
|
</BorderStyle>
|
|
<BorderColor>
|
|
<Default>LightGrey</Default>
|
|
</BorderColor>
|
|
<TextAlign>Right</TextAlign>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
<PaddingBottom>2pt</PaddingBottom>
|
|
</Style>
|
|
<rd:DefaultName>textbox4</rd:DefaultName>
|
|
<Value>Itm Scrap</Value>
|
|
<CanGrow>true</CanGrow>
|
|
<Height>0.22in</Height>
|
|
<Width>1in</Width>
|
|
</Textbox>
|
|
</ReportItems>
|
|
</TableCell>
|
|
<TableCell>
|
|
<ReportItems>
|
|
<Textbox Name="textbox5">
|
|
<Style>
|
|
<BackgroundColor>SteelBlue</BackgroundColor>
|
|
<FontFamily>Tahoma</FontFamily>
|
|
<FontSize>11pt</FontSize>
|
|
<FontWeight>Bold</FontWeight>
|
|
<Color>White</Color>
|
|
<BorderStyle>
|
|
<Default>Solid</Default>
|
|
</BorderStyle>
|
|
<BorderColor>
|
|
<Default>LightGrey</Default>
|
|
</BorderColor>
|
|
<TextAlign>Right</TextAlign>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
<PaddingBottom>2pt</PaddingBottom>
|
|
</Style>
|
|
<rd:DefaultName>textbox5</rd:DefaultName>
|
|
<Value>Min Green</Value>
|
|
<CanGrow>true</CanGrow>
|
|
<Height>0.22in</Height>
|
|
<Width>1in</Width>
|
|
</Textbox>
|
|
</ReportItems>
|
|
</TableCell>
|
|
</TableCells>
|
|
<Height>0.22in</Height>
|
|
</TableRow>
|
|
</TableRows>
|
|
</Header>
|
|
<Details>
|
|
<TableRows>
|
|
<TableRow>
|
|
<TableCells>
|
|
<TableCell>
|
|
<ReportItems>
|
|
<Textbox Name="DataOraRif">
|
|
<Style>
|
|
<FontFamily>Tahoma</FontFamily>
|
|
<FontSize>10pt</FontSize>
|
|
<BorderStyle>
|
|
<Default>Solid</Default>
|
|
</BorderStyle>
|
|
<BorderColor>
|
|
<Default>LightGrey</Default>
|
|
</BorderColor>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
<PaddingBottom>2pt</PaddingBottom>
|
|
</Style>
|
|
<rd:DefaultName>DataOraRif</rd:DefaultName>
|
|
<Value>=Fields!DataOraRif.Value</Value>
|
|
<HideDuplicates>DataSet1</HideDuplicates>
|
|
<CanGrow>true</CanGrow>
|
|
<Height>0.21in</Height>
|
|
<Width>1in</Width>
|
|
</Textbox>
|
|
</ReportItems>
|
|
</TableCell>
|
|
<TableCell>
|
|
<ReportItems>
|
|
<Textbox Name="ItmProd">
|
|
<Style>
|
|
<FontFamily>Tahoma</FontFamily>
|
|
<FontSize>10pt</FontSize>
|
|
<BorderStyle>
|
|
<Default>Solid</Default>
|
|
</BorderStyle>
|
|
<BorderColor>
|
|
<Default>LightGrey</Default>
|
|
</BorderColor>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
<PaddingBottom>2pt</PaddingBottom>
|
|
</Style>
|
|
<rd:DefaultName>ItmProd</rd:DefaultName>
|
|
<Value>=Fields!ItmProd.Value</Value>
|
|
<CanGrow>true</CanGrow>
|
|
<Height>0.21in</Height>
|
|
<Width>1in</Width>
|
|
</Textbox>
|
|
</ReportItems>
|
|
</TableCell>
|
|
<TableCell>
|
|
<ReportItems>
|
|
<Textbox Name="ItmScrap">
|
|
<Style>
|
|
<FontFamily>Tahoma</FontFamily>
|
|
<FontSize>10pt</FontSize>
|
|
<BorderStyle>
|
|
<Default>Solid</Default>
|
|
</BorderStyle>
|
|
<BorderColor>
|
|
<Default>LightGrey</Default>
|
|
</BorderColor>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
<PaddingBottom>2pt</PaddingBottom>
|
|
</Style>
|
|
<rd:DefaultName>ItmScrap</rd:DefaultName>
|
|
<Value>=Fields!ItmScrap.Value</Value>
|
|
<CanGrow>true</CanGrow>
|
|
<Height>0.21in</Height>
|
|
<Width>1in</Width>
|
|
</Textbox>
|
|
</ReportItems>
|
|
</TableCell>
|
|
<TableCell>
|
|
<ReportItems>
|
|
<Textbox Name="MinGreen">
|
|
<Style>
|
|
<FontFamily>Tahoma</FontFamily>
|
|
<FontSize>10pt</FontSize>
|
|
<BorderStyle>
|
|
<Default>Solid</Default>
|
|
</BorderStyle>
|
|
<BorderColor>
|
|
<Default>LightGrey</Default>
|
|
</BorderColor>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
<PaddingBottom>2pt</PaddingBottom>
|
|
</Style>
|
|
<rd:DefaultName>MinGreen</rd:DefaultName>
|
|
<Value>=Fields!MinGreen.Value</Value>
|
|
<CanGrow>true</CanGrow>
|
|
<Height>0.21in</Height>
|
|
<Width>1in</Width>
|
|
</Textbox>
|
|
</ReportItems>
|
|
</TableCell>
|
|
</TableCells>
|
|
<Height>0.21in</Height>
|
|
</TableRow>
|
|
</TableRows>
|
|
</Details>
|
|
<TableColumns>
|
|
<TableColumn>
|
|
<Width>1in</Width>
|
|
</TableColumn>
|
|
<TableColumn>
|
|
<Width>1in</Width>
|
|
</TableColumn>
|
|
<TableColumn>
|
|
<Width>1in</Width>
|
|
</TableColumn>
|
|
<TableColumn>
|
|
<Width>1in</Width>
|
|
</TableColumn>
|
|
</TableColumns>
|
|
<DataSetName>DataSet1</DataSetName>
|
|
<TableGroups>
|
|
<TableGroup>
|
|
<Grouping Name="table1_DataOraRif">
|
|
<GroupExpressions>
|
|
<GroupExpression>=Fields!DataOraRif.Value</GroupExpression>
|
|
</GroupExpressions>
|
|
</Grouping>
|
|
<Sorting>
|
|
<SortBy>
|
|
<SortExpression>=Fields!DataOraRif.Value</SortExpression>
|
|
</SortBy>
|
|
</Sorting>
|
|
<Footer>
|
|
<TableRows>
|
|
<TableRow>
|
|
<TableCells>
|
|
<TableCell>
|
|
<ReportItems>
|
|
<Textbox Name="textbox6">
|
|
<Style>
|
|
<FontFamily>Tahoma</FontFamily>
|
|
<FontSize>10pt</FontSize>
|
|
<FontWeight>Bold</FontWeight>
|
|
<Color>White</Color>
|
|
<BackgroundColor>#6e9eca</BackgroundColor>
|
|
<BorderStyle>
|
|
<Default>Solid</Default>
|
|
</BorderStyle>
|
|
<BorderColor>
|
|
<Default>LightGrey</Default>
|
|
</BorderColor>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
<PaddingBottom>2pt</PaddingBottom>
|
|
</Style>
|
|
<rd:DefaultName>textbox6</rd:DefaultName>
|
|
<Value>Total</Value>
|
|
<CanGrow>true</CanGrow>
|
|
<Height>0.21in</Height>
|
|
<Width>1in</Width>
|
|
</Textbox>
|
|
</ReportItems>
|
|
</TableCell>
|
|
<TableCell>
|
|
<ReportItems>
|
|
<Textbox Name="textbox7">
|
|
<Style>
|
|
<FontFamily>Tahoma</FontFamily>
|
|
<FontSize>10pt</FontSize>
|
|
<FontWeight>Bold</FontWeight>
|
|
<Color>White</Color>
|
|
<BackgroundColor>#6e9eca</BackgroundColor>
|
|
<BorderStyle>
|
|
<Default>Solid</Default>
|
|
</BorderStyle>
|
|
<BorderColor>
|
|
<Default>LightGrey</Default>
|
|
</BorderColor>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
<PaddingBottom>2pt</PaddingBottom>
|
|
</Style>
|
|
<rd:DefaultName>textbox7</rd:DefaultName>
|
|
<Value>=Sum(Fields!ItmProd.Value)</Value>
|
|
<CanGrow>true</CanGrow>
|
|
<Height>0.21in</Height>
|
|
<Width>1in</Width>
|
|
</Textbox>
|
|
</ReportItems>
|
|
</TableCell>
|
|
<TableCell>
|
|
<ReportItems>
|
|
<Textbox Name="textbox8">
|
|
<Style>
|
|
<FontFamily>Tahoma</FontFamily>
|
|
<FontSize>10pt</FontSize>
|
|
<FontWeight>Bold</FontWeight>
|
|
<Color>White</Color>
|
|
<BackgroundColor>#6e9eca</BackgroundColor>
|
|
<BorderStyle>
|
|
<Default>Solid</Default>
|
|
</BorderStyle>
|
|
<BorderColor>
|
|
<Default>LightGrey</Default>
|
|
</BorderColor>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
<PaddingBottom>2pt</PaddingBottom>
|
|
</Style>
|
|
<rd:DefaultName>textbox8</rd:DefaultName>
|
|
<Value>=Sum(Fields!ItmScrap.Value)</Value>
|
|
<CanGrow>true</CanGrow>
|
|
<Height>0.21in</Height>
|
|
<Width>1in</Width>
|
|
</Textbox>
|
|
</ReportItems>
|
|
</TableCell>
|
|
<TableCell>
|
|
<ReportItems>
|
|
<Textbox Name="textbox9">
|
|
<Style>
|
|
<FontFamily>Tahoma</FontFamily>
|
|
<FontSize>10pt</FontSize>
|
|
<FontWeight>Bold</FontWeight>
|
|
<Color>White</Color>
|
|
<BackgroundColor>#6e9eca</BackgroundColor>
|
|
<BorderStyle>
|
|
<Default>Solid</Default>
|
|
</BorderStyle>
|
|
<BorderColor>
|
|
<Default>LightGrey</Default>
|
|
</BorderColor>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
<PaddingBottom>2pt</PaddingBottom>
|
|
</Style>
|
|
<rd:DefaultName>textbox9</rd:DefaultName>
|
|
<Value>=Sum(Fields!MinGreen.Value)</Value>
|
|
<CanGrow>true</CanGrow>
|
|
<Height>0.21in</Height>
|
|
<Width>1in</Width>
|
|
</Textbox>
|
|
</ReportItems>
|
|
</TableCell>
|
|
</TableCells>
|
|
<Height>0.21in</Height>
|
|
</TableRow>
|
|
</TableRows>
|
|
</Footer>
|
|
</TableGroup>
|
|
</TableGroups>
|
|
</Table>
|
|
</ReportItems>
|
|
<Grouping Name="list1_PlaceCod">
|
|
<GroupExpressions>
|
|
<GroupExpression>=Fields!PlaceCod.Value</GroupExpression>
|
|
</GroupExpressions>
|
|
<PageBreakAtEnd>true</PageBreakAtEnd>
|
|
</Grouping>
|
|
<Sorting>
|
|
<SortBy>
|
|
<SortExpression>=Fields!PlaceCod.Value</SortExpression>
|
|
</SortBy>
|
|
</Sorting>
|
|
<Top>0.36in</Top>
|
|
<DataSetName>DataSet1</DataSetName>
|
|
</List>
|
|
</ReportItems>
|
|
</Body>
|
|
<Language>en-US</Language>
|
|
<LeftMargin>1in</LeftMargin>
|
|
<RightMargin>1in</RightMargin>
|
|
<TopMargin>1in</TopMargin>
|
|
<BottomMargin>1in</BottomMargin>
|
|
<PageWidth>8.5in</PageWidth>
|
|
<PageHeight>11in</PageHeight>
|
|
<DataSets>
|
|
<DataSet Name="DataSet1">
|
|
<Fields>
|
|
<Field Name="PlaceCod">
|
|
<DataField>PlaceCod</DataField>
|
|
<rd:TypeName>System.String</rd:TypeName>
|
|
</Field>
|
|
<Field Name="DataOraRif">
|
|
<DataField>DataOraRif</DataField>
|
|
<rd:TypeName>System.DateTime</rd:TypeName>
|
|
</Field>
|
|
<Field Name="ItmProd">
|
|
<DataField>ItmProd</DataField>
|
|
<rd:TypeName>System.Int32</rd:TypeName>
|
|
</Field>
|
|
<Field Name="ItmScrap">
|
|
<DataField>ItmScrap</DataField>
|
|
<rd:TypeName>System.Int32</rd:TypeName>
|
|
</Field>
|
|
<Field Name="MinGreen">
|
|
<DataField>MinGreen</DataField>
|
|
<rd:TypeName>System.Int64</rd:TypeName>
|
|
</Field>
|
|
</Fields>
|
|
<Query>
|
|
<DataSourceName>Sauder_NKC</DataSourceName>
|
|
<CommandType>Text</CommandType>
|
|
<CommandText>EXEC prt.stp_prt_MachineProductionDateHour @dtstart, @DtEnd</CommandText>
|
|
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
|
|
<QueryParameters>
|
|
<QueryParameter Name="@dtstart">
|
|
<Value>=Parameters!dtstart.Value</Value>
|
|
</QueryParameter>
|
|
<QueryParameter Name="@DtEnd">
|
|
<Value>=Parameters!DtEnd.Value</Value>
|
|
</QueryParameter>
|
|
</QueryParameters>
|
|
<Timeout>0</Timeout>
|
|
</Query>
|
|
</DataSet>
|
|
</DataSets>
|
|
<ReportParameters>
|
|
<ReportParameter Name="dtstart">
|
|
<DataType>String</DataType>
|
|
<Prompt>dtstart</Prompt>
|
|
</ReportParameter>
|
|
<ReportParameter Name="DtEnd">
|
|
<DataType>String</DataType>
|
|
<Prompt>Dt End</Prompt>
|
|
</ReportParameter>
|
|
</ReportParameters>
|
|
</Report> |