SQL Server Reporting Services FAQ
Hi All,This thread is a summary of the Frequently Asked Questions on SQL Server Reporting Services. We consolidate them and posthere for your reference. If you have any further questions, please kindly start a new thread so that more community members, MVPs, and MSFTs canjoin the discussion and share their ideas. Thanks for your understanding.Part I: SQL Server Reporting Services General Topics1. How to migrate SQL Server 2008 Reporting Services to another computer? 2. How to combine connecting string via parameter? 3. How to install a 32-bit version of SQL Server 2005 Reporting Services on a computer that is running a 64-bit version of Windows? 4. Error of EXECUTE permission denied on object 'xp_sqlagent_notify'. 5. Security consideration for anonymous access to Report Server. 6. How to create a custom report template in Reporting Services? 7. Does Reporting Services support horizontal tables which have fixed rows and dynamic columns? 8. How to reset the page number back to 1 every time the report gets a group break? 9. How to open the drill- through report in a new browser window? 10. How to verify the version of SQL Server? 11. How to use multiple datasets? 12. How to upgrade report from SQL Server 2000 to SQL Server 2005? 13. Out of memory error when exporting reports to Excel. 14. How to improve PDF quality of the report exported in Reporting Services 2005? 15. How to enable the Select All option for a multi-value parameter? Part II: SQL Server Reporting Services SharePoint Integrated Mode Topics1. How to deploy reports to SQL Server Reporting Services in SharePoint Services integrated mode? 2. How to integrate SQL Server Reporting Services and SharePoint Services? 3. How to refer the reports on the Report Server in SharePoint Services? 4. How to manage user to view reports in SharePoint integrated mode? 5. What information is needed when posting questions regarding SharePoint integrated mode? 6. Is Report Builder available in SharePoint Integrated Mode? PLEASE NOTE: Microsoft does not offer formal support for the communities you'll find here. Instead, our role is to provide a platform for people who want to take advantage of the global community of Microsoft customers and product experts. Microsoft may monitor content to ensure the accuracy of the information you'll find, but any information provided by Microsoft staff is offered "AS IS" with no warranties, and no rights are conferred. You assume all risk for your use. Microsoft Online Community Support
April 23rd, 2009 6:25am

Part I: SQL Server Reporting Services General TopicsQuestion 1: How to migrate SQL Server 2008 Reporting Services to another computer?Answer: The migration process for Reporting Services includes manual and automated steps. The following tasks are part of a report server migration: 1. Back up database, application, and configuration files. 2. Back up the encryption key. 3. Install a new instance of SQL Server 2008. If you are using the same hardware, you can install SQL Server 2008 side-by-side your existing SQL Server 2000 or 2005 installation. Be aware that if you do this, you might need to install SQL Server 2008 as a named instance. 4. Move the report server database and other application files from your SQL Server 2000 or 2005 installation to your new SQL Server 2008 installation. 5. Move any custom application files to the new installation. 6. Configure the report server. 7. Edit RSReportServer.config to include any custom settings from your previous installation. 8. Optionally, configure custom Access Control Lists (ACLs) for the new Reporting Services Windows service group. 9. Test your installation. 10. Remove unused applications and tools after you have confirmed that the new instance is fully operational. If you are reusing an existing report server database that you created in a previous installation, be aware that there are restrictions on the editions of SQL Server you use to host the report server database. For more information, please refer to the following link: Migration (Reporting Services) How to: Migrate a Reporting Services Installation Microsoft Online Community Support
Free Windows Admin Tool Kit Click here and download it now
April 23rd, 2009 6:38am

1. Question 2: How to combine connecting string via parameter? Answer:You can include parameter reference in the data source connection string and allow the user to choose a data source for the report. For example, with an expression-based connection string, a user who is running a sales report can select a data source for a particular county before running the report. The following example illustrates the use of a data source expression in a SQL Server connection string. The example assumes you have created a report parameter named ServerName: ="Data Source=" & Parameters! ServerName.Value & "; initial catalog=AdventureWorks" Microsoft Online Community Support
April 23rd, 2009 6:44am

1. Question 2: How to combine connecting string via parameter? Answer:You can include parameter reference in the data source connection string and allow the user to choose a data source for the report. For example, with an expression-based connection string, a user who is running a sales report can select a data source for a particular county before running the report. The following example illustrates the use of a data source expression in a SQL Server connection string. The example assumes you have created a report parameter named ServerName: ="Data Source=" & Parameters! ServerName.Value & "; initial catalog=AdventureWorks" Microsoft Online Community Support
Free Windows Admin Tool Kit Click here and download it now
April 23rd, 2009 6:44am

1. Question 3: How to install a 32-bit version of SQL Server 2005 Reporting Services on a computer that is running a 64-bit version of Windows? Answer: To install the 32-bit version of Reporting Services on a computer that is running the 64-bit version of IIS 6.0, we can follow these following steps: 1. Uninstall the 64-bit version of Reporting Services. Note: Side-by-side installations of 32-bit versions of Reporting Services and 64-bit versions of Reporting Services are not supported. 2. Run the Dotnetfx64.exe file to manually install the .NET Framework.The Dotnetfx64.exe file is in the Tools\redist\2.0 folder on the SQL Server 2005 Setup media. To download the Dotnetfx64.exe file, visit the following Microsoft Web site: http://go.microsoft.com/fwlink/?LinkId=70186 3. In IIS Manager, click Web Server Extensions. 4. In the Details pane, right-click ASP.NET V2.0.50727, and then click Allow. 5. Right-click Web Sites, and then click Properties. 6. Click the ISAPI Filters tab. 7. In the Filter Name column, click ASP.NET_2.0.50727, and then click Edit. 8. Replace C:\WINDOWS\Microsoft.NET\Framework64\v2.0.50727\aspnet_filter.dll with C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_filter.dll.Note: The Aspnet_filter.dll file in the C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\ folder is a 32-bit version of the file. 9. Click OK two times, and then close IIS Manager. 10. At a command prompt, run the following command: cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1 11. Install the 32-bit version of Reporting Services. 12. After setup is complete, open IIS Manager, and then click Web Server Extensions. 13. In the Details pane, right-click ASP.NET V2.0.50727 (32-bit), and then click Allow. To install the 32-bit version of Reporting Services on a computer that is running the 64-bit version of IIS 7.0, follow these steps: 1. Enable ASP.NET and IIS before you install Reporting Services. 2. Open a command prompt. To do this, click Start, point to All Programs, point to Accessories, right-click Command Prompt, and then click Run as administrator. 3. In the User Account Control dialog box, click Continue. 4. Copy the following script: cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1 5. In the upper-left corner of the Command Prompt window, right-click the command prompt icon, click Edit, and then click Paste. 6. Press ENTER to run the script. 7. Install the 32-bit version of Reporting Services. You must apply SQL Server 2005 Service Pack 2 (SP2) after you install Reporting Services in Windows Vista. If you install SQL Server 2005 Express Edition with Advanced Services, you can run SQL Server 2005 Express Edition with Advanced Services SP2. For more information, visit the following Microsoft Web site: Microsoft SQL Server 2005 Express Edition with Advanced Services Service Pack 2http://go.microsoft.com/fwlink/?LinkID=63922 8. Reset IIS. 9. Configure the report server for local administration. To access the report server and Report Manager locally, follow these steps: a. Start Microsoft Internet Explorer. b. On the Tools menu, click Internet Options. c. Click Security. d. Click Trusted Sites. e. Click Sites. f. Under Add this website to the zone, type http://servername. g. If you are not using HTTPS for the default site, click to clear the Require server certification (https:) for all sites in this zone check box. h. Click Add. i. Repeat steps f and g to add http://localhost, and then click Close. 10. This step lets you start Internet Explorer either to localhost or to the network computer name of the server for both Report Server and Report Manager. a. Create role assignments that explicitly grant you full-permissions access. To do this, follow these steps: b. Start Internet Explorer by using the Run as administrator option. To do this, click Start, click All Programs, right-click Internet Explorer, and then click Run as administrator. c. Start Report Manager. d. Note By default, the Report Manager URL is http://servername/reports. If you are using SQL Server 2005 Express Edition with Advanced Services SP2, the Report Manager URL is http://servername/reports$sqlexpress. If you are using a named instance of Reporting Services, the Report Manager URL is http://servername/reports$InstanceName e. On the Home page, click Properties. f. Click New Role Assignment. g. Type a Windows user account in the following format: domain\user h. Click to select the Content Manager check box. i. Click OK. j. In the upper-right corner of the Home page, click Site Settings. k. Click Configure site-wide security. l. Click New Role Assignment. m. Type a Windows user account in the following format: domain\user n. Click to select the System Administrator check box. o. Click OK. p. Close Report Manager. 11. Open Report Manager in Internet Explorer without using the Run as administrator option. Microsoft Online Community Support
April 23rd, 2009 6:48am

