Browse by Tags

Tagged Content List
  • Wiki Page: SSRS Troubleshooting: Report Builder does not work after you upgrade from SQL Server 2008 SP1 to SQL Server 2008 R2

    Background: The default click-once version of Report Builder that will be used with SQL Server 2008 Reporting Services is Report Builder 1.0. If the Custom Report Builder Launch URL was modified to use Report Builder 2.0, then Report Builder may no longer work following an upgrade to SQL Server...
  • Wiki Page: SQL Server Reporting Services

    Overview Microsoft SQL Server Reporting Services (SSRS) provides a complete, server-based platform designed to support a wide variety of reporting needs enabling organizations to deliver relevant information where needed across the entire enterprise. Reporting Services provides a...
  • Wiki Page: SSRS Report

    Table of Contents Overview Power View Other Reporting Options See Also Overview SQL Server Reporting Services provides a full range of ready-to-use tools and services to help you create, deploy, and manage reports for your organization, as well as programming features that enable you to extend...
  • Wiki Page: Running Total at Page Footer in Reporting Services

    I was Asked by my client to Display the Running Total at the Page Footer , Initially thought it was an easy task ...Just Refer the Text Box where the field was Placed and do some small Rework would yield the Result,,But NO !!!! !!!It Turned out to be harder than what i expected. After some amount...
  • Wiki Page: Kerberos for Microsoft BI - With Delegation and SPN references for SQL, SSRS, SSAS, and SharePoint

    Here are the articles that can help with Kerberos, delegation, and getting Integrated Windows Authentication working with the Microsoft BI stack. What is the Microsoft BI stack? http://www.microsoft.com/bi lists SQL Server, SharePoint and Office as part of the Microsoft BI stack. Historically...
  • Wiki Page: SharePoint 2010: You Cannot See Reporting Services Icons After You Upgrade

    Table of Contents Background Workaround Applies to See Also Background Following the upgrade of a SharePoint environment to SharePoint 2010 Products, you may not be able to see the Reporting Services icons on several of the Web pages. For example, the document library context menu you see for...
  • Wiki Page: SharePoint 2010: SSRS Troubleshooting - You See an Error Message Regarding ContainerTypeNotSupported When You View a Report from a SharePoint Document Library

    Table of Contents Background Workaround Applies to See Also Background When you attempt to view a Reporting Services report in a SharePoint document library you see an error message that resembles the following: System.Web.Services.Protocols.SoapException: The target location you specified is...
  • Wiki Page: Reporting Services-specific Help Is Not Available from SharePoint Central Administration Pages

    Table of Contents Background Workaround Applies to See Also Background The Reporting Services Help page is not available from the SharePoint Help window on SharePoint Central Administration pages. Workaround Choose Site Settings . In Site Collection Administration , select Help Settings...
  • Wiki Page: SSRS Troubleshooting: Model Item Permissions Need to Be Updated

    Background: Reports based on report models will fail with errors indicating there are insufficient permissions to view the data source. Workaround: Open the right-click menu of the model and select the Manage Model Item Security properties page. Update the assigned permissions to an...
  • Wiki Page: SharePoint 2010: (SSRS) You Cannot Access Your Web Applications by Using the Server's IP Address

    Table of Contents Background: Workaround: Applies to: See Also Background: URLs that use the SharePoint server's IP address instead of the server's computer name may result in a "404 Not Found" error. Workaround: Add the IP address of the computer as a new internal...
  • Wiki Page: SharePoint 2013: How to Configure SQL Server Reporting Services 2012

    Today I want to highlight the following subject: “ SQL Server Reporting Services ”. The procedures in this topic guide you through a single server installation of a Reporting Services report server in SharePoint mode. The steps include running the SQL Server installation wizard as well as additional...
  • Wiki Page: Configure Power View (Reporting service Features) on Existing SharePoint 2013 Farm with BI Features

    Configuration Summary Install SQL Server 2012 SP1 CTP3 Uninstall Report Services - Native If you have installed it Install Reporting Services – SharePoint & Reporting Services Add-In for SharePoint Product Install Analysis Services In Tabular Mode and Data Tools Install SharePoint Reporting...
  • Wiki Page: Tutorial: Configure Tabular Model Reporting Properties for Power View

    Table of Contents Overview Prerequisites Model Properties that Affect Reporting Hide Tables from Client Tools To hide the Product Category and Product Subcategory tables Create New Data for Charts To create new data for charts Default Field Set To set Default Field Set for tables Table Behavior To set...
  • Wiki Page: Reporting Services Samples on CodePlex (SQL Server Reporting Services SSRS)

    Table of Contents Troubleshooting AdventureWorks sample reports Embedded Reporting The CodePlex home page for all SQL Server Reporting Services (SSRS) samples is SQL Server Reporting Services Product Samples . All of the samples are in one download package. If you are interested only in the...
  • Wiki Page: SSRS: Resources for Help and Support

    The following are some of the resources and options available for getting help with SQL Server Reporting Services: Microsoft SQL Server Connect : Report issues and request future features to Microsoft. Troubleshooting (Reporting Services) : Topics found on TechNet Troubleshooting...
  • Wiki Page: Report Builder Appears to Hang When Connecting to a SharePoint Server (RB3)

    Background: When you perform actions in Report Builder 3.0 which require browsing to a SharePoint server, it may appear Report Builder is hung on the browse action. For example, when browsing to the SharePoint server for a shared Data Source, the Select Data Source dialog displays "Loading...
  • Wiki Page: SSRS Troubleshooting: Existing Sites and Subscriptions Fail After You Upgrade SharePoint Products and Convert to Claims Authentication

    Table of Contents Background: Error accessing Reporting Services pages in SharePoint Workaround: Existing subscriptions fail Workaround: See Also Background: Following the upgrade of a SharePoint environment to SharePoint 2010 Products and the conversion to Claims Authentication, several...
  • Wiki Page: You Are Not Able to Run Reports Following the Creation of a New Web Application

    Table of Contents Background: Workaround: Applies to: See Also Background: After you create a new Web application in your site collection, the Reporting Services service is not able to access all the databases that it must communicate with. You are not able to run reports from a document library...
  • Wiki Page: SSRS Troubleshooting: You Cannot Access Your Report Server Page After Converting to Claims Authentication

    Table of Contents Background: Workaround: Applies to: See Also Background: When you try to browse to http://<RS server>/ReportServer you will see an error message that resembles the following: “The specified user <Domain>\<User Name> could not be found." ...
  • Wiki Page: SSRS Troubleshooting: You Are Not Able to Install the Reporting Services Add-in for Microsoft SharePoint

    Table of Contents Background: Firewall configuration Workaround: Insufficient permissions to install Workaround: Applies to: See Also Background: Installation of the Reporting Services Add-in for Microsoft SharePoint fails and you see an error message that resembles the following: 2009-11...
  • Wiki Page: SSRS Troubleshooting: You Are Not Able to Grant Database Access in SharePoint Central Administration

    Table of Contents Background: Workaround: Applies to: See Also Background: On the Reporting Services integration page in SharePoint Central Administration you see an error message indicating the grant database access step failed. This issue occurs when SharePoint Central Administration and...
  • Wiki Page: SharePoint Central Administration Page Displays a Failed Status After Upgrade

    Background: Following the upgrade of an existing SharePoint farm, the SharePoint Central Administration Upgrade Status page shows a Failed status. The status page contains the name and location of the SharePoint upgrade log file that you can view for more information. The SharePoint upgrade log...
  • Wiki Page: SQL Server 2008 Reporting Services – Localizing Reports

    Table of Contents Requirements Required Knowledge Create Report Server Project Create Class Library Project Create Class “Localized Value” Add Resources Implement Private Method “GetResourcePath” Implement Private Method “GetLocalizedResourceResult” AssemblyInfo.cs Modificaiton Post-Build Events Reporting...
  • Wiki Page: SharePoint 2010: Best Practice Troubleshooting an SSRS Report That Times Out

    What to do when an SSRS report times out? This sort of problem can be really hard to troubleshoot, but here's what you can try: First of all, check how the sql query performs . If it's running slow, than the problem is query related instead of SSRS report related and you'll need to work...
  • Wiki Page: SQL Server 2012 Reporting Services Setup Considerations

    Buy SQL Server Reporting Services and Related Software Review Pricing and Licensing http://www.microsoft.com/sqlserver/en/us/get-sql-server/how-to-buy.aspx Decide edition - Review supported features and decide whether it fits requirements http://msdn.microsoft.com/en-us/library/cc645993.aspx#Reporting...
Page 1 of 3 (58 items) 123
Can't find it? Write it!