Timephased data

Configure Rollup of Timephased Reporting Data in Project Online

Many organizations need reports that retrieve Tasks and Assignments timephased data. The problem is performance issues, especially in organizations that have a lot of Project Online reporting data. Microsoft acknowledged that not all organizations would need the timephased data to be reported by day. So they introduced an option to roll up the data on Read more about Configure Rollup of Timephased Reporting Data in Project Online[…]

Configuring SSRS 2016 in SharePoint/Project Server 2016

The process of setting up SSRS in SharePoint/Project Server 2016 integrated mode has changed a little bit when compared to earlier versions of SharePoint/Project Server. The process consists of installing SSRS on the SharePoint servers, creating SSRS service application and configuring the Reporting libraries to contain report elements. Installing SSRS 2016 on SharePoint/Project Server 2016 Read more about Configuring SSRS 2016 in SharePoint/Project Server 2016[…]

Create Power App Screen

How To Create PowerApps In SharePoint Online

Introduction Microsoft introduced the PowerApps service back in November 2017. This service allows administrators to build apps that can run on a browser or phone or tablet with no coding knowledge needed.  PowerApps has drag and drop features and Excel like expressions that enables end users to work with data. In this blog, I will Read more about How To Create PowerApps In SharePoint Online[…]

Are you missing Reporting views in Project Server 2016?

Missing traditional SQL Reporting views in Project Server 2016 Project Web App Database? Below are the possible reasons for those missing views and recommendations to resolve them. Reason 1 Did you host multiple PWA site collections in a single Content DB? If yes then Project Server 2016 drops these views if there are multiple PWA site Read more about Are you missing Reporting views in Project Server 2016?[…]

Microsoft Project Conference 2014 Sessions Now Available On Demand

Recorded sessions and PowerPoint presentations from the Microsoft Project Conference 2014, held February 2 – 5, 2014 in Anaheim, California, are now available on Microsoft’s Channel 9 web site. Video recordings can be streamed on demand or downloaded for offline viewing, and the accompanying PowerPoint presentations can be viewed in your web browser or downloaded Read more about Microsoft Project Conference 2014 Sessions Now Available On Demand[…]

Show Start and Finish Dates with Planned and Actual Indicators

If you regularly show ‘Actual Start‘ and ‘Actual Finish‘ dates alongside ‘Start‘ and ‘Finish‘ dates in order to show what has actually happened, here is a display technique that can save you some real estate in a view or report: placing a “P” next to the date to indicate that it is still planned or Read more about Show Start and Finish Dates with Planned and Actual Indicators[…]

Format Date Data for Accounting-Style “Year_Month#” Columns in Your SSRS Reports

So, you have a requirement to create a report on planned or actual cost data by month, by year, and your report requester would prefer that the column headings be formatted accounting-style, such as 2014_01, 2014_02, 2014_03, etc. No Problem! Place the following code into your SQL SELECT and GROUP BY statements, sum your cost Read more about Format Date Data for Accounting-Style “Year_Month#” Columns in Your SSRS Reports[…]

SSRS REPORTS ERROR WHEN LARGE NUMBER OF PARAMETERS ARE PASSED

Today we will be talking about a nasty error message that you may encounter when running certain SSRS reports that have a big list of multi choices parameters or a lot of parameters. That error message will might say something like Operation is not valid due to the current state of the object or in Read more about SSRS REPORTS ERROR WHEN LARGE NUMBER OF PARAMETERS ARE PASSED[…]