1. Question 3: How to install a 32-bit version of SQL Server 2005 Reporting Services on a computer that is running a 64-bit version of Windows? Answer: To install the 32-bit version of Reporting Services on a computer that is running the 64-bit version of IIS 6.0, we can follow these following steps: 1. Uninstall the 64-bit version of Reporting Services. Note: Side-by-side installations of 32-bit versions of Reporting Services and 64-bit versions of Reporting Services are not supported. 2. Run the Dotnetfx64.exe file to manually install the .NET Framework.The Dotnetfx64.exe file is in the Tools\redist\2.0 folder on the SQL Server 2005 Setup media. To download the Dotnetfx64.exe file, visit the following Microsoft Web site: http://go.microsoft.com/fwlink/?LinkId=70186 3. In IIS Manager, click Web Server Extensions. 4. In the Details pane, right-click ASP.NET V2.0.50727, and then click Allow. 5. Right-click Web Sites, and then click Properties. 6. Click the ISAPI Filters tab. 7. In the Filter Name column, click ASP.NET_2.0.50727, and then click Edit. 8. Replace C:\WINDOWS\Microsoft.NET\Framework64\v2.0.50727\aspnet_filter.dll with C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_filter.dll.Note: The Aspnet_filter.dll file in the C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\ folder is a 32-bit version of the file. 9. Click OK two times, and then close IIS Manager. 10. At a command prompt, run the following command: cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1 11. Install the 32-bit version of Reporting Services. 12. After setup is complete, open IIS Manager, and then click Web Server Extensions. 13. In the Details pane, right-click ASP.NET V2.0.50727 (32-bit), and then click Allow. To install the 32-bit version of Reporting Services on a computer that is running the 64-bit version of IIS 7.0, follow these steps: 1. Enable ASP.NET and IIS before you install Reporting Services. 2. Open a command prompt. To do this, click Start, point to All Programs, point to Accessories, right-click Command Prompt, and then click Run as administrator. 3. In the User Account Control dialog box, click Continue. 4. Copy the following script: cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1 5. In the upper-left corner of the Command Prompt window, right-click the command prompt icon, click Edit, and then click Paste. 6. Press ENTER to run the script. 7. Install the 32-bit version of Reporting Services. You must apply SQL Server 2005 Service Pack 2 (SP2) after you install Reporting Services in Windows Vista. If you install SQL Server 2005 Express Edition with Advanced Services, you can run SQL Server 2005 Express Edition with Advanced Services SP2. For more information, visit the following Microsoft Web site: Microsoft SQL Server 2005 Express Edition with Advanced Services Service Pack 2http://go.microsoft.com/fwlink/?LinkID=63922 8. Reset IIS. 9. Configure the report server for local administration. To access the report server and Report Manager locally, follow these steps: a. Start Microsoft Internet Explorer. b. On the Tools menu, click Internet Options. c. Click Security. d. Click Trusted Sites. e. Click Sites. f. Under Add this website to the zone, type http://servername. g. If you are not using HTTPS for the default site, click to clear the Require server certification (https:) for all sites in this zone check box. h. Click Add. i. Repeat steps f and g to add http://localhost, and then click Close. 10. This step lets you start Internet Explorer either to localhost or to the network computer name of the server for both Report Server and Report Manager. a. Create role assignments that explicitly grant you full-permissions access. To do this, follow these steps: b. Start Internet Explorer by using the Run as administrator option. To do this, click Start, click All Programs, right-click Internet Explorer, and then click Run as administrator. c. Start Report Manager. d. Note By default, the Report Manager URL is http://servername/reports. If you are using SQL Server 2005 Express Edition with Advanced Services SP2, the Report Manager URL is http://servername/reports$sqlexpress. If you are using a named instance of Reporting Services, the Report Manager URL is http://servername/reports$InstanceName e. On the Home page, click Properties. f. Click New Role Assignment. g. Type a Windows user account in the following format: domain\user h. Click to select the Content Manager check box. i. Click OK. j. In the upper-right corner of the Home page, click Site Settings. k. Click Configure site-wide security. l. Click New Role Assignment. m. Type a Windows user account in the following format: domain\user n. Click to select the System Administrator check box. o. Click OK. p. Close Report Manager. 11. Open Report Manager in Internet Explorer without using the Run as administrator option. Microsoft Online Community Support
Free Windows Admin Tool Kit Click here and download it now
April 23rd, 2009 6:48am

Question 4: Error of EXECUTE permission denied on object 'xp_sqlagent_notify'. Problem: In some special cases, you may receive the following error when trying to select the option execution from a report: EXECUTE permission denied on object 'xp_sqlagent_notify', database '######', schema '###'. Cause: Usually, this error is caused by the user missing the "RSExecRole" role in the Master and MSDB system databases. Solution: Reporting Services uses a predefined database role called "RSExecRole" to grant report server permissions to the report server database. If you get the error mentioned above, try to create and provision the "RSExecRole" role in Master and MSDB system database. For more information, see: How to: Create the RSExecRolehttp://technet.microsoft.com/en-us/library/cc281308.aspx Microsoft Online Community Support
April 23rd, 2009 7:14am

