Hi , I have two reports . F102 and F103. We need to make F103 as a sub report to F102. Issue is facing with the sub report. Getting the following error. ----------------------------------------------------------------------------------- Data retrieval Failed for sub report sub report2. Located at /Example subreport. Please check the log file for more information ----------------------------------------------------------------------------------- When checked the Microsoft, got the information that, it will be solved by Cumulative update package 3 for Sql server service pack1. Have downloaded the cumulative update package 3(KB971491) . But unable to install . It is showing the following error Error:- --------------------------------------------------------------- There are no SQL SERVER instances or shared features that can be updated on this computer ---------------------------------------------------------------------- I have installed sql server 2008 r2 in my system. Already service pack1 (SP1) is installed in my system. Questions are 1. Do I need to uninstall sp1 and reinstall sql server cumulative package 3 in my system? Thanks & Regards Swapna

Hi Swapna, To your question "Do I need to uninstall sp1 and reinstall sql server cumulative package 3 in my system?", actually, there is no need for your to uninstall SP1, you could install the SP3 directly. I guess that you may install a 32-bit of SQL Server 2008 on your server, can you please check whether this instance is 32-bit or 64-bit by running the following statement: USE master; GO SELECT @@VERSION; GO Thanks, Challen Fu

Hi Fu, Thanks for your reply I have checked the instance of sql server 2008 r2 installed in the system by using the following command given by you USE master; GO SELECT @@VERSION; GO output is :- Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation Enterprise Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3) It shows that installed 32 bit sql server 2008 r2 in my system. Thanks & Regards Swapna

Hi Swapna, Since the version of your Microsoft SQL Server 2008 R2 is 32 bit, please make sure your Service Package is also 32-bit

Hi Fu, I have checked the service package. That is also 32 bit. Thanks & Regards Swapna

Hi Swapna, After further reseach, I find that this Hotfix is for your Sql Server 2008 not Sql Server 2008 R2, so that is the root cause why the error jump out. Thanks.

Hi Swapna, After further reseach, I find that this Hotfix(KB971491) is for Sql Server 2008 not Sql Server 2008 R2, so that is the root cause why the error jump out. Here I would recommend you have a check to the subreport to see whether you have set the correct report name and paramter for it, for more information about subreport please refer to this link http://msdn.microsoft.com/en-us/library/ms160348(SQL.100).aspx Thanks, Challen Fu