Tags » Reporting Services

Pause, Resume and Run a Reporting Services SharePoint Shared Schedule

I’ve recently re-entered the world of SharePoint Reporting Services integration and needed a way to run a shared schedule from a SQL job.

The scenario is this – We have a job that runs in the morning to populate the data warehouse, after the data warehouse it populates the cubes. 342 more words


Retrieving and using Reporting Services Render Extensions

Recently, I was required to provide emailed copies of reports with the ability to choose how the reports are rendered. The reports are all created in Reporting Services, and the emailing was already done, but only for the PDF format. 224 more words


Building Microsoft BI system. Part 6: BI portal with SharePoint

In the previous part we saw how to deliver data to end users through SSRS ad-hoc reports or allows them to query and analyse a cube with Excel. 768 more words

NBA Analytics Project

TFS Reports–Unleash them with PowerPivot

A long time ago I wrote a blog series about writing Custom Reports for Team Foundation Server. As you may or may not know, Team Foundation Server comes with a powerful reporting solution. 1,247 more words


SSRS : Change Subscription Email Subject Value Using Query

Hi !

One day my boss ask me to update email subjects of all reports in SSRS. The goal was to unify email subjects across all reports in reporting services. 177 more words

Business Intelligence

Automating LBI Reporting Services rights

Lawson Business Intelligence (LBI) Reporting Services (RS) offers a lot of great functionality through the concept of “rights”. Rights allow you to do bursting and variable prompts within Crystal Reports. 815 more words


Integrating Lync 2013 Monitoring Data and Excel using Power Pivot

In 2012, Ilse Van Criekinge published a great article onĀ Extending your Lync monitoring data using PowerPivot and Power View. This article included a built-in Excel file that integrated into the Lync Monitoring Data database and allowed you to use Excel Power Pivot to look in into a few reporting examples made by IIse. 867 more words