Question 5: How to enable anonymous access to Report Server, and is there any security consideration? Answer: Please note that when using anonymous access, every person accesses the reports under the anonymous user context, and no one will have rights to administer Reporting Services through Report Manager.This is the reason why it is not recommended to use anonymous access in Reporting Services. In order to differentiate between users, we need to either disable anonymous access or use a custom security extension. We have a sample using Forms Authentication: Using Forms Authentication in Reporting Services In some special situations, it may be necessary to use anonymous access. For security considerations, we can use the steps as below: 1. Add the anonymous user to the System User role 2. Create an Item-level role with all of the tasks you want this user to be able to use, and then assign the anonymous user to that role at the root level. 3. Check permissions for the anonymous user on folders that SRS uses: For example: C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services (and subfolders) C:\<windows>\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET Files The temp folder for the anonymous user Note: Step1 & Step2 can be accomplished through Report Manager only if anonymous access is disabled and the logged-on user is a member of the System Administrator role.Microsoft Online Community Support
Free Windows Admin Tool Kit Click here and download it now
April 23rd, 2009 7:17am

Question 5: How to enable anonymous access to Report Server, and is there any security consideration? Answer: Please note that when using anonymous access, every person accesses the reports under the anonymous user context, and no one will have rights to administer Reporting Services through Report Manager.This is the reason why it is not recommended to use anonymous access in Reporting Services. In order to differentiate between users, we need to either disable anonymous access or use a custom security extension. We have a sample using Forms Authentication: Using Forms Authentication in Reporting Services In some special situations, it may be necessary to use anonymous access. For security considerations, we can use the steps as below: 1. Add the anonymous user to the System User role 2. Create an Item-level role with all of the tasks you want this user to be able to use, and then assign the anonymous user to that role at the root level. 3. Check permissions for the anonymous user on folders that SRS uses: For example: C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services (and subfolders) C:\<windows>\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET Files The temp folder for the anonymous user Note: Step1 & Step2 can be accomplished through Report Manager only if anonymous access is disabled and the logged-on user is a member of the System Administrator role.Microsoft Online Community Support
April 23rd, 2009 7:17am

Question 6: How to create a custom report template in Reporting Services? Answer: A report template also exists as a normal report (RDL file). If you want to customize your own report templates, you can put the previously prepared reports (which will be used as new templates) in a specific folder. By default, the path is: C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject Then, to use these templates, you can right click on the Reports folder in your project and select New Item. You will then see the name of the report templates you added in the above folder.Microsoft Online Community Support
Free Windows Admin Tool Kit Click here and download it now
April 23rd, 2009 7:20am

Question 6: How to create a custom report template in Reporting Services? Answer: A report template also exists as a normal report (RDL file). If you want to customize your own report templates, you can put the previously prepared reports (which will be used as new templates) in a specific folder. By default, the path is: C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject Then, to use these templates, you can right click on the Reports folder in your project and select New Item. You will then see the name of the report templates you added in the above folder.Microsoft Online Community Support
April 23rd, 2009 7:20am

Question 7: Does SQL Server 2005 Reporting Services support horizontal tables which have fixed rows and dynamic columns? Answer: Note: This Q&A is only for SQL Server 2005 Reporting Services. By default, there is no native "horizontal table" report item. We can use Matrix to simulate simple horizontal tables: 1. Add a matrix to your report. 2. Add static rows to the matrix: Right-click in the Data cell and select "Add Row". Repeat for the number of fixed rows you want. 3. Drag fields into the Data cells:You'll notice that the design tool automatically wraps your field reference in the "First" aggregate (e.g. =First(Fields!City.Value)). Since you're doing this in the context of a matrix, the design tool is ensuring that the expression is meaningful even in the context of a subtotal or if the matrix is showing aggregated data rather than detail data. Note: Please do NOT remove the aggregate expression. 4. Add a column grouping: 1) Right-click on the column header and select "Edit Group". 2) Enter this for the group expression: =RowNumber(Nothing). This will cause the matrix to give you one column per row of data. Since horizontal tables can end up rather wide, you may want your table wrap around to the next "line" after a specific number of columns. 5. Add a list to your report and drag the table into it. 6. Group by a number of rows: 1) Right-click on the list and select Properties. Then click on Edit Details Group.2) Enter this for the group expression: =Ceiling(RowNumber(Nothing)/3) This will cause the list to group on every three rows. So you'll get a separate table for every three rows. 7. Adjust the group expression in the matrix: Edit the column group expression in your matrix and change the RowNumber argument to be the list group name. For example: =RowNumber("list1_Details_Group") More Information: SQL Server 2008 Reporting Services has a new Date Region control named Tablix, which can be used for the same requirement easily. For more information about Tablix, Please refer to the documents below: What's New in Report Authoring Report Definition Tablix Overview Diagram Understanding the Tablix Data Region Working with Tablix Data RegionsMicrosoft Online Community Support
Free Windows Admin Tool Kit Click here and download it now
April 23rd, 2009 7:25am

Question 7: Does SQL Server 2005 Reporting Services support horizontal tables which have fixed rows and dynamic columns? Answer: Note: This Q&A is only for SQL Server 2005 Reporting Services. By default, there is no native "horizontal table" report item. We can use Matrix to simulate simple horizontal tables: 1. Add a matrix to your report. 2. Add static rows to the matrix: Right-click in the Data cell and select "Add Row". Repeat for the number of fixed rows you want. 3. Drag fields into the Data cells:You'll notice that the design tool automatically wraps your field reference in the "First" aggregate (e.g. =First(Fields!City.Value)). Since you're doing this in the context of a matrix, the design tool is ensuring that the expression is meaningful even in the context of a subtotal or if the matrix is showing aggregated data rather than detail data. Note: Please do NOT remove the aggregate expression. 4. Add a column grouping: 1) Right-click on the column header and select "Edit Group". 2) Enter this for the group expression: =RowNumber(Nothing). This will cause the matrix to give you one column per row of data. Since horizontal tables can end up rather wide, you may want your table wrap around to the next "line" after a specific number of columns. 5. Add a list to your report and drag the table into it. 6. Group by a number of rows: 1) Right-click on the list and select Properties. Then click on Edit Details Group.2) Enter this for the group expression: =Ceiling(RowNumber(Nothing)/3) This will cause the list to group on every three rows. So you'll get a separate table for every three rows. 7. Adjust the group expression in the matrix: Edit the column group expression in your matrix and change the RowNumber argument to be the list group name. For example: =RowNumber("list1_Details_Group") More Information: SQL Server 2008 Reporting Services has a new Date Region control named Tablix, which can be used for the same requirement easily. For more information about Tablix, Please refer to the documents below: What's New in Report Authoring Report Definition Tablix Overview Diagram Understanding the Tablix Data Region Working with Tablix Data RegionsMicrosoft Online Community Support
April 23rd, 2009 7:25am

