SSRS Report – BOM_Material

SSRS Report –  BOM_Material

  1. Create required views
  2. Create required data source
  3. Copy the below xml file and save it as “BOM_report.rdl”

    <Report xmlns:rd=”http://schemas.microsoft.com/SQLServer/reporting/reportdesigner” xmlns:cl=”http://schemas.microsoft.com/sqlserver/reporting/2010/01/componentdefinition” xmlns=”http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition“>   <AutoRefresh>0</AutoRefresh>   <DataSources>     <DataSource Name=”DataSource1″>       <DataSourceReference>/Data Sources/DYNAMICSGP</DataSourceReference>       <rd:SecurityType>None</rd:SecurityType>       <rd:DataSourceID>36ee73ee-567e-46b5-9ed7-2c20fb5a7c3a</rd:DataSourceID>     </DataSource>   </DataSources>   <DataSets>     <DataSet Name=”BOM_Material”>       <Query>         <DataSourceName>DataSource1</DataSourceName>         <CommandText>select * from zreports..bom_Material</CommandText>         <rd:UseGenericDesigner>true</rd:UseGenericDesigner>       </Query>       <Fields>         <Field Name=”Item”>           <DataField>Item</DataField>           <rd:TypeName>System.String</rd:TypeName>         </Field>         <Field Name=”Component”>           <DataField>Component</DataField>           <rd:TypeName>System.String</rd:TypeName>         </Field>         <Field Name=”Description”>           <DataField>Description</DataField>           <rd:TypeName>System.String</rd:TypeName>         </Field>         <Field Name=”Level”>           <DataField>Level</DataField>           <rd:TypeName>System.Int32</rd:TypeName>         </Field>         <Field Name=”MakeOrBuy”>           <DataField>MakeOrBuy</DataField>           <rd:TypeName>System.String</rd:TypeName>         </Field>         <Field Name=”Quantity”>           <DataField>Quantity</DataField>           <rd:TypeName>System.Decimal</rd:TypeName>         </Field>         <Field Name=”RoutingName”>           <DataField>RoutingName</DataField>           <rd:TypeName>System.String</rd:TypeName>         </Field>         <Field Name=”Std_Cost_Per_Unit”>           <DataField>Std Cost Per Unit</DataField>           <rd:TypeName>System.Decimal</rd:TypeName>         </Field>         <Field Name=”Variable_OH_Per_Unit”>           <DataField>Variable OH Per Unit</DataField>           <rd:TypeName>System.Decimal</rd:TypeName>         </Field>         <Field Name=”Material_Cost_at_Level_1″>           <DataField>Material Cost at Level 1</DataField>           <rd:TypeName>System.Decimal</rd:TypeName>         </Field>         <Field Name=”Material_VOH_at_Level_1″>           <DataField>Material VOH at Level 1</DataField>           <rd:TypeName>System.Decimal</rd:TypeName>         </Field>         <Field Name=”Material_Cost_of_Buy_Item”>           <DataField>Material Cost of Buy Item</DataField>           <rd:TypeName>System.Decimal</rd:TypeName>         </Field>         <Field Name=”Material_VO1H_of_Buy_Item”>           <DataField>Material VO1H of Buy Item</DataField>           <rd:TypeName>System.Decimal</rd:TypeName>         </Field>         <Field Name=”LastMOactivity”>           <DataField>LastMOactivity</DataField>           <rd:TypeName>System.DateTime</rd:TypeName>         </Field>         <Field Name=”EffectiveDate”>           <DataField>EffectiveDate</DataField>           <rd:TypeName>System.DateTime</rd:TypeName>         </Field>         <Field Name=”ItemType”>           <DataField>ItemType</DataField>           <rd:TypeName>System.String</rd:TypeName>         </Field>         <Field Name=”UOMSCHDL”>           <DataField>UOMSCHDL</DataField>           <rd:TypeName>System.String</rd:TypeName>         </Field>       </Fields>     </DataSet>     <DataSet Name=”DataSet1″>       <Query>         <DataSourceName>DataSource1</DataSourceName>         <CommandText>if object_id(‘zreports..BOM_Material’) is not null drop table zreports..BOM_Material; select    t.Item,   t.Component,   [Description] = REPLICATE(‘_’,t.level*3) + t.[Item Description],   t.Level,   t.MakeOrBuy,   t.Quantity,   t.RoutingName,   t.[Std Cost Per Unit],   t.[Variable OH Per Unit],   [Material Cost at Level 1] = case t.level when 1 then t.Quantity * t.[Std Cost Per Unit] else 0 end,   [Material VOH at Level 1] = case t.level when 1 then t.Quantity * t.[Variable OH Per Unit] else 0 end,   [Material Cost of Buy Item] = case t.MakeOrBuy when ‘Make’ then t.Quantity * t.[Std Cost Per Unit] else 0 end,   [Material VO1H of Buy Item] = case t.MakeOrBuy when ‘Make’ then t.Quantity * t.[Variable OH Per Unit] else 0 end,   LastMOactivity,   EffectiveDate,   ItemType,   UOMSCHDL

    into    zreports..BOM_Material

    from

    (  SELECT     zero = CAST (dbo.bom.zero as int),    one = CAST (dbo.bom.one as int),    two = CAST (dbo.bom.two as int),    three = CAST (dbo.bom.three as int),    four = CAST (dbo.bom.four as int),    five = CAST (dbo.bom.five as int),    six = CAST (dbo.bom.six as int),    seven = CAST (dbo.bom.seven as int),    eight = CAST (dbo.bom.eight as int),    nine = CAST (dbo.bom.nine as int),      ISNULL(     ( SELECT     ROUTINGNAME_I      FROM       dbo.RT010001      WHERE     (ITEMNMBR = dbo.BOM.ITEM10) AND (RTPRIMARY_I = 1)     ), ‘NoRouting’) AS RoutingName,           LastMOactivity=isnull((select max(STRTDATE) from WO010032 where ITEMNMBR = dbo.BOM.ITEM10 group by ITEMNMBR  ),”),      EffectiveDate = isnull((select max(EFFECTIVEINDATE_I)  from BOM0 where ITEM0 = dbo.bom.item10 group by item0),”),      ItemType = isnull((select case ITEMTYPE  when 1 then ‘Sales Inventory’        when 2 then ‘Discontinued’          when 3 then ‘Kit’             when 4 then ‘Misc Charges’        when 5 then ‘Serivce’        when 6 then ‘Flat fee’ end      from IV00101 where dbo.BOM.ITEM0 = iv00101.ITEMNMBR ),”),      dbo.BOM.[LEVEL] as [Level],      dbo.BOM.ITEM0 AS Item,      dbo.BOM.ITEM10 AS Component,      dbo.BOM.ITEMDESC AS [Item Description],      MakeOrBuy = CASE dbo.IVR10015.MAKEBUYCODE_I WHEN 1 THEN ‘Make’ WHEN 3 THEN ‘Buy’ WHEN 2 THEN ‘MakeBuy’ ELSE ‘Invalid’ END,      Quantity  = dbo.BOM.Q0 * dbo.BOM.Q1 * dbo.BOM.Q2 * dbo.BOM.Q3 * dbo.BOM.Q4 * dbo.BOM.Q5 * dbo.BOM.Q6 * dbo.BOM.Q7 * dbo.BOM.Q8 * dbo.BOM.Q9  ,      [Std Cost Per Unit]=ROUND(isnull(dbo.CT00003.COST_I,0),5,CAST(isnull(dbo.CT00003.COST_I,0)*POWER(10,5) AS INT)%2)  ,        [Variable OH Per Unit]=ROUND(isnull(dbo.CT00003.Variable_Overhead_Amount,0),5,CAST(isnull(dbo.CT00003.Variable_Overhead_Amount,0)*POWER(10,5) AS INT)%2),

    UOMSCHDL = (select top 1 UOMSCHDL from iv00101 as uomitem where uomitem.itemnmbr = dbo.BOM.ITEM10  )

    FROM      dbo.IVR10015 INNER JOIN      dbo.CT00003 ON dbo.IVR10015.ITEMNMBR = dbo.CT00003.ITEMNMBR RIGHT OUTER JOIN      dbo.BOM ON dbo.CT00003.ITEMNMBR = dbo.BOM.ITEM10 )  as T

    Order by  t.item,t.zero,t.one,t.two,t.three,t.four,t.five,t.six,t.seven,t.eight,t.nine asc;

    select ‘Material Compile Complete’ as Status</CommandText>         <rd:UseGenericDesigner>true</rd:UseGenericDesigner>       </Query>       <Fields>         <Field Name=”Status”>           <DataField>Status</DataField>           <rd:TypeName>System.String</rd:TypeName>         </Field>       </Fields>     </DataSet>   </DataSets>   <ReportSections>     <ReportSection>       <Body>         <ReportItems>           <Textbox Name=”ReportTitle”>             <CanGrow>true</CanGrow>             <KeepTogether>true</KeepTogether>             <Paragraphs>               <Paragraph>                 <TextRuns>                   <TextRun>                     <Value>Bill of Materials</Value>                     <Style>                       <FontFamily>Verdana</FontFamily>                       <FontSize>20pt</FontSize>                     </Style>                   </TextRun>                 </TextRuns>                 <Style />               </Paragraph>             </Paragraphs>             <rd:WatermarkTextbox>Title</rd:WatermarkTextbox>             <rd:DefaultName>ReportTitle</rd:DefaultName>             <Left>0.15625in</Left>             <Height>0.4in</Height>             <Width>14.82292in</Width>             <Style>               <Border>                 <Style>None</Style>               </Border>               <PaddingLeft>2pt</PaddingLeft>               <PaddingRight>2pt</PaddingRight>               <PaddingTop>2pt</PaddingTop>               <PaddingBottom>2pt</PaddingBottom>             </Style>           </Textbox>           <Tablix Name=”Bom_Data_Compile_status”>             <TablixBody>               <TablixColumns>                 <TablixColumn>                   <Width>18.68749in</Width>                 </TablixColumn>               </TablixColumns>               <TablixRows>                 <TablixRow>                   <Height>0.25in</Height>                   <TablixCells>                     <TablixCell>                       <CellContents>                         <Textbox Name=”Textbox3″>                           <CanGrow>true</CanGrow>                           <KeepTogether>true</KeepTogether>                           <Paragraphs>                             <Paragraph>                               <TextRuns>                                 <TextRun>                                   <Value>Status</Value>                                   <Style>                                     <FontWeight>Bold</FontWeight>                                   </Style>                                 </TextRun>                               </TextRuns>                               <Style />                             </Paragraph>                           </Paragraphs>                           <rd:DefaultName>Textbox3</rd:DefaultName>                           <Style>                             <Border>                               <Color>LightGrey</Color>                               <Style>Solid</Style>                             </Border>                             <BackgroundColor>Plum</BackgroundColor>                             <PaddingLeft>2pt</PaddingLeft>                             <PaddingRight>2pt</PaddingRight>                             <PaddingTop>2pt</PaddingTop>                             <PaddingBottom>2pt</PaddingBottom>                           </Style>                         </Textbox>                       </CellContents>                     </TablixCell>                   </TablixCells>                 </TablixRow>                 <TablixRow>                   <Height>0.25in</Height>                   <TablixCells>                     <TablixCell>                       <CellContents>                         <Textbox Name=”Status1″>                           <CanGrow>true</CanGrow>                           <KeepTogether>true</KeepTogether>                           <Paragraphs>                             <Paragraph>                               <TextRuns>                                 <TextRun>                                   <Value>=Fields!Status.Value</Value>                                   <Style />                                 </TextRun>                               </TextRuns>                               <Style />                             </Paragraph>                           </Paragraphs>                           <rd:DefaultName>Status1</rd:DefaultName>                           <Style>                             <Border>                               <Color>LightGrey</Color>                               <Style>Solid</Style>                             </Border>                             <PaddingLeft>2pt</PaddingLeft>                             <PaddingRight>2pt</PaddingRight>                             <PaddingTop>2pt</PaddingTop>                             <PaddingBottom>2pt</PaddingBottom>                           </Style>                         </Textbox>                       </CellContents>                     </TablixCell>                   </TablixCells>                 </TablixRow>               </TablixRows>             </TablixBody>             <TablixColumnHierarchy>               <TablixMembers>                 <TablixMember />               </TablixMembers>             </TablixColumnHierarchy>             <TablixRowHierarchy>               <TablixMembers>                 <TablixMember>                   <KeepWithGroup>After</KeepWithGroup>                 </TablixMember>                 <TablixMember>                   <Group Name=”Details” />                 </TablixMember>               </TablixMembers>             </TablixRowHierarchy>             <RepeatColumnHeaders>true</RepeatColumnHeaders>             <RepeatRowHeaders>true</RepeatRowHeaders>             <FixedColumnHeaders>true</FixedColumnHeaders>             <FixedRowHeaders>true</FixedRowHeaders>             <DataSetName>DataSet1</DataSetName>             <PageBreak>               <BreakLocation>End</BreakLocation>             </PageBreak>             <PageName>Status</PageName>             <Top>0.46944in</Top>             <Height>0.5in</Height>             <Width>18.68749in</Width>             <ZIndex>1</ZIndex>             <Style>               <Border>                 <Style>None</Style>               </Border>             </Style>           </Tablix>           <Tablix Name=”bom_Material”>             <TablixBody>               <TablixColumns>                 <TablixColumn>                   <Width>1.20833in</Width>                 </TablixColumn>                 <TablixColumn>                   <Width>1.20833in</Width>                 </TablixColumn>                 <TablixColumn>                   <Width>4.42708in</Width>                 </TablixColumn>                 <TablixColumn>                   <Width>0.52083in</Width>                 </TablixColumn>                 <TablixColumn>                   <Width>1in</Width>                 </TablixColumn>                 <TablixColumn>                   <Width>1in</Width>                 </TablixColumn>                 <TablixColumn>                   <Width>1.52083in</Width>                 </TablixColumn>                 <TablixColumn>                   <Width>0.91667in</Width>                 </TablixColumn>                 <TablixColumn>                   <Width>1in</Width>                 </TablixColumn>                 <TablixColumn>                   <Width>0.90625in</Width>                 </TablixColumn>                 <TablixColumn>                   <Width>1in</Width>                 </TablixColumn>                 <TablixColumn>                   <Width>0.97917in</Width>                 </TablixColumn>                 <TablixColumn>                   <Width>1in</Width>                 </TablixColumn>                 <TablixColumn>                   <Width>1in</Width>                 </TablixColumn>                 <TablixColumn>                   <Width>1in</Width>                 </TablixColumn>                 <TablixColumn>                   <Width>1in</Width>                 </TablixColumn>               </TablixColumns>               <TablixRows>                 <TablixRow>                   <Height>0.4375in</Height>                   <TablixCells>                     <TablixCell>                       <CellContents>                         <Textbox Name=”Textbox7″>                           <CanGrow>true</CanGrow>                           <KeepTogether>true</KeepTogether>                           <Paragraphs>                             <Paragraph>                               <TextRuns>                                 <TextRun>                                   <Value>Item</Value>                                   <Style>                                     <FontWeight>Bold</FontWeight>                                   </Style>                                 </TextRun>                               </TextRuns>                               <Style />                             </Paragraph>                           </Paragraphs>                           <rd:DefaultName>Textbox7</rd:DefaultName>                           <Style>                             <Border>                               <Color>LightGrey</Color>                               <Style>Solid</Style>                             </Border>                             <BackgroundColor>Plum</BackgroundColor>                             <PaddingLeft>2pt</PaddingLeft>                             <PaddingRight>2pt</PaddingRight>                             <PaddingTop>2pt</PaddingTop>                             <PaddingBottom>2pt</PaddingBottom>                           </Style>                         </Textbox>                       </CellContents>                     </TablixCell>                     <TablixCell>                       <CellContents>                         <Textbox Name=”Textbox9″>                           <CanGrow>true</CanGrow>                           <KeepTogether>true</KeepTogether>                           <Paragraphs>                             <Paragraph>                               <TextRuns>                                 <TextRun>                                   <Value>Component</Value>                                   <Style>                                     <FontWeight>Bold</FontWeight>                                   </Style>                                 </TextRun>                               </TextRuns>                               <Style />                             </Paragraph>                           </Paragraphs>                           <rd:DefaultName>Textbox9</rd:DefaultName>                           <Style>                             <Border>                               <Color>LightGrey</Color>                               <Style>Solid</Style>                             </Border>                             <BackgroundColor>Plum</BackgroundColor>                             <PaddingLeft>2pt</PaddingLeft>                             <PaddingRight>2pt</PaddingRight>                             <PaddingTop>2pt</PaddingTop>                             <PaddingBottom>2pt</PaddingBottom>                           </Style>                         </Textbox>                       </CellContents>                     </TablixCell>                     <TablixCell>                       <CellContents>                         <Textbox Name=”Textbox11″>                           <CanGrow>true</CanGrow>                           <KeepTogether>true</KeepTogether>                           <Paragraphs>                             <Paragraph>                               <TextRuns>                                 <TextRun>                                   <Value>Description</Value>                                   <Style>                                     <FontWeight>Bold</FontWeight>                                   </Style>                                 </TextRun>                               </TextRuns>                               <Style />                             </Paragraph>                           </Paragraphs>                           <rd:DefaultName>Textbox11</rd:DefaultName>                           <Style>                             <Border>                               <Color>LightGrey</Color>                               <Style>Solid</Style>                             </Border>                             <BackgroundColor>Plum</BackgroundColor>                             <PaddingLeft>2pt</PaddingLeft>                             <PaddingRight>2pt</PaddingRight>                             <PaddingTop>2pt</PaddingTop>                             <PaddingBottom>2pt</PaddingBottom>                           </Style>                         </Textbox>                       </CellContents>                     </TablixCell>                     <TablixCell>                       <CellContents>                         <Textbox Name=”Textbox13″>                           <CanGrow>true</CanGrow>                           <KeepTogether>true</KeepTogether>                           <Paragraphs>                             <Paragraph>                               <TextRuns>                                 <TextRun>                                   <Value>Level</Value>                                   <Style>                                     <FontWeight>Bold</FontWeight>                                   </Style>                                 </TextRun>                               </TextRuns>                               <Style />                             </Paragraph>                           </Paragraphs>                           <rd:DefaultName>Textbox13</rd:DefaultName>                           <Style>                             <Border>                               <Color>LightGrey</Color>                               <Style>Solid</Style>                             </Border>                             <BackgroundColor>Plum</BackgroundColor>                             <PaddingLeft>2pt</PaddingLeft>                             <PaddingRight>2pt</PaddingRight>                             <PaddingTop>2pt</PaddingTop>                             <PaddingBottom>2pt</PaddingBottom>                           </Style>                         </Textbox>                       </CellContents>                     </TablixCell>                     <TablixCell>                       <CellContents>                         <Textbox Name=”Textbox2″>                           <CanGrow>true</CanGrow>                           <KeepTogether>true</KeepTogether>                           <Paragraphs>                             <Paragraph>                               <TextRuns>                                 <TextRun>                                   <Value>Last Activity</Value>                                   <Style>                                     <FontWeight>Bold</FontWeight>                                   </Style>                                 </TextRun>                               </TextRuns>                               <Style />                             </Paragraph>                           </Paragraphs>                           <rd:DefaultName>Textbox2</rd:DefaultName>                           <Style>                             <Border>                               <Color>LightGrey</Color>                               <Style>Solid</Style>                             </Border>                             <BackgroundColor>Plum</BackgroundColor>                             <PaddingLeft>2pt</PaddingLeft>                             <PaddingRight>2pt</PaddingRight>                             <PaddingTop>2pt</PaddingTop>                             <PaddingBottom>2pt</PaddingBottom>                           </Style>                         </Textbox>                       </CellContents>                     </TablixCell>                     <TablixCell>                       <CellContents>                         <Textbox Name=”Textbox10″>                           <CanGrow>true</CanGrow>                           <KeepTogether>true</KeepTogether>                           <Paragraphs>                             <Paragraph>                               <TextRuns>                                 <TextRun>                                   <Value>Effective  Date</Value>                                   <Style>                                     <FontWeight>Bold</FontWeight>                                   </Style>                                 </TextRun>                               </TextRuns>                               <Style />                             </Paragraph>                           </Paragraphs>                           <rd:DefaultName>Textbox10</rd:DefaultName>                           <Style>                             <Border>                               <Color>LightGrey</Color>                               <Style>Solid</Style>                             </Border>                             <BackgroundColor>Plum</BackgroundColor>                             <PaddingLeft>2pt</PaddingLeft>                             <PaddingRight>2pt</PaddingRight>                             <PaddingTop>2pt</PaddingTop>                             <PaddingBottom>2pt</PaddingBottom>                           </Style>                         </Textbox>                       </CellContents>                     </TablixCell>                     <TablixCell>                       <CellContents>                         <Textbox Name=”Textbox5″>                           <CanGrow>true</CanGrow>                           <KeepTogether>true</KeepTogether>                           <Paragraphs>                             <Paragraph>                               <TextRuns>                                 <TextRun>                                   <Value>Item Type</Value>                                   <Style>                                     <FontWeight>Bold</FontWeight>                                   </Style>                                 </TextRun>                               </TextRuns>                               <Style />                             </Paragraph>                           </Paragraphs>                           <rd:DefaultName>Textbox5</rd:DefaultName>                           <Style>                             <Border>                               <Color>LightGrey</Color>                               <Style>Solid</Style>                             </Border>                             <BackgroundColor>Plum</BackgroundColor>                             <PaddingLeft>2pt</PaddingLeft>                             <PaddingRight>2pt</PaddingRight>                             <PaddingTop>2pt</PaddingTop>                             <PaddingBottom>2pt</PaddingBottom>                           </Style>                         </Textbox>                       </CellContents>                     </TablixCell>                     <TablixCell>                       <CellContents>                         <Textbox Name=”Textbox15″>                           <CanGrow>true</CanGrow>                           <KeepTogether>true</KeepTogether>                           <Paragraphs>                             <Paragraph>                               <TextRuns>                                 <TextRun>                                   <Value>Make Or Buy</Value>                                   <Style>                                     <FontWeight>Bold</FontWeight>                                   </Style>                                 </TextRun>                               </TextRuns>                               <Style />                             </Paragraph>                           </Paragraphs>                           <rd:DefaultName>Textbox15</rd:DefaultName>                           <Style>                             <Border>                               <Color>LightGrey</Color>                               <Style>Solid</Style>                             </Border>                             <BackgroundColor>Plum</BackgroundColor>                             <PaddingLeft>2pt</PaddingLeft>                             <PaddingRight>2pt</PaddingRight>                             <PaddingTop>2pt</PaddingTop>                             <PaddingBottom>2pt</PaddingBottom>                           </Style>                         </Textbox>                       </CellContents>                     </TablixCell>                     <TablixCell>                       <CellContents>                         <Textbox Name=”Textbox17″>                           <CanGrow>true</CanGrow>                           <KeepTogether>true</KeepTogether>                           <Paragraphs>                             <Paragraph>                               <TextRuns>                                 <TextRun>                                   <Value>Quantity</Value>                                   <Style>                                     <FontWeight>Bold</FontWeight>                                   </Style>                                 </TextRun>                               </TextRuns>                               <Style />                             </Paragraph>                           </Paragraphs>                           <rd:DefaultName>Textbox17</rd:DefaultName>                           <Style>                             <Border>                               <Color>LightGrey</Color>                               <Style>Solid</Style>                             </Border>                             <BackgroundColor>Plum</BackgroundColor>                             <PaddingLeft>2pt</PaddingLeft>                             <PaddingRight>2pt</PaddingRight>                             <PaddingTop>2pt</PaddingTop>                             <PaddingBottom>2pt</PaddingBottom>                           </Style>                         </Textbox>                       </CellContents>                     </TablixCell>                     <TablixCell>                       <CellContents>                         <Textbox Name=”Textbox21″>                           <CanGrow>true</CanGrow>                           <KeepTogether>true</KeepTogether>                           <Paragraphs>                             <Paragraph>                               <TextRuns>                                 <TextRun>                                   <Value>Std Cost Per Unit</Value>                                   <Style>                                     <FontWeight>Bold</FontWeight>                                   </Style>                                 </TextRun>                               </TextRuns>                               <Style />                             </Paragraph>                           </Paragraphs>                           <rd:DefaultName>Textbox21</rd:DefaultName>                           <Style>                             <Border>                               <Color>LightGrey</Color>                               <Style>Solid</Style>                             </Border>                             <BackgroundColor>Plum</BackgroundColor>                             <PaddingLeft>2pt</PaddingLeft>                             <PaddingRight>2pt</PaddingRight>                             <PaddingTop>2pt</PaddingTop>                             <PaddingBottom>2pt</PaddingBottom>                           </Style>                         </Textbox>                       </CellContents>                     </TablixCell>                     <TablixCell>                       <CellContents>                         <Textbox Name=”Textbox23″>                           <CanGrow>true</CanGrow>                           <KeepTogether>true</KeepTogether>                           <Paragraphs>                             <Paragraph>                               <TextRuns>                                 <TextRun>                                   <Value>Variable OH Per Unit</Value>                                   <Style>                                     <FontWeight>Bold</FontWeight>                                   </Style>                                 </TextRun>                               </TextRuns>                               <Style />                             </Paragraph>                           </Paragraphs>                           <rd:DefaultName>Textbox23</rd:DefaultName>                           <Style>                             <Border>                               <Color>LightGrey</Color>                               <Style>Solid</Style>                             </Border>                             <BackgroundColor>Plum</BackgroundColor>                             <PaddingLeft>2pt</PaddingLeft>                             <PaddingRight>2pt</PaddingRight>                             <PaddingTop>2pt</PaddingTop>                             <PaddingBottom>2pt</PaddingBottom>                           </Style>                         </Textbox>                       </CellContents>                     </TablixCell>                     <TablixCell>                       <CellContents>                         <Textbox Name=”Textbox25″>                           <CanGrow>true</CanGrow>                           <KeepTogether>true</KeepTogether>                           <Paragraphs>                             <Paragraph>                               <TextRuns>                                 <TextRun>                                   <Value>Material Cost at Level 1</Value>                                   <Style>                                     <FontWeight>Bold</FontWeight>                                   </Style>                                 </TextRun>                               </TextRuns>                               <Style />                             </Paragraph>                           </Paragraphs>                           <rd:DefaultName>Textbox25</rd:DefaultName>                           <Style>                             <Border>                               <Color>LightGrey</Color>                               <Style>Solid</Style>                             </Border>                             <BackgroundColor>Plum</BackgroundColor>                             <PaddingLeft>2pt</PaddingLeft>                             <PaddingRight>2pt</PaddingRight>                             <PaddingTop>2pt</PaddingTop>                             <PaddingBottom>2pt</PaddingBottom>                           </Style>                         </Textbox>                       </CellContents>                     </TablixCell>                     <TablixCell>                       <CellContents>                         <Textbox Name=”Textbox33″>                           <CanGrow>true</CanGrow>                           <KeepTogether>true</KeepTogether>                           <Paragraphs>                             <Paragraph>                               <TextRuns>                                 <TextRun>                                   <Value>Material VOH at Level 1</Value>                                   <Style>                                     <FontWeight>Bold</FontWeight>                                   </Style>                                 </TextRun>                               </TextRuns>                               <Style />                             </Paragraph>                           </Paragraphs>                           <rd:DefaultName>Textbox33</rd:DefaultName>                           <Style>                             <Border>                               <Color>LightGrey</Color>                               <Style>Solid</Style>                             </Border>                             <BackgroundColor>Plum</BackgroundColor>                             <PaddingLeft>2pt</PaddingLeft>                             <PaddingRight>2pt</PaddingRight>                             <PaddingTop>2pt</PaddingTop>                             <PaddingBottom>2pt</PaddingBottom>                           </Style>                         </Textbox>                       </CellContents>                     </TablixCell>                     <TablixCell>                       <CellContents>                         <Textbox Name=”Textbox31″>                           <CanGrow>true</CanGrow>                           <KeepTogether>true</KeepTogether>                           <Paragraphs>                             <Paragraph>                               <TextRuns>                                 <TextRun>                                   <Value>Material Cost of Buy Item</Value>                                   <Style>                                     <FontWeight>Bold</FontWeight>                                   </Style>                                 </TextRun>                               </TextRuns>                               <Style />                             </Paragraph>                           </Paragraphs>                           <rd:DefaultName>Textbox31</rd:DefaultName>                           <Style>                             <Border>                               <Color>LightGrey</Color>                               <Style>Solid</Style>                             </Border>                             <BackgroundColor>Plum</BackgroundColor>                             <PaddingLeft>2pt</PaddingLeft>                             <PaddingRight>2pt</PaddingRight>                             <PaddingTop>2pt</PaddingTop>                             <PaddingBottom>2pt</PaddingBottom>                           </Style>                         </Textbox>                       </CellContents>                     </TablixCell>                     <TablixCell>                       <CellContents>                         <Textbox Name=”Textbox29″>                           <CanGrow>true</CanGrow>                           <KeepTogether>true</KeepTogether>                           <Paragraphs>                             <Paragraph>                               <TextRuns>                                 <TextRun>                                   <Value>Material VOH of Buy Item</Value>                                   <Style>                                     <FontWeight>Bold</FontWeight>                                   </Style>                                 </TextRun>                               </TextRuns>                               <Style />                             </Paragraph>                           </Paragraphs>                           <rd:DefaultName>Textbox29</rd:DefaultName>                           <Style>                             <Border>                               <Color>LightGrey</Color>                               <Style>Solid</Style>                             </Border>                             <BackgroundColor>Plum</BackgroundColor>                             <PaddingLeft>2pt</PaddingLeft>                             <PaddingRight>2pt</PaddingRight>                             <PaddingTop>2pt</PaddingTop>                             <PaddingBottom>2pt</PaddingBottom>                           </Style>                         </Textbox>                       </CellContents>                     </TablixCell>                     <TablixCell>                       <CellContents>                         <Textbox Name=”Textbox1″>                           <CanGrow>true</CanGrow>                           <KeepTogether>true</KeepTogether>                           <Paragraphs>                             <Paragraph>                               <TextRuns>                                 <TextRun>                                   <Value>UOMSCHDL</Value>                                   <Style>                                     <FontWeight>Bold</FontWeight>                                   </Style>                                 </TextRun>                               </TextRuns>                               <Style />                             </Paragraph>                           </Paragraphs>                           <rd:DefaultName>Textbox1</rd:DefaultName>                           <Style>                             <Border>                               <Color>LightGrey</Color>                               <Style>Solid</Style>                             </Border>                             <BackgroundColor>Plum</BackgroundColor>                             <PaddingLeft>2pt</PaddingLeft>                             <PaddingRight>2pt</PaddingRight>                             <PaddingTop>2pt</PaddingTop>                             <PaddingBottom>2pt</PaddingBottom>                           </Style>                         </Textbox>                       </CellContents>                     </TablixCell>                   </TablixCells>                 </TablixRow>                 <TablixRow>                   <Height>0.23958in</Height>                   <TablixCells>                     <TablixCell>                       <CellContents>                         <Textbox Name=”Item”>                           <CanGrow>true</CanGrow>                           <KeepTogether>true</KeepTogether>                           <Paragraphs>                             <Paragraph>                               <TextRuns>                                 <TextRun>                                   <Value>=ltrim(rtrim(Fields!Item.Value))</Value>                                   <Style />                                 </TextRun>                               </TextRuns>                               <Style />                             </Paragraph>                           </Paragraphs>                           <rd:DefaultName>Item</rd:DefaultName>                           <Style>                             <Border>                               <Color>LightGrey</Color>                               <Style>Solid</Style>                             </Border>                             <PaddingLeft>2pt</PaddingLeft>                             <PaddingRight>2pt</PaddingRight>                             <PaddingTop>2pt</PaddingTop>                             <PaddingBottom>2pt</PaddingBottom>                           </Style>                         </Textbox>                       </CellContents>                     </TablixCell>                     <TablixCell>                       <CellContents>                         <Textbox Name=”Component”>                           <CanGrow>true</CanGrow>                           <KeepTogether>true</KeepTogether>                           <Paragraphs>                             <Paragraph>                               <TextRuns>                                 <TextRun>                                   <Value>=ltrim(rtrim(Fields!Component.Value))</Value>                                   <Style />                                 </TextRun>                               </TextRuns>                               <Style />                             </Paragraph>                           </Paragraphs>                           <rd:DefaultName>Component</rd:DefaultName>                           <Style>                             <Border>                               <Color>LightGrey</Color>                               <Style>Solid</Style>                             </Border>                             <PaddingLeft>2pt</PaddingLeft>                             <PaddingRight>2pt</PaddingRight>                             <PaddingTop>2pt</PaddingTop>                             <PaddingBottom>2pt</PaddingBottom>                           </Style>                         </Textbox>                       </CellContents>                     </TablixCell>                     <TablixCell>                       <CellContents>                         <Textbox Name=”Description”>                           <CanGrow>true</CanGrow>                           <KeepTogether>true</KeepTogether>                           <Paragraphs>                             <Paragraph>                               <TextRuns>                                 <TextRun>                                   <Value>=ltrim(rtrim(Fields!Description.Value))</Value>                                   <Style />                                 </TextRun>                               </TextRuns>                               <Style />                             </Paragraph>                           </Paragraphs>                           <rd:DefaultName>Description</rd:DefaultName>                           <Style>                             <Border>                               <Color>LightGrey</Color>                               <Style>Solid</Style>                             </Border>                             <PaddingLeft>2pt</PaddingLeft>                             <PaddingRight>2pt</PaddingRight>                             <PaddingTop>2pt</PaddingTop>                             <PaddingBottom>2pt</PaddingBottom>                           </Style>                         </Textbox>                       </CellContents>                     </TablixCell>                     <TablixCell>                       <CellContents>                         <Textbox Name=”Level”>                           <CanGrow>true</CanGrow>                           <KeepTogether>true</KeepTogether>                           <Paragraphs>                             <Paragraph>                               <TextRuns>                                 <TextRun>                                   <Value>=ltrim(rtrim(Fields!Level.Value))</Value>                                   <Style />                                 </TextRun>                               </TextRuns>                               <Style />                             </Paragraph>                           </Paragraphs>                           <rd:DefaultName>Level</rd:DefaultName>                           <Style>                             <Border>                               <Color>LightGrey</Color>                               <Style>Solid</Style>                             </Border>                             <PaddingLeft>2pt</PaddingLeft>                             <PaddingRight>2pt</PaddingRight>                             <PaddingTop>2pt</PaddingTop>                             <PaddingBottom>2pt</PaddingBottom>                           </Style>                         </Textbox>                       </CellContents>                     </TablixCell>                     <TablixCell>                       <CellContents>                         <Textbox Name=”LastMOactivity”>                           <CanGrow>true</CanGrow>                           <KeepTogether>true</KeepTogether>                           <Paragraphs>                             <Paragraph>                               <TextRuns>                                 <TextRun>                                   <Value>=Fields!LastMOactivity.Value</Value>                                   <Style>                                     <Format>MM/dd/yy</Format>                                   </Style>                                 </TextRun>                               </TextRuns>                               <Style />                             </Paragraph>                           </Paragraphs>                           <rd:DefaultName>LastMOactivity</rd:DefaultName>                           <Style>                             <Border>                               <Color>LightGrey</Color>                               <Style>Solid</Style>                             </Border>                             <PaddingLeft>2pt</PaddingLeft>                             <PaddingRight>2pt</PaddingRight>                             <PaddingTop>2pt</PaddingTop>                             <PaddingBottom>2pt</PaddingBottom>                           </Style>                         </Textbox>                       </CellContents>                     </TablixCell>                     <TablixCell>                       <CellContents>                         <Textbox Name=”EffectiveDate”>                           <CanGrow>true</CanGrow>                           <KeepTogether>true</KeepTogether>                           <Paragraphs>                             <Paragraph>                               <TextRuns>                                 <TextRun>                                   <Value>=Fields!EffectiveDate.Value</Value>                                   <Style>                                     <Format>MM/dd/yy</Format>                                   </Style>                                 </TextRun>                               </TextRuns>                               <Style />                             </Paragraph>                           </Paragraphs>                           <rd:DefaultName>EffectiveDate</rd:DefaultName>                           <Style>                             <Border>                               <Color>LightGrey</Color>                               <Style>Solid</Style>                             </Border>                             <PaddingLeft>2pt</PaddingLeft>                             <PaddingRight>2pt</PaddingRight>                             <PaddingTop>2pt</PaddingTop>                             <PaddingBottom>2pt</PaddingBottom>                           </Style>                         </Textbox>                       </CellContents>                     </TablixCell>                     <TablixCell>                       <CellContents>                         <Textbox Name=”ItemType”>                           <CanGrow>true</CanGrow>                           <KeepTogether>true</KeepTogether>                           <Paragraphs>                             <Paragraph>                               <TextRuns>                                 <TextRun>                                   <Value>=Fields!ItemType.Value</Value>                                   <Style />                                 </TextRun>                               </TextRuns>                               <Style />                             </Paragraph>                           </Paragraphs>                           <rd:DefaultName>ItemType</rd:DefaultName>                           <Style>                             <Border>                               <Color>LightGrey</Color>                               <Style>Solid</Style>                             </Border>                             <PaddingLeft>2pt</PaddingLeft>                             <PaddingRight>2pt</PaddingRight>                             <PaddingTop>2pt</PaddingTop>                             <PaddingBottom>2pt</PaddingBottom>                           </Style>                         </Textbox>                       </CellContents>                     </TablixCell>                     <TablixCell>                       <CellContents>                         <Textbox Name=”MakeOrBuy”>                           <CanGrow>true</CanGrow>                           <KeepTogether>true</KeepTogether>                           <Paragraphs>                             <Paragraph>                               <TextRuns>                                 <TextRun>                                   <Value>=ltrim(rtrim(Fields!MakeOrBuy.Value))</Value>                                   <Style />                                 </TextRun>                               </TextRuns>                               <Style />                             </Paragraph>                           </Paragraphs>                           <rd:DefaultName>MakeOrBuy</rd:DefaultName>                           <Style>                             <Border>                               <Color>LightGrey</Color>                               <Style>Solid</Style>                             </Border>                             <PaddingLeft>2pt</PaddingLeft>                             <PaddingRight>2pt</PaddingRight>                             <PaddingTop>2pt</PaddingTop>                             <PaddingBottom>2pt</PaddingBottom>                           </Style>                         </Textbox>                       </CellContents>                     </TablixCell>                     <TablixCell>                       <CellContents>                         <Textbox Name=”Quantity”>                           <CanGrow>true</CanGrow>                           <KeepTogether>true</KeepTogether>                           <Paragraphs>                             <Paragraph>                               <TextRuns>                                 <TextRun>                                   <Value>=Fields!Quantity.Value</Value>                                   <Style>                                     <Format>#,0.00000</Format>                                   </Style>                                 </TextRun>                               </TextRuns>                               <Style />                             </Paragraph>                           </Paragraphs>                           <rd:DefaultName>Quantity</rd:DefaultName>                           <Style>                             <Border>                               <Color>LightGrey</Color>                               <Style>Solid</Style>                             </Border>                             <PaddingLeft>2pt</PaddingLeft>                             <PaddingRight>2pt</PaddingRight>                             <PaddingTop>2pt</PaddingTop>                             <PaddingBottom>2pt</PaddingBottom>                           </Style>                         </Textbox>                       </CellContents>                     </TablixCell>                     <TablixCell>                       <CellContents>                         <Textbox Name=”Std_Cost_Per_Unit”>                           <CanGrow>true</CanGrow>                           <KeepTogether>true</KeepTogether>                           <Paragraphs>                             <Paragraph>                               <TextRuns>                                 <TextRun>                                   <Value>=Fields!Std_Cost_Per_Unit.Value</Value>                                   <Style>                                     <Format>#,0.00000;(#,0.00000)</Format>                                   </Style>                                 </TextRun>                               </TextRuns>                               <Style />                             </Paragraph>                           </Paragraphs>                           <rd:DefaultName>Std_Cost_Per_Unit</rd:DefaultName>                           <Style>                             <Border>                               <Color>LightGrey</Color>                               <Style>Solid</Style>                             </Border>                             <PaddingLeft>2pt</PaddingLeft>                             <PaddingRight>2pt</PaddingRight>                             <PaddingTop>2pt</PaddingTop>                             <PaddingBottom>2pt</PaddingBottom>                           </Style>                         </Textbox>                       </CellContents>                     </TablixCell>                     <TablixCell>                       <CellContents>                         <Textbox Name=”Variable_OH_Per_Unit”>                           <CanGrow>true</CanGrow>                           <KeepTogether>true</KeepTogether>                           <Paragraphs>                             <Paragraph>                               <TextRuns>                                 <TextRun>                                   <Value>=Fields!Variable_OH_Per_Unit.Value</Value>                                   <Style>                                     <Format>#,0.00000;(#,0.00000)</Format>                                   </Style>                                 </TextRun>                               </TextRuns>                               <Style />                             </Paragraph>                           </Paragraphs>                           <rd:DefaultName>Variable_OH_Per_Unit</rd:DefaultName>                           <Style>                             <Border>                               <Color>LightGrey</Color>                               <Style>Solid</Style>                             </Border>                             <PaddingLeft>2pt</PaddingLeft>                             <PaddingRight>2pt</PaddingRight>                             <PaddingTop>2pt</PaddingTop>                             <PaddingBottom>2pt</PaddingBottom>                           </Style>                         </Textbox>                       </CellContents>                     </TablixCell>                     <TablixCell>                       <CellContents>                         <Textbox Name=”Material_Cost_at_Level_1″>                           <CanGrow>true</CanGrow>                           <KeepTogether>true</KeepTogether>                           <Paragraphs>                             <Paragraph>                               <TextRuns>                                 <TextRun>                                   <Value>=Fields!Material_Cost_at_Level_1.Value</Value>                                   <Style>                                     <Format>#,0.00000;(#,0.00000)</Format>                                   </Style>                                 </TextRun>                               </TextRuns>                               <Style />                             </Paragraph>                           </Paragraphs>                           <rd:DefaultName>Material_Cost_at_Level_1</rd:DefaultName>                           <Style>                             <Border>                               <Color>LightGrey</Color>                               <Style>Solid</Style>                             </Border>                             <PaddingLeft>2pt</PaddingLeft>                             <PaddingRight>2pt</PaddingRight>                             <PaddingTop>2pt</PaddingTop>                             <PaddingBottom>2pt</PaddingBottom>                           </Style>                         </Textbox>                       </CellContents>                     </TablixCell>                     <TablixCell>                       <CellContents>                         <Textbox Name=”Material_VOH_at_Level_1″>                           <CanGrow>true</CanGrow>                           <KeepTogether>true</KeepTogether>                           <Paragraphs>                             <Paragraph>                               <TextRuns>                                 <TextRun>                                   <Value>=Fields!Material_VOH_at_Level_1.Value</Value>                                   <Style>                                     <Format>#,0.00000;(#,0.00000)</Format>                                   </Style>                                 </TextRun>                               </TextRuns>                               <Style />                             </Paragraph>                           </Paragraphs>                           <rd:DefaultName>Material_VOH_at_Level_1</rd:DefaultName>                           <Style>                             <Border>                               <Color>LightGrey</Color>                               <Style>Solid</Style>                             </Border>                             <PaddingLeft>2pt</PaddingLeft>                             <PaddingRight>2pt</PaddingRight>                             <PaddingTop>2pt</PaddingTop>                             <PaddingBottom>2pt</PaddingBottom>                           </Style>                         </Textbox>                       </CellContents>                     </TablixCell>                     <TablixCell>                       <CellContents>                         <Textbox Name=”Material_Cost_of_Buy_Item”>                           <CanGrow>true</CanGrow>                           <KeepTogether>true</KeepTogether>                           <Paragraphs>                             <Paragraph>                               <TextRuns>                                 <TextRun>                                   <Value>=Fields!Material_Cost_of_Buy_Item.Value</Value>                                   <Style>                                     <Format>#,0.00000;(#,0.00000)</Format>                                   </Style>                                 </TextRun>                               </TextRuns>                               <Style />                             </Paragraph>                           </Paragraphs>                           <rd:DefaultName>Material_Cost_of_Buy_Item</rd:DefaultName>                           <Style>                             <Border>                               <Color>LightGrey</Color>                               <Style>Solid</Style>                             </Border>                             <PaddingLeft>2pt</PaddingLeft>                             <PaddingRight>2pt</PaddingRight>                             <PaddingTop>2pt</PaddingTop>                             <PaddingBottom>2pt</PaddingBottom>                           </Style>                         </Textbox>                       </CellContents>                     </TablixCell>                     <TablixCell>                       <CellContents>                         <Textbox Name=”Material_VO1H_of_Buy_Item”>                           <CanGrow>true</CanGrow>                           <KeepTogether>true</KeepTogether>                           <Paragraphs>                             <Paragraph>                               <TextRuns>                                 <TextRun>                                   <Value>=Fields!Material_VO1H_of_Buy_Item.Value</Value>                                   <Style>                                     <Format>#,0.00000;(#,0.00000)</Format>                                   </Style>                                 </TextRun>                               </TextRuns>                               <Style />                             </Paragraph>                           </Paragraphs>                           <rd:DefaultName>Material_VO1H_of_Buy_Item</rd:DefaultName>                           <Style>                             <Border>                               <Color>LightGrey</Color>                               <Style>Solid</Style>                             </Border>                             <PaddingLeft>2pt</PaddingLeft>                             <PaddingRight>2pt</PaddingRight>                             <PaddingTop>2pt</PaddingTop>                             <PaddingBottom>2pt</PaddingBottom>                           </Style>                         </Textbox>                       </CellContents>                     </TablixCell>                     <TablixCell>                       <CellContents>                         <Textbox Name=”UOMSCHDL”>                           <CanGrow>true</CanGrow>                           <KeepTogether>true</KeepTogether>                           <Paragraphs>                             <Paragraph>                               <TextRuns>                                 <TextRun>                                   <Value>=Fields!UOMSCHDL.Value</Value>                                   <Style />                                 </TextRun>                               </TextRuns>                               <Style />                             </Paragraph>                           </Paragraphs>                           <rd:DefaultName>UOMSCHDL</rd:DefaultName>                           <Style>                             <Border>                               <Color>LightGrey</Color>                               <Style>Solid</Style>                             </Border>                             <PaddingLeft>2pt</PaddingLeft>                             <PaddingRight>2pt</PaddingRight>                             <PaddingTop>2pt</PaddingTop>                             <PaddingBottom>2pt</PaddingBottom>                           </Style>                         </Textbox>                       </CellContents>                     </TablixCell>                   </TablixCells>                 </TablixRow>               </TablixRows>             </TablixBody>             <TablixColumnHierarchy>               <TablixMembers>                 <TablixMember />                 <TablixMember />                 <TablixMember />                 <TablixMember />                 <TablixMember />                 <TablixMember />                 <TablixMember />                 <TablixMember />                 <TablixMember />                 <TablixMember />                 <TablixMember />                 <TablixMember />                 <TablixMember />                 <TablixMember />                 <TablixMember />                 <TablixMember />               </TablixMembers>             </TablixColumnHierarchy>             <TablixRowHierarchy>               <TablixMembers>                 <TablixMember>                   <KeepWithGroup>After</KeepWithGroup>                 </TablixMember>                 <TablixMember>                   <Group Name=”Details1″ />                 </TablixMember>               </TablixMembers>             </TablixRowHierarchy>             <RepeatColumnHeaders>true</RepeatColumnHeaders>             <RepeatRowHeaders>true</RepeatRowHeaders>             <FixedColumnHeaders>true</FixedColumnHeaders>             <FixedRowHeaders>true</FixedRowHeaders>             <DataSetName>BOM_Material</DataSetName>             <PageName>BOM_Material</PageName>             <SortExpressions>               <SortExpression>                 <Value>=Fields!Item.Value</Value>               </SortExpression>             </SortExpressions>             <Top>1.02152in</Top>             <Height>0.67708in</Height>             <Width>19.68749in</Width>             <ZIndex>2</ZIndex>             <ToolTip>BOM_Material</ToolTip>             <Style>               <Border>                 <Style>None</Style>               </Border>             </Style>           </Tablix>         </ReportItems>         <Height>5.33207in</Height>         <Style>           <Border>             <Style>None</Style>           </Border>         </Style>       </Body>       <Width>20.8854in</Width>       <Page>         <PageFooter>           <Height>1.7in</Height>           <PrintOnFirstPage>true</PrintOnFirstPage>           <PrintOnLastPage>true</PrintOnLastPage>           <ReportItems>             <Textbox Name=”ExecutionTime”>               <CanGrow>true</CanGrow>               <KeepTogether>true</KeepTogether>               <Paragraphs>                 <Paragraph>                   <TextRuns>                     <TextRun>                       <Value>=Globals!ExecutionTime</Value>                       <Style />                     </TextRun>                   </TextRuns>                   <Style>                     <TextAlign>Right</TextAlign>                   </Style>                 </Paragraph>               </Paragraphs>               <rd:DefaultName>ExecutionTime</rd:DefaultName>               <Top>1.45in</Top>               <Height>0.25in</Height>               <Width>2in</Width>               <Style>                 <Border>                   <Style>None</Style>                 </Border>                 <PaddingLeft>2pt</PaddingLeft>                 <PaddingRight>2pt</PaddingRight>                 <PaddingTop>2pt</PaddingTop>                 <PaddingBottom>2pt</PaddingBottom>               </Style>             </Textbox>           </ReportItems>           <Style>             <Border>               <Style>None</Style>             </Border>           </Style>         </PageFooter>         <LeftMargin>1in</LeftMargin>         <RightMargin>1in</RightMargin>         <TopMargin>1in</TopMargin>         <BottomMargin>1in</BottomMargin>         <Style />       </Page>     </ReportSection>   </ReportSections>   <rd:ReportUnitType>Inch</rd:ReportUnitType>   <rd:ReportServerUrl>http://12508ppa1p/ReportServer</rd:ReportServerUrl>   <rd:ReportID>e8f4fcd5-2fac-4029-b5f2-40f454a4bd76</rd:ReportID> </Report>


  4. Upload the RDL to report server
  5. Update the Data Source.
  6. Expand the Dataset folder
  7. Test Dataset1 dataset  (right click, query & execute)
  8. Test Bom_Material dataset  (right click, query & execute)
  9. Save the report in Report Manager.
  10. SSRS Report is ready for execution.
  11. Upon completion export the report to excel.