FIX: You cannot search a Word document or an Excel workbook that is exported from an SSRS 2008 R2 or an SSRS 2012 report by using a keyword in the content of the document or of the workbook in SharePoint 2010

Article ID: 2678796 - View products that this article applies to.
Microsoft distributes Microsoft SQL Server 2008 R2 fixes as one downloadable file. Because the fixes are cumulative, each new release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 R2 fix release.
Expand all | Collapse all

On This Page

Symptoms

Consider the following scenario:
  • You export a Microsoft SQL Server 2008 R2 Reporting Services (SSRS 2008 R2) report or a Microsoft SQL Server 2012 Reporting Services (SSRS 2012) report to a Microsoft Word document in the 97-2003 format or to a Microsoft Excel workbook in the 97-2003 format.
  • You upload the Word document or the Excel workbook to a document library in Microsoft SharePoint 2010.
  • You perform a crawl in SharePoint 2010 and try to search the Word document or the Excel workbook by using a keyword in the content of the document or of the workbook.
In this scenario, you cannot search the content of the Word document or of the Excel workbook in SharePoint 2010.

Cause

This issue occurs because a Word document in the 97-2003 format or an Excel workbook in the 97-2003 format that is exported from an SSRS 2008 R2 report or an SSRS 2012 report does not have the necessary information to identify the document type or the workbook type. Therefore, SharePoint Services Search cannot index the document or the workbook.

Resolution

Cumulative update information

SQL Server 2008 R2 Service Pack 2

The fix for this issue was first released in Cumulative Update 1 for SQL Server 2008 R2 Service Pack 2. For more information about how to obtain this cumulative update package, click the following article number to view the article in the Microsoft Knowledge Base:
2720425 Cumulative Update package 1 for SQL Server 2008 R2 Service Pack 2
Note Because the builds are cumulative, each new fix release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 R2 fix release. We recommend that you consider applying the most recent fix release that contains this hotfix. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
2730301 The SQL Server 2008 R2 builds that were released after SQL Server 2008 R2 Service Pack 2 was released

SQL Server 2012

The fix for this issue was first released in Cumulative Update 2 for SQL Server 2012. For more information about this cumulative update package, click the following article number to view the article in the Microsoft Knowledge Base:
2703275 Cumulative update package 2 for SQL Server 2012
Note Because the builds are cumulative, each new fix release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2012 fix release. Microsoft recommends that you consider applying the most recent fix release that contains this hotfix. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
2692828 The SQL Server 2012 builds that were released after SQL Server 2012 was released
You must apply a SQL Server 2012 hotfix to an installation of SQL Server 2012.

SQL Server 2008 R2 Service Pack 1

The fix for this issue was first released in Cumulative Update 6. For more information about how to obtain this cumulative update package for SQL Server 2008 R2 Service Pack 1, click the following article number to view the article in the Microsoft Knowledge Base:
2679367 Cumulative Update package 6 for SQL Server 2008 R2 Service Pack 1
Note Because the builds are cumulative, each new fix release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 R2 Service Pack 1 fix release. We recommend that you consider applying the most recent fix release that contains this hotfix. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
2567616 The SQL Server 2008 R2 builds that were released after SQL Server 2008 R2 Service Pack 1 was released

Workaround

To work around this issue, open the Word document or the Excel workbook and then resave it as a Word document or as an Excel workbook before you upload it to SharePoint 2010.

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Properties

Article ID: 2678796 - Last Review: November 21, 2012 - Revision: 4.1
Applies to
  • Microsoft SQL Server 2008 R2 Reporting Services
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Standard
  • Microsoft SQL Server 2012 Web
Keywords: 
kbtshoot kbqfe kbfix kbsurveynew kbexpertiseadvanced KB2678796

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com