Question 8: How to reset the page number back to 1 every time the report gets a group break? Answer: Resetting the page number on group breaks is not natively supported. There is a workaround: you can track group breaks in a shared variable, and reset this variable to 1 when reaches a new group break. Here are the steps: 1. Make sure there's a textbox in the report which contains the group expression. 2. Add shared variables to track the current group and page offset: Shared offset as Integer Shared currentgroup as Object 3. Add a custom function to set the shared variables and retrieve the group page number: Public Function GetGroupPageNumber(group as Object, pagenumber as Integer) as Object If Not (group = currentgroup) offset = pagenumber - 1 currentgroup = group End If Return pagenumber - offset End Function 4. Use the function in the page header or footer: =Code.GetGroupPageNumber(ReportItems!Category.Value,Globals!PageNumber)Microsoft Online Community Support
Free Windows Admin Tool Kit Click here and download it now
April 23rd, 2009 7:28am

Question 8: How to reset the page number back to 1 every time the report gets a group break? Answer: Resetting the page number on group breaks is not natively supported. There is a workaround: you can track group breaks in a shared variable, and reset this variable to 1 when reaches a new group break. Here are the steps: 1. Make sure there's a textbox in the report which contains the group expression. 2. Add shared variables to track the current group and page offset: Shared offset as Integer Shared currentgroup as Object 3. Add a custom function to set the shared variables and retrieve the group page number: Public Function GetGroupPageNumber(group as Object, pagenumber as Integer) as Object If Not (group = currentgroup) offset = pagenumber - 1 currentgroup = group End If Return pagenumber - offset End Function 4. Use the function in the page header or footer: =Code.GetGroupPageNumber(ReportItems!Category.Value,Globals!PageNumber)Microsoft Online Community Support
April 23rd, 2009 7:28am

Question 9: How to open the drill- through report in a new browser window? Answer: Generally, if you use the "Jump to URL" option for a textbox, it will redirect to the specific URL in the same browser when the user clicks on the textbox. To open the link in a new window, you can use syntax similar to this: ="javascript:void window.open ('http://servername/reportserver?/freportfolder/ReportName&Parameter1=" & Fields!Field1.Value & "&Field2=" & Fields!Field2.Value & "&rs:Command=Render','_blank','resizeable=1,toolbar=0,status=0,menu=0,top=20,left=20,width=740,height=730')" Microsoft Online Community Support
Free Windows Admin Tool Kit Click here and download it now
April 23rd, 2009 7:30am

Question 9: How to open the drill- through report in a new browser window? Answer: Generally, if you use the "Jump to URL" option for a textbox, it will redirect to the specific URL in the same browser when the user clicks on the textbox. To open the link in a new window, you can use syntax similar to this: ="javascript:void window.open ('http://servername/reportserver?/freportfolder/ReportName&Parameter1=" & Fields!Field1.Value & "&Field2=" & Fields!Field2.Value & "&rs:Command=Render','_blank','resizeable=1,toolbar=0,status=0,menu=0,top=20,left=20,width=740,height=730')" Microsoft Online Community Support
April 23rd, 2009 7:30am

Question 10: How to verify the version of SQL Server? Answer: There are a few ways to verify the version of SQL Server. Method 1. You can run a query "SELECT @@VERSION" and note the version number returned in the string. SQL Server 2005 SP1 would return something like the following: Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Sep 22 2006 23:44:32 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1) Method 2. you can also look at the file version for sqlservr.exe. Method 3. If you look in Add\Remove Programs, you would also see an entry for Service Pack 1 for SQL Server <component name>. Each patched component would have its own entry. Please note that you will need to select the "Show Updates" check box in the Add\Remove Programs dialog. Method 4. You can check the registry keys and values under: HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server There are several other areas that contain version information. Shared components generally have a Setup sub-key under "HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server \90\<Component>". For example: ...\90\DTS\Setup ...\90\Tools\Setup ...\90\NS\Setup Then for each instance of SQL\Analysis Services\Reporting Services, you can look under the instance specific key. These keys are numbered as MSSQL.x (where x is the instance number). These are created in the order of installation. So if you have only a single instance of SQL Server, the instance key would be MSSQL.1. Under each instance key you'll find a Setup key as well. In all cases, the Setup sub-key contains a value of PatchLevel, which equals the version of the instance. For example, for SQL Server 2005 RTM, the value should be 9.0.1399, and SP1 would be 9.0.2047. Microsoft Online Community Support
Free Windows Admin Tool Kit Click here and download it now
April 23rd, 2009 7:36am

Question 10: How to verify the version of SQL Server? Answer: There are a few ways to verify the version of SQL Server. Method 1. You can run a query "SELECT @@VERSION" and note the version number returned in the string. SQL Server 2005 SP1 would return something like the following: Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Sep 22 2006 23:44:32 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1) Method 2. you can also look at the file version for sqlservr.exe. Method 3. If you look in Add\Remove Programs, you would also see an entry for Service Pack 1 for SQL Server <component name>. Each patched component would have its own entry. Please note that you will need to select the "Show Updates" check box in the Add\Remove Programs dialog. Method 4. You can check the registry keys and values under: HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server There are several other areas that contain version information. Shared components generally have a Setup sub-key under "HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server \90\<Component>". For example: ...\90\DTS\Setup ...\90\Tools\Setup ...\90\NS\Setup Then for each instance of SQL\Analysis Services\Reporting Services, you can look under the instance specific key. These keys are numbered as MSSQL.x (where x is the instance number). These are created in the order of installation. So if you have only a single instance of SQL Server, the instance key would be MSSQL.1. Under each instance key you'll find a Setup key as well. In all cases, the Setup sub-key contains a value of PatchLevel, which equals the version of the instance. For example, for SQL Server 2005 RTM, the value should be 9.0.1399, and SP1 would be 9.0.2047. Microsoft Online Community Support
April 23rd, 2009 7:36am

Question 11: How to use multiple datasets? Answer: You can combine two or more datasets in one report. There are multiple options to achieve this: If the data comes from different tables in the same database, join the datasets based on a common key present in both tables. Use the Linked Server functionality. For more information, see Accessing External Data Use the OpenRowSet functionality to join data from another database server into the current query. For more information, see OPENROWSET (Transact-SQL)Microsoft Online Community Support
Free Windows Admin Tool Kit Click here and download it now
April 23rd, 2009 7:39am

