Category Archives: SSRS

Migrating from Native to Integrated Mode SSRS Part 5: Testing, Subscriptions, & Implementation

***Update October 2014: Microsoft has put greater emphasis on Power BI and SharePoint online in the past year, and the future of on-premises SharePoint SSRS is uncertain. Microsoft may instead find a way to connect Power BI to native mode SSRS. At this time,  I’d caution teams with an eye to future Microsoft BI against undertaking a migration from native mode  to on-premises SharePoint online. This is just my opinion, not the opinion of Microsoft or my employer, but a project of this magnitude must be very carefully planned and risks weighed against the benefits.***


 

Huzzah, the reports are in SharePoint! Time to take a bow and exit stage left, right?

Not so fast! Have you tested them properly? Are your subscriptions configured in their new home? And what about the users – how do you get them rolling with SSRS in SharePoint? Read on to find out!

Continue reading

Migrating from Native to Integrated Mode SSRS Part 4: Migrating Reports to SharePoint

At long last, it’s time to get your reports in SharePoint! Here comes the manual labor, otherwise known as the “I know I won’t be short on stuff to do today” section.

Here’s an overview of the main migration steps:

  1. Create the necessary shared data sources for the report on the SharePoint site reports library
    1. If you’re using ODBC connections, don’t forget to set up the DSN’s on your SharePoint servers!
  2. Open a copy of the existing report in Report Builder or SSDT
  3. Edit the report data source(s) to point to the applicable SharePoint data source
  4. Save the report to the SharePoint reports library
  5. Edit the report’s properties and apply the correct Report Category and any other metadata being tracked

Continue reading

Migrating from Native to Integrated Mode SSRS Part 3: Installation & Configuration

By this point in the process, you should have a sense from Part 2 of what your native mode instance has in terms of reports, subscriptions, and data sources. Now it’s time to get your hands dirty and configure some servers! I’ll point you to some good references to get you started, then review what we learned about configuring a reports library that you won’t find on TechNet.

Instance Installation & Configuration References
Configuring a Reports Library
Configuring the Default View
Library Security
Gotchas

Continue reading

Migrating from Native to Integrated Mode SSRS Part 2: Essentials for Your Toolbox

Once you’ve made the decision to migrate from native mode to integrated mode, you need ways to assess what you’re up against. You need to know the current state of your native mode instance, and what that means for your migration, mainly:

Continue reading

Migrating from Native to Integrated Mode SSRS Part 1: Setting the Stage

***Update October 2014: Microsoft has put greater emphasis on Power BI and SharePoint online in the past year, and the future of on-premises SharePoint SSRS is uncertain. Microsoft may instead find a way to connect Power BI to native mode SSRS. At this time,  I’d caution teams with an eye to future Microsoft BI against undertaking a migration from native mode  to on-premises SharePoint online. This is just my opinion, not the opinion of Microsoft or my employer, but a project of this magnitude must be very carefully planned and risks weighed against the benefits.***


 

As someone who has worked with SQL Server Reporting Services for a number of years, the bulk of my experience is with “native mode” installations. Reports are accessed via Report Manager or custom developed .NET UI’s, and SSRS is a free-standing entity administered by someone in a DBA and/or BI role. However, if you wish to get access to the newest and best BI goodies from Microsoft, SSRS running in SharePoint Integrated mode is the direction you must go. The goal of this blog series is to share the lessons and techniques I’ve learned over the past months of migrating reports from a native mode to an integrated mode environment.

Continue reading

URL Access to SSRS Integrated Mode Reports

We’ve got an active project at work to migrate our many (many!) SSRS reports from a 2012 native mode instance to a 2012 instance integrated into SharePoint 2010. There are a number of benefits to migrating to SharePoint, which I’ll cover in a future post, but there are also functions we need to replicate from native mode. Several of our reports get displayed on LCD screens around a development team’s area so they can track sprint burndown rates and progress towards software upgrade goals. These reports are displayed via SSRS URL Access, which allows us to render the report in its own window and with certain parameter and display configurations. David Peterson and I found that the configuration between native and integrated mode wasn’t necessarily a 1:1 swap, but our suffering is your gain, as you now get to cheat off our homework.

Continue reading

SSRS Subscription Administration – Part 2

Subscriptions Report

We have some query results courtesy of the query we looked at in Part 1, but some of those columns aren’t in the most readable or presentable format. Enter an SSRS report built via Report Builder/BIDS/SSDT.  I’m going to assume that if you’re an SSRS admin, you know your way around building a basic SSRS report, so we’ll keep these instructions high level.

Continue reading