SSRS – User Domain\login does not have required permissions.

Verify that sufficient permission have been granted and Windows user account control (UAC) restriction has been addressed.

Resolution:
Start IE Administrator
Browse to SSRS reportserver (http://server/reports)
Click on the “Folder Settings” button.
Click on the “New Role Assignment” button.
Provide access to user

Cheers!
Sanjay

 


 

Open sub report in new window from SSRS – SharePoint integrated mode

For the textbox field in SSRS Tablix set an action to go to URL with following Expression:

javascript:void(window.open(‘” & Globals!ReportServerUrl &“/Pages/ReportViewer.aspx?” & Globals!ReportFolder & “/PO_Lines.rdl&rc:Parameters=False&PONumber=”& Fields!PO_NUMBER.Value & “‘))

Where:

  1. PO_Lines.rdl is the sub report name
  2. PONumber is the Sub report parameter
  3. PO_NUMBER.Value is the main report field containing value for the sub report parameter.

Cheers!
Sanjay

 

 

 

 

 

 

SSRS – Report – Job Link

SELECT 

      c.Name AS ReportName

      , rs.ScheduleID AS JOB_NAME

      , s.[Description]

      , s.LastStatus

      , s.LastRunTime

FROM 

      ReportServer..[Catalog] c 

      JOIN ReportServer..Subscriptions s ON c.ItemID = s.Report_OID 

      JOIN ReportServer..ReportSchedule rs ON c.ItemID = rs.ReportID

      AND rs.SubscriptionID = s.SubscriptionID

Cheers!
Sanjay

SSRS – How to suppress sub report when there is no data

  1. Open the SSRS report hosting a sub report at SSRS Report Builder.
  2. Right click the sub report to access the sub report properties.

    subreport

  3. Select the visibility option, and select show or hide based on expression
    sub report properities
  4. Enter the expression editor by clicking fx button, enter the following code.

    hide sub report

  5. Click  Ok – Ok  and save the report.

The sub report will be visible only when there is data.

Cheers!

Sanjay

Changing the Data Source of SSRS Report

Changing the Data Source of SSRS Report

  1. Browse to the uploaded report.
  2. Edit the report at report builder
  3. Expand the Data sources folder
  4. Delete the Datasource1 data connection
  5. Right click the Data sources folder and add a new data source
  6. Click browse and navigate to the DYNAMICSGP Connection  at the Data sources folder. Ensure the Data Source name is Data Source1
  7. Test Connection, click ok to complete the change.

Cheers!
Sanjay

 

 

Upload RDL file to SSRS Report Manager

Upload RDL file to SSRS Report Manager:

  1. Log on to report manager.

    Report Manager

    Report Manager

  2. Navigate to desired folder where the report needs to be uploaded.
  3. Click on Upload File button
  4. Browse to the RDL file to be uploaded, and click ok. (file extension should be .rdl)

Cheers!
Sanjay

 

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.

 

 

Creating Data Sources for SSRS Reports

Creating Data Sources for SSRS Reports

For all SSRS reports exhibited at this site, the data source described below needs to be created first. Listed blow are steps on how to create a data source at SSRS Reports Manager.

  1. Log on to Reporting services manager.

    Report Manager

    Report Manager

  2. Switch to Tile view

    Tile view

    Tile view

  3. Data sources

    Data sources

  4. Click on new data source. Supply correct SQL Server and Company Database info.

    SSRS DATA SOURCE

    SSRS DATA SOURCE

  5. Test connection
  6. Click Apply and exit

Note: Every report listed on this site reads the “GP Company Database”  and uses “zReports” database to create temporary tables.  For this purpose create a empty database zReports. The SQL user account used to connect to SQL Server at this data source should have read rights on the GP Company database and write rights on the “zReports” database.

Cheers!
Sanjay

 

 

Daily SSRS subscription failure alerts

Daily SSRS subscription failure alerts

SELECT  c.name  AS Category,
                a.name  AS JobName,
Report = (SELECT cat.name AS Report
FROM   reportserver..[catalog] cat WITH (nolock)
JOIN reportserver..subscriptions sub WITH (nolock)
ON cat.itemid = sub.report_oid
JOIN reportserver..reportschedule rs WITH (nolock)
ON cat.itemid = rs.reportid
AND rs.subscriptionid = sub.subscriptionid
WHERE  Ltrim(Rtrim(rs.scheduleid)) = Ltrim(Rtrim(a.name))),
Count(step_name) AS StepName,
Sum(CASE
WHEN run_status = 1 THEN 0
ELSE 1
END)         AS FailedTotal
FROM   msdb.dbo.sysjobs_view a WITH (nolock)
INNER JOIN msdb.dbo.sysjobhistory b WITH (nolock)
ON ( a.job_id = b.job_id
AND a.enabled = 1 )
INNER JOIN msdb.dbo.syscategories c WITH (nolock)
ON ( a.category_id = c.category_id )
WHERE  CONVERT(DATETIME, Cast(run_date AS CHAR(8)), 102) = Cast(
CONVERT(CHAR(12), Getdate()  1, 102) AS DATETIME)
GROUP  BY c.name,
a.name
HAVING Sum(CASE
WHEN run_status = 1 THEN 0
ELSE 1
END) > 0

Cheers!

Sanjay