Question 11: How to use multiple datasets? Answer: You can combine two or more datasets in one report. There are multiple options to achieve this: If the data comes from different tables in the same database, join the datasets based on a common key present in both tables. Use the Linked Server functionality. For more information, see Accessing External Data Use the OpenRowSet functionality to join data from another database server into the current query. For more information, see OPENROWSET (Transact-SQL)Microsoft Online Community Support
April 23rd, 2009 7:39am

Question 12: How to upgrade report from SQL Server 2000 to SQL Server 2005? Answer: You can use the following steps: 1. Back up ReportServer and ReportServerTemDB. 2. Back up encryption keys from Reporting services 2000 by using RsKeyMgmt. 3. Restore the databases backed up from step 1. 4. Connect to newly restored databases from step 3 from Reporting Services 2005 Configuration manager and database setup. 5. By using the provided credentials, Reporting Services will connect to new databases and perform the upgrade operations. 6. Confirm Reporting services upgrading the database and granting adequate rights to the credential account. 7. Restore backed up keys from step 2. Confirm that everything is displayed as green now. Reference: How to: Start Reporting Services Configuration How to: Back Up the Reporting Services Encryption Key Reporting Services Configuration How-to Topics How to: Create a Report Server Database (Reporting Services Configuration) Upgrading a Report Server Database Microsoft Online Community Support
Free Windows Admin Tool Kit Click here and download it now
April 23rd, 2009 7:41am

Question 12: How to upgrade report from SQL Server 2000 to SQL Server 2005? Answer: You can use the following steps: 1. Back up ReportServer and ReportServerTemDB. 2. Back up encryption keys from Reporting services 2000 by using RsKeyMgmt. 3. Restore the databases backed up from step 1. 4. Connect to newly restored databases from step 3 from Reporting Services 2005 Configuration manager and database setup. 5. By using the provided credentials, Reporting Services will connect to new databases and perform the upgrade operations. 6. Confirm Reporting services upgrading the database and granting adequate rights to the credential account. 7. Restore backed up keys from step 2. Confirm that everything is displayed as green now. Reference: How to: Start Reporting Services Configuration How to: Back Up the Reporting Services Encryption Key Reporting Services Configuration How-to Topics How to: Create a Report Server Database (Reporting Services Configuration) Upgrading a Report Server Database Microsoft Online Community Support
April 23rd, 2009 7:41am

Question 13: Out of memory error when exporting reports to Excel. Problem: We may encounter Out of memory error when exporting reports to Excel. Cause: Generally, this kind problem is complicated. There are some possible factors that may cause this issue: 1. On the x86 platform using the /3GB switch, the OS makes about 1.8 GB (maximum) available to be shared by all applications. 2. The .NET Framework 1.1/2.0 supports the use of the /3GB switch. However, it must share the OS-imposed limit of approximately 1.8 GB memory. 3. Using the /3GB switch cuts down the amount non-paged pool (NPP) memory HTTP.SYS (a kernel-mode driver IIS 6.0) uses to manage its connections, to 128 MB from 250 MB. This could negatively impact performance of IIS, should other sites be hosted on the server. 4. NET applications (of which SSRS is one) typically encounter out-of-memory issues at approximately 1.1 GB (+/- a wide margin, depending on many factors). 5. SSRS currently uses in-memory data caching and rendering; a streaming design needed to process extremely large reports simply does not exist at this time. Solution: You may try the following suggestions first: 1. Please refer to this KB: You may receive the "System.OutOfMemoryException" error message when you use SQL Server Reporting Services 2. Break the report to get smaller amount of data. 3. You can try using a 64-bit machine which doesn't have limitation of 2GB of usermode space. 4. You can test /3GB switch (of course not recommended on a production server) which allows to allocate 1GB to Kernel mode and 3GB to user mode.http://www.microsoft.com/technet/prodtechnol/windowsserver2003/library/ServerHelp/927bfe25-1705-4b60-91d4-2ed64d6aa85f.mspx 5. In general the 3GB switch should be used only for testing purposes since this setting shrinks the available address space for the Kernel mode. Below is a KB article that briefly talks about this:A description of the 4 GB RAM Tuning feature and the Physical Address Extension switch 6. Ensure that the Memory recycling checkboxes are unchecked for the SSRS app pool in IIS. Note: Excel rendering is improved in the Reporting Services 2008 and this issue may not occur in Reporting Services 2008.Microsoft Online Community Support
Free Windows Admin Tool Kit Click here and download it now
April 23rd, 2009 7:44am

Question 13: Out of memory error when exporting reports to Excel. Problem: We may encounter Out of memory error when exporting reports to Excel. Cause: Generally, this kind problem is complicated. There are some possible factors that may cause this issue: 1. On the x86 platform using the /3GB switch, the OS makes about 1.8 GB (maximum) available to be shared by all applications. 2. The .NET Framework 1.1/2.0 supports the use of the /3GB switch. However, it must share the OS-imposed limit of approximately 1.8 GB memory. 3. Using the /3GB switch cuts down the amount non-paged pool (NPP) memory HTTP.SYS (a kernel-mode driver IIS 6.0) uses to manage its connections, to 128 MB from 250 MB. This could negatively impact performance of IIS, should other sites be hosted on the server. 4. NET applications (of which SSRS is one) typically encounter out-of-memory issues at approximately 1.1 GB (+/- a wide margin, depending on many factors). 5. SSRS currently uses in-memory data caching and rendering; a streaming design needed to process extremely large reports simply does not exist at this time. Solution: You may try the following suggestions first: 1. Please refer to this KB: You may receive the "System.OutOfMemoryException" error message when you use SQL Server Reporting Services 2. Break the report to get smaller amount of data. 3. You can try using a 64-bit machine which doesn't have limitation of 2GB of usermode space. 4. You can test /3GB switch (of course not recommended on a production server) which allows to allocate 1GB to Kernel mode and 3GB to user mode.http://www.microsoft.com/technet/prodtechnol/windowsserver2003/library/ServerHelp/927bfe25-1705-4b60-91d4-2ed64d6aa85f.mspx 5. In general the 3GB switch should be used only for testing purposes since this setting shrinks the available address space for the Kernel mode. Below is a KB article that briefly talks about this:A description of the 4 GB RAM Tuning feature and the Physical Address Extension switch 6. Ensure that the Memory recycling checkboxes are unchecked for the SSRS app pool in IIS. Note: Excel rendering is improved in the Reporting Services 2008 and this issue may not occur in Reporting Services 2008.Microsoft Online Community Support
April 23rd, 2009 7:44am

