<?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="MyDsn"> <rd:DataSourceID>e853653e-3333-4270-b7c2-e224d85605fb</rd:DataSourceID> <ConnectionProperties> <DataProvider>SQL</DataProvider> <ConnectString>Data Source=HYPERBOREA;Initial Catalog=DB9975</ConnectString> <IntegratedSecurity>true</IntegratedSecurity> </ConnectionProperties> </DataSource> </DataSources> <InteractiveHeight>11in</InteractiveHeight> <rd:DrawGrid>true</rd:DrawGrid> <InteractiveWidth>8.5in</InteractiveWidth> <rd:SnapToGrid>true</rd:SnapToGrid> <RightMargin>1in</RightMargin> <LeftMargin>1in</LeftMargin> <BottomMargin>1in</BottomMargin> <rd:ReportID>29920f97-9d67-43a2-8ef3-db6b2936a636</rd:ReportID> <PageWidth>11in</PageWidth> <DataSets> <DataSet Name="MyDsn"> <Fields> <Field Name="Per_"> <DataField>Per#</DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="Name"> <DataField>Name</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="Position"> <DataField>Position</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="Organization"> <DataField>Organization</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="Start_Date"> <DataField>Start Date</DataField> <rd:TypeName>System.DateTime</rd:TypeName> </Field> </Fields> <Query> <DataSourceName>MyDsn</DataSourceName> <CommandText>EXECUTE dbo.PersonnelAssignment</CommandText> <rd:UseGenericDesigner>true</rd:UseGenericDesigner> </Query> </DataSet> </DataSets> <Width>9in</Width> <Body> <ReportItems> <Textbox Name="textbox1"> <rd:DefaultName>textbox1</rd:DefaultName> <Style> <Color>SteelBlue</Color> <FontFamily>Tahoma</FontFamily> <FontSize>20pt</FontSize> <FontWeight>700</FontWeight> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> <ZIndex>1</ZIndex> <CanGrow>true</CanGrow> <Height>0.36in</Height> <Value>HWA2_P4_PA</Value> </Textbox> <Table Name="table1"> <DataSetName>MyDsn</DataSetName> <Top>0.36in</Top> <Details> <TableRows> <TableRow> <TableCells> <TableCell> <ReportItems> <Textbox Name="Per_"> <rd:DefaultName>Per_</rd:DefaultName> <Style> <BorderColor> <Default>LightGrey</Default> </BorderColor> <BorderStyle> <Default>Solid</Default> </BorderStyle> <FontFamily>Tahoma</FontFamily> <TextAlign>Right</TextAlign> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> <ZIndex>4</ZIndex> <CanGrow>true</CanGrow> <Value>=Fields!Per_.Value</Value> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="Name"> <rd:DefaultName>Name</rd:DefaultName> <Style> <BorderColor> <Default>LightGrey</Default> </BorderColor> <BorderStyle> <Default>Solid</Default> </BorderStyle> <FontFamily>Tahoma</FontFamily> <TextAlign>Left</TextAlign> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> <ZIndex>3</ZIndex> <CanGrow>true</CanGrow> <Value>=Fields!Name.Value</Value> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="Position"> <rd:DefaultName>Position</rd:DefaultName> <Style> <BorderColor> <Default>LightGrey</Default> </BorderColor> <BorderStyle> <Default>Solid</Default> </BorderStyle> <FontFamily>Tahoma</FontFamily> <TextAlign>Left</TextAlign> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> <ZIndex>2</ZIndex> <CanGrow>true</CanGrow> <Value>=Fields!Position.Value</Value> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="Organization"> <rd:DefaultName>Organization</rd:DefaultName> <Style> <BorderColor> <Default>LightGrey</Default> </BorderColor> <BorderStyle> <Default>Solid</Default> </BorderStyle> <FontFamily>Tahoma</FontFamily> <TextAlign>Left</TextAlign> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> <ZIndex>1</ZIndex> <CanGrow>true</CanGrow> <Value>=Fields!Organization.Value</Value> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="Start_Date"> <rd:DefaultName>Start_Date</rd:DefaultName> <Style> <BorderColor> <Default>LightGrey</Default> </BorderColor> <BorderStyle> <Default>Solid</Default> </BorderStyle> <FontFamily>Tahoma</FontFamily> <Format>MM/dd/yyyy</Format> <TextAlign>Left</TextAlign> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> <CanGrow>true</CanGrow> <Value>=Fields!Start_Date.Value</Value> </Textbox> </ReportItems> </TableCell> </TableCells> <Height>0.21in</Height> </TableRow> </TableRows> </Details> <Header> <TableRows> <TableRow> <TableCells> <TableCell> <ReportItems> <Textbox Name="textbox2"> <rd:DefaultName>textbox2</rd:DefaultName> <Style> <Color>White</Color> <BackgroundColor>SteelBlue</BackgroundColor> <BorderColor> <Default>LightGrey</Default> </BorderColor> <BorderStyle> <Default>Solid</Default> </BorderStyle> <FontFamily>Tahoma</FontFamily> <FontSize>11pt</FontSize> <FontWeight>700</FontWeight> <TextAlign>Right</TextAlign> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> <ZIndex>9</ZIndex> <CanGrow>true</CanGrow> <Value>per# </Value> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox3"> <rd:DefaultName>textbox3</rd:DefaultName> <Style> <Color>White</Color> <BackgroundColor>SteelBlue</BackgroundColor> <BorderColor> <Default>LightGrey</Default> </BorderColor> <BorderStyle> <Default>Solid</Default> </BorderStyle> <FontFamily>Tahoma</FontFamily> <FontSize>11pt</FontSize> <FontWeight>700</FontWeight> <TextAlign>Left</TextAlign> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> <ZIndex>8</ZIndex> <CanGrow>true</CanGrow> <Value>Name</Value> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox4"> <rd:DefaultName>textbox4</rd:DefaultName> <Style> <Color>White</Color> <BackgroundColor>SteelBlue</BackgroundColor> <BorderColor> <Default>LightGrey</Default> </BorderColor> <BorderStyle> <Default>Solid</Default> </BorderStyle> <FontFamily>Tahoma</FontFamily> <FontSize>11pt</FontSize> <FontWeight>700</FontWeight> <TextAlign>Left</TextAlign> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> <ZIndex>7</ZIndex> <CanGrow>true</CanGrow> <Value>Position</Value> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox5"> <rd:DefaultName>textbox5</rd:DefaultName> <Style> <Color>White</Color> <BackgroundColor>SteelBlue</BackgroundColor> <BorderColor> <Default>LightGrey</Default> </BorderColor> <BorderStyle> <Default>Solid</Default> </BorderStyle> <FontFamily>Tahoma</FontFamily> <FontSize>11pt</FontSize> <FontWeight>700</FontWeight> <TextAlign>Left</TextAlign> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> <ZIndex>6</ZIndex> <CanGrow>true</CanGrow> <Value>Organization</Value> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox6"> <rd:DefaultName>textbox6</rd:DefaultName> <Style> <Color>White</Color> <BackgroundColor>SteelBlue</BackgroundColor> <BorderColor> <Default>LightGrey</Default> </BorderColor> <BorderStyle> <Default>Solid</Default> </BorderStyle> <FontFamily>Tahoma</FontFamily> <FontSize>11pt</FontSize> <FontWeight>700</FontWeight> <TextAlign>Left</TextAlign> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> <ZIndex>5</ZIndex> <CanGrow>true</CanGrow> <Value>Start Date</Value> </Textbox> </ReportItems> </TableCell> </TableCells> <Height>0.22in</Height> </TableRow> </TableRows> <RepeatOnNewPage>true</RepeatOnNewPage> </Header> <TableColumns> <TableColumn> <Width>0.5in</Width> </TableColumn> <TableColumn> <Width>2.5in</Width> </TableColumn> <TableColumn> <Width>2.5in</Width> </TableColumn> <TableColumn> <Width>2.5in</Width> </TableColumn> <TableColumn> <Width>1in</Width> </TableColumn> </TableColumns> </Table> </ReportItems> <Height>0.79in</Height> </Body> <Language>en-US</Language> <TopMargin>1in</TopMargin> <PageHeight>8.5in</PageHeight> </Report>