Gina Meronek

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 →

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 →

This is part one of a two part series of SQL Server Reporting Services Subscription Administration. In part one, we’ll review some “care and feeding” basics and review a handy query that allows you to get a better view of how your SSRS subscriptions are behaving. In part two, we’ll look at a report that takes the subscription results query and puts it in a format that allows you to quickly review status, recipients, and parameters.

Continue reading →