Question 14: How to improve PDF quality of the report exported in Reporting Services 2005? Answer: The PDF renderer in Reporting Services 2005 resizes all images that it is given at 96 DPI no matter what DPI the image is when you pass it to the renderer. That means that a 300 DPI image or even a 600 DPI image will be sized in the PDF as if it is only 96 DPI. In other words, your high DPI image may render larger than expected. Despite sizing the images as if they were 96 DPI, the PDF renderer appears to render higher DPI images at a higher quality than 96 DPI. Even if the sizing being wrong, the image actually is rendering at a higher quality. A necessary workaround is to size the image to the proper number of inches based on 96 DPI calculations. Then use Bitmap.SetResolution to set the images to at least 300 DPI. That may provide a higher quality image that is the proper number of pixels to fit properly in the report.Microsoft Online Community Support
Free Windows Admin Tool Kit Click here and download it now
April 23rd, 2009 7:47am

Question 14: How to improve PDF quality of the report exported in Reporting Services 2005? Answer: The PDF renderer in Reporting Services 2005 resizes all images that it is given at 96 DPI no matter what DPI the image is when you pass it to the renderer. That means that a 300 DPI image or even a 600 DPI image will be sized in the PDF as if it is only 96 DPI. In other words, your high DPI image may render larger than expected. Despite sizing the images as if they were 96 DPI, the PDF renderer appears to render higher DPI images at a higher quality than 96 DPI. Even if the sizing being wrong, the image actually is rendering at a higher quality. A necessary workaround is to size the image to the proper number of inches based on 96 DPI calculations. Then use Bitmap.SetResolution to set the images to at least 300 DPI. That may provide a higher quality image that is the proper number of pixels to fit properly in the report.Microsoft Online Community Support
April 23rd, 2009 7:47am

Question 15: How to enable the Select All option for a multi-value parameter? Problem: When a user defines an available values list for a multi-value parameter, a Select ALL option on the report parameter drop-down list automatically appears. However, if you dont want to make the parameter multi-value, how to enable the Select All option for the query parameter? Solution: Since the single-value query parameter does not provide the Select All option, you cannot query the data without any limitations. Sometimes, the end user may want to ignore the condition for the parameterized query. In this case, you can add the "Select All" option to the parameter dataset by using SQL statement. Here are the detailed steps: Create a dataset for the parameter using the following query string: SELECT ALL UNION ALL SELECT Field from table Edit your base dataset query: The original query: AND Field=@Parameter Change it to this: AND (( Field=@Parameter ))OR(@Parameter=ALL)) Set the report parameter. 1) Set the available values as the field created in Step 1. 2) Set the default value of parameter to All.Microsoft Online Community Support
Free Windows Admin Tool Kit Click here and download it now
April 23rd, 2009 7:48am

Question 15: How to enable the Select All option for a multi-value parameter? Problem: When a user defines an available values list for a multi-value parameter, a Select ALL option on the report parameter drop-down list automatically appears. However, if you dont want to make the parameter multi-value, how to enable the Select All option for the query parameter? Solution: Since the single-value query parameter does not provide the Select All option, you cannot query the data without any limitations. Sometimes, the end user may want to ignore the condition for the parameterized query. In this case, you can add the "Select All" option to the parameter dataset by using SQL statement. Here are the detailed steps: Create a dataset for the parameter using the following query string: SELECT ALL UNION ALL SELECT Field from table Edit your base dataset query: The original query: AND Field=@Parameter Change it to this: AND (( Field=@Parameter ))OR(@Parameter=ALL)) Set the report parameter. 1) Set the available values as the field created in Step 1. 2) Set the default value of parameter to All.Microsoft Online Community Support
April 23rd, 2009 7:48am

Part II: SQL Server Reporting Services SharePoint Integrated Mode Topics Question 1: How to deploy reports to SQL Server Reporting Services in SharePoint Services integrated mode? Question: How to deploy reports to SQL Server Reporting Services in SharePoint Services integrated mode? Answer: You can use the following steps: 1. Create a web application in SharePoint with Report Center template. 2. Open Business Intelligence Development Studio and modify report solution properties as below: TargetDataSourceFolder The format for this URL like:http<s>://<server>/<site>/<report center>/<data source> TargetReportFolder The format for this URL like:http<s>://<server>/<site>/< report center>/<folder> TargetServerURL The format for this URL like: http<s>://<server>/<site>/< report center> 3. Deploy the report. Microsoft Online Community Support
Free Windows Admin Tool Kit Click here and download it now
April 23rd, 2009 7:55am

Part II: SQL Server Reporting Services SharePoint Integrated Mode Topics Question 1: How to deploy reports to SQL Server Reporting Services in SharePoint Services integrated mode? Question: How to deploy reports to SQL Server Reporting Services in SharePoint Services integrated mode? Answer: You can use the following steps: 1. Create a web application in SharePoint with Report Center template. 2. Open Business Intelligence Development Studio and modify report solution properties as below: TargetDataSourceFolder The format for this URL like:http<s>://<server>/<site>/<report center>/<data source> TargetReportFolder The format for this URL like:http<s>://<server>/<site>/< report center>/<folder> TargetServerURL The format for this URL like: http<s>://<server>/<site>/< report center> 3. Deploy the report. Microsoft Online Community Support
April 23rd, 2009 7:55am

Question 2: How to integrate SQL Server Reporting Services and SharePoint Services? Answer: 1. Check the requirements for running reporting service in SharePoint integrated mode: Requirements for Running Reporting Services in SharePoint Integrated Mode 2. Follow the documents below to configure the server: Configuring Reporting Services for SharePoint 3.0 Integration For more information for Reporting Services and SharePoint Technology Integration, please refer to:Reporting Services and SharePoint Technology Integration Microsoft Online Community Support
Free Windows Admin Tool Kit Click here and download it now
April 23rd, 2009 8:00am

Question 2: How to integrate SQL Server Reporting Services and SharePoint Services? Answer: 1. Check the requirements for running reporting service in SharePoint integrated mode: Requirements for Running Reporting Services in SharePoint Integrated Mode 2. Follow the documents below to configure the server: Configuring Reporting Services for SharePoint 3.0 Integration For more information for Reporting Services and SharePoint Technology Integration, please refer to:Reporting Services and SharePoint Technology Integration Microsoft Online Community Support
April 23rd, 2009 8:00am

Question 3: How to refer the reports on the Report Server in SharePoint Services? Answer: After integrating SQL Server Reporting Services with SharePoint Services, you can refer a SSRS report in SharePoint Services. Here is the steps: 1. Install the SQL Server Reporting Services Add-in for SharePoint For more information, see How to: Install or Uninstall the Reporting Services Add-in 2. Refer to the documents below for using SQL Server Reporting Services Add-in: Using the Report Viewer Web Part on a SharePoint SiteMicrosoft Online Community Support
Free Windows Admin Tool Kit Click here and download it now
April 23rd, 2009 8:02am

Question 3: How to refer the reports on the Report Server in SharePoint Services? Answer: After integrating SQL Server Reporting Services with SharePoint Services, you can refer a SSRS report in SharePoint Services. Here is the steps: 1. Install the SQL Server Reporting Services Add-in for SharePoint For more information, see How to: Install or Uninstall the Reporting Services Add-in 2. Refer to the documents below for using SQL Server Reporting Services Add-in: Using the Report Viewer Web Part on a SharePoint SiteMicrosoft Online Community Support
April 23rd, 2009 8:02am

