Query for getting lookup table in Row Number order

For your reporting needs, you may want to display values from a Lookup Table exactly in the order they are saved in PWA.

 

Within PWA, this setting is controlled using “Display order for lookup table” option on Edit Lookup Table Page.

 

 

However, this sort order is not available in Reporting Database. Following query uses Published (and reporting) schema to get this information. This is tested on Project Server 2013 on premises.

... Read more »

Project Online – SSIS OData Replication – Lessons Learned

I recently got a chance to work on an SSIS Package in Windows Azure environment which periodically retrieved the Project online data via OData connector and stored over an Azure SQL Database for SSRS based reporting.

 

Here are some of my takeaways from this exercise.

 

... Read more »

Filter SSRS Report on Project Site

[Populate SSRS Report Parameters via JavaScript]

 

Requirement

Display a Project specific data on a Project Site using an SSRS Report.

 

Solution

SSRS Report can be displayed on a SharePoint web part page using Report Viewer Control. The Challenge was to populate the parameter with Project Name so that only that Project specific data gets loaded in SSRS Report.

 

Our familiar hero, JavaScript came to the rescue again, though it took some help from Text Filter Web Part this time. Following are the steps

... Read more »

Solution: Spaces removed when SSRS Report exported to PDF

Me and some of my workmates have come across this issue quite a few times so thought about sharing the solution with everyone.

 

Problem:

When a SQL Server Reporting Services 2005, 2008 or 2008 R2 report gets exported to PDF, the spaces of a Project Server Multiline text fields appear so condensed that it looks like a long line with out any spaces. The same report looks fine on screen and exports with proper spaces to Microsoft Word. This is apparently an SSRS bug. Follow the solution below to fix disappeared spaces problem.

 

... Read more »

Project Server 2013 – Reporting Story

Introduction

Tracking Project / Portfolio Progress and forecasting future performance are the cornerstones of all project management methodologies. While the reporting requirement itself is so common and generic in nature, yet every organization has some specific PM practices which demands unique reporting & that results in anywhere from little to very significant custom reports development in Project Server. Therefore, Microsoft Project Server has always provided reporting tools with rich capabilities not only to create and distribute Traditional or Analytical reports but also to facilitate power users to generate ad-hoc reports based on unplanned requirements.

The latest version of Project Server (i.e. 2013) has introduced some new reporting methods. In addition, reporting possibilities of Microsoft Hosted version of the project Server (i.e. Project Online via office 365) is not exactly same as its on-premise counterpart and hence it is essential to analyse, plan and architect reports according to its deployment scenario.

This article summarises the key reporting capabilities of Project Server 2013 for both on-premise and hosted solutions.

... Read more »