Question 4: How to manage user to view reports in SharePoint integrated mode? Answer: In SharePoint website, if the default security settings do not meet your requirements, you can create new permission levels for the specific report server items or operations. Custom security settings are helpful if restricting access to a particular report is required. To customize permissions of viewing reports, please refer to the following documents: Granting Permissions on Report Server Items on a SharePoint SiteHow to: Set Permissions for Report Server Items on a SharePoint Site (Reporting Services in SharePoint Integrated Mode)Microsoft Online Community Support
Free Windows Admin Tool Kit Click here and download it now
April 23rd, 2009 8:03am

Question 5: What information is needed when posting questions regarding SharePoint integrated mode? Answer: To efficiently troubleshoot issues in forums, please provide the following information when posting questions: 1. Detailed Error Information. 2. Operation System Edition and Version. 3. SQL Server Edition and Version. 4. SharePoint Service Edition and Version. 5. SQL Server log. By default, the path is as below: For SQL 2005: C:\Program Files\Microsoft SQL Server\MSSQL.x\Reporting Services\LogFiles\ For SQL 2008: C:\Program Files\Microsoft SQL Server\MSRS10.<instance_name>\Reporting Services\LogFiles\ 6. Detailed SharePoint log. By default, the path is C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\LOGS\ 7. The SQL Server Error information in Windows Application Event.Microsoft Online Community Support
April 23rd, 2009 8:03am

Question 4: How to manage user to view reports in SharePoint integrated mode? Answer: In SharePoint website, if the default security settings do not meet your requirements, you can create new permission levels for the specific report server items or operations. Custom security settings are helpful if restricting access to a particular report is required. To customize permissions of viewing reports, please refer to the following documents: Granting Permissions on Report Server Items on a SharePoint SiteHow to: Set Permissions for Report Server Items on a SharePoint Site (Reporting Services in SharePoint Integrated Mode)Microsoft Online Community Support
Free Windows Admin Tool Kit Click here and download it now
April 23rd, 2009 8:03am

Question 5: What information is needed when posting questions regarding SharePoint integrated mode? Answer: To efficiently troubleshoot issues in forums, please provide the following information when posting questions: 1. Detailed Error Information. 2. Operation System Edition and Version. 3. SQL Server Edition and Version. 4. SharePoint Service Edition and Version. 5. SQL Server log. By default, the path is as below: For SQL 2005: C:\Program Files\Microsoft SQL Server\MSSQL.x\Reporting Services\LogFiles\ For SQL 2008: C:\Program Files\Microsoft SQL Server\MSRS10.<instance_name>\Reporting Services\LogFiles\ 6. Detailed SharePoint log. By default, the path is C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\LOGS\ 7. The SQL Server Error information in Windows Application Event.Microsoft Online Community Support
April 23rd, 2009 8:03am

Question 6: Is Report Builder available in SharePoint Integrated Mode?Reporting Services and SharePoint Technology Integration Answer: Yes. After integrating with SharePoint, what you need to do is to add Report Builder Model through Content Types: Open SharePoint website as administrator. Click Report Center website. Click Site Actions list. Select Site Settings and then select Modify Pages Library Settings. On Content Types part, click Add from existing site content types. Select Report Server Content Types from site content types drop-down list. Select Report Builder. Click OK to finish. After that, you will be able to use Report Builder. Please Note: Currently, Report Builder 2.0 has been released as a stand-alone installation for SQL Server 2008 Reporting Service. However, Report Builder 1.0 can still be used for SharePoint as a "click-once" application. This function will be included in the future service pack of SQL Server 2008. ------------------------------ More references on SQL Server Reporting Services SharePoint Integrated Mode: Security Overview for Reporting Services in SharePoint Integrated Mode Viewing and Managing Report Server Items from a SharePoint Site Security Overview for Reporting Services in SharePoint Integrated Mode
Free Windows Admin Tool Kit Click here and download it now
April 23rd, 2009 8:05am

Question 6: Is Report Builder available in SharePoint Integrated Mode?Reporting Services and SharePoint Technology Integration Answer: Yes. After integrating with SharePoint, what you need to do is to add Report Builder Model through Content Types: Open SharePoint website as administrator. Click Report Center website. Click Site Actions list. Select Site Settings and then select Modify Pages Library Settings. On Content Types part, click Add from existing site content types. Select Report Server Content Types from site content types drop-down list. Select Report Builder. Click OK to finish. After that, you will be able to use Report Builder. Please Note: Currently, Report Builder 2.0 has been released as a stand-alone installation for SQL Server 2008 Reporting Service. However, Report Builder 1.0 can still be used for SharePoint as a "click-once" application. This function will be included in the future service pack of SQL Server 2008. ------------------------------ More references on SQL Server Reporting Services SharePoint Integrated Mode: Security Overview for Reporting Services in SharePoint Integrated Mode Viewing and Managing Report Server Items from a SharePoint Site Security Overview for Reporting Services in SharePoint Integrated Mode
April 23rd, 2009 8:05am

Hi Thanks fordocumentation but I have some problem in below line Add a list to your report and drag the table into itfrom where I will get the list Is it any control or something else.any example for using espression .thanks
Free Windows Admin Tool Kit Click here and download it now
May 13th, 2009 12:43am

Hi Thanks fordocumentation but I have some problem in below line Add a list to your report and drag the table into itfrom where I will get the list Is it any control or something else.any example for using espression .thanks
May 13th, 2009 12:43am

@Joe - Wu For Question 10 :- I think we can use this query :- SELECT SERVERPROPERTY('productversion')as ProductVersion, SERVERPROPERTY ('productlevel')as ProductLevel, SERVERPROPERTY ('edition') as ServerEdition above query will give more meaningful result. For question 2:- This dynamic query thing does not work in case of Shared Connection . It work perfectly in case of Inbuilt report connection. ~~ Mark it as Answer if you find it correct~~
Free Windows Admin Tool Kit Click here and download it now
May 17th, 2009 3:50pm

Hi, Its not enough to thank for this useful thread. PLease post some more useful interview questions along with answers in the same thread. Thanks & Regards, MahaswetaMahasweta das
July 8th, 2009 3:04am

Hi, Its not enough to thank for this useful thread. PLease post some more useful interview questions along with answers in the same thread. Thanks & Regards, MahaswetaMahasweta das
Free Windows Admin Tool Kit Click here and download it now
July 8th, 2009 3:04am

Very sorry to write in this section of this forum but I really do not find where to write my question: since several days I am trying to download from https://msdn.microsoft.com/en-us/subscriptions/securedownloads/default.aspx SQL Server 2008 Web (x86, x64) - DVD (English) But it seems impossible because after 80% downloading the download stops. Can you help me to solve the problem? Thank you very much for helping.
October 11th, 2009 10:56am

Very sorry to write in this section of this forum but I really do not find where to write my question: since several days I am trying to download from https://msdn.microsoft.com/en-us/subscriptions/securedownloads/default.aspx SQL Server 2008 Web (x86, x64) - DVD (English) But it seems impossible because after 80% downloading the download stops. Can you help me to solve the problem? Thank you very much for helping.
Free Windows Admin Tool Kit Click here and download it now
October 11th, 2009 10:56am

Thanks very much for this solution... thanks thanks.Capahttp://capa.bhipglobal.com
January 15th, 2010 11:00am

Thanks very much for this solution... thanks thanks.Capahttp://capa.bhipglobal.com
Free Windows Admin Tool Kit Click here and download it now
January 15th, 2010 11:00am

Hi Joe,I have an issue with reporting services 2008, i need to set a system-level security to my server (exp : add my login as a system administrator) using rs.exe tool.I have used microsoft sample AddItemSecurity.rss to add an item-level, but there is no sample how to add a new system administrator to my reportServer site ( Site settings --> security-->new role Assignement)if you have any sample, please let me knowThank-you!
January 29th, 2010 4:42pm

Hi Joe,I have an issue with reporting services 2008, i need to set a system-level security to my server (exp : add my login as a system administrator) using rs.exe tool.I have used microsoft sample AddItemSecurity.rss to add an item-level, but there is no sample how to add a new system administrator to my reportServer site ( Site settings --> security-->new role Assignement)if you have any sample, please let me knowThank-you!
Free Windows Admin Tool Kit Click here and download it now
January 29th, 2010 4:42pm

I cannot determine how to start a new thread, but my question is as follows:Why is "Generate Model" missing from my data source? Is there something wrong with my data source? It's a SQL Server data source.
February 20th, 2010 12:58am

I cannot determine how to start a new thread, but my question is as follows:Why is "Generate Model" missing from my data source? Is there something wrong with my data source? It's a SQL Server data source.
Free Windows Admin Tool Kit Click here and download it now
February 20th, 2010 12:58am

Is this forum still active and allowing new threads, or has it been shut down like so many others?
February 20th, 2010 12:59am

Is this forum still active and allowing new threads, or has it been shut down like so many others?
Free Windows Admin Tool Kit Click here and download it now
February 20th, 2010 12:59am

Thanks Joe! A concrete example would help here. If we start with an image that is intended to cover an area of 8.0 inches by 10.5 inches at a resolution of 300 dpi, how should the file be configured? I'm confused by the directive "size the image to the proper number of inches based on 96 DPI calculations". Does this mean that we're actually adding pixels to the file or maybe that we're adding bogus attributes? Does this apply only to the PDF renderer and not to printing from the viewers? Does this not apply to Reporting Services 2008 or 2010? BillVo
March 15th, 2010 7:03pm

Thanks Joe! A concrete example would help here. If we start with an image that is intended to cover an area of 8.0 inches by 10.5 inches at a resolution of 300 dpi, how should the file be configured? I'm confused by the directive "size the image to the proper number of inches based on 96 DPI calculations". Does this mean that we're actually adding pixels to the file or maybe that we're adding bogus attributes? Does this apply only to the PDF renderer and not to printing from the viewers? Does this not apply to Reporting Services 2008 or 2010? BillVo
Free Windows Admin Tool Kit Click here and download it now
March 15th, 2010 7:03pm

can we get similar information for SQL server 2008 R2 upgrade from SQL 2k8 ? Specially for Reporting services. regards, Mit mitkush
May 26th, 2010 2:03pm

can we get similar information for SQL server 2008 R2 upgrade from SQL 2k8 ? Specially for Reporting services. regards, Mit mitkush
Free Windows Admin Tool Kit Click here and download it now
May 26th, 2010 2:03pm

can we get similar information for SQL server 2008 R2 upgrade from SQL 2k8 ? Specially for Reporting services. After upgrade i got following error when i tried to run report from MOSS 2007 sharepoint farm. An error occurred during client rendering. Unsupported RPL stream version detected: 34.62.1836345404. Expected version: 10.3. My original post http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/44992b65-a404-4798-b5bd-8f5a3e930daa regards, Mitmitkush
May 26th, 2010 2:06pm

can we get similar information for SQL server 2008 R2 upgrade from SQL 2k8 ? Specially for Reporting services. After upgrade i got following error when i tried to run report from MOSS 2007 sharepoint farm. An error occurred during client rendering. Unsupported RPL stream version detected: 34.62.1836345404. Expected version: 10.3. My original post http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/44992b65-a404-4798-b5bd-8f5a3e930daa regards, Mitmitkush
Free Windows Admin Tool Kit Click here and download it now
May 26th, 2010 2:06pm

Question 9: How to open the drill- through report in a new browser window? Answer: Generally, if you use the "Jump to URL" option for a textbox, it will redirect to the specific URL in the same browser whn the user clicks on the textbox. To open the link in a new window, you can use syntax similar to this: ="javascript:void window.open ('http://servername/reportserver?/freportfolder/ReportName&Parameter1=" & Fields!Field1.Value & "&Field2=" & Fields!Field2.Value & "&rs:Command=Render','_blank','resizeable=1,toolbar=0,status=0,menu=0,top=20,left=20,width=740,height=730')" Microsoft Online Community upport Glad to follow what you said, Here is also the same case.
August 21st, 2010 10:26pm

Question 9: How to open the drill- through report in a new browser window? Answer: Generally, if you use the "Jump to URL" option for a textbox, it will redirect to the specific URL in the same browser whn the user clicks on the textbox. To open the link in a new window, you can use syntax similar to this: ="javascript:void window.open ('http://servername/reportserver?/freportfolder/ReportName&Parameter1=" & Fields!Field1.Value & "&Field2=" & Fields!Field2.Value & "&rs:Command=Render','_blank','resizeable=1,toolbar=0,status=0,menu=0,top=20,left=20,width=740,height=730')" Microsoft Online Community upport Glad to follow what you said, Here is also the same case.
Free Windows Admin Tool Kit Click here and download it now
August 21st, 2010 10:26pm

I cannot determine how to start a new thread, but my question is as follows: Just click on Ask Question on the top of the selected forum. Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM
October 28th, 2010 1:16am

I cannot determine how to start a new thread, but my question is as follows: Just click on Ask Question on the top of the selected forum. Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM
Free Windows Admin Tool Kit Click here and download it now
October 28th, 2010 1:16am

Thanks very much for this solution... !!reputation managemant
January 27th, 2012 12:57am

Thanks very much for this solution... !!reputation managemant
Free Windows Admin Tool Kit Click here and download it now
January 27th, 2012 12:57am

Very much informational...Thanks for sharing this useful stuff.
July 29th, 2012 8:54am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics