How to convert an Excel formula from SSRS report

Posted By Posted by: Ahmed Taee on October 25, 2016

In your report, create a field that will be a formula field when the report is exported to Excel. In the example below, the cell underneath Results column header will be the summation of First Value plus Second Value.   The expression content will be “=C3+D3”   Run the report and export it to Excel   To convert

Read More


Blog Posted In Blog Posted In: Blog, How to, Reporting, Uncategorized
Blog Posted In 

POWER BI – Connecting to an On-Premise SQL Server Database

Posted By Posted by: Peter Williams on July 5, 2016

NOTES: A POWER BI PRO licence is required to connect to On-Premise Data. For details, please refer to https://powerbi.microsoft.com/en-us/documentation/powerbi-power-bi-pro-content-what-is-it/ For security related questions, refer to the Power BI whitepaper http://download.microsoft.com/download/4/8/C/48CFCF8A-2025-4B97-B249-7B505E26E7ED/Power%20BI%20Security%20Whitepaper.docx   Installing Data Management Gateway on computer on the same network as the SQL Server I have logged into the server I wish to install

Read More


Blog Posted In Blog Posted In: Blog, How to
Blog Posted In 

Error and Solution: The INSERT statement conflicted with the FOREIGN KEY constraint

Posted By Posted by: Peter Williams on April 13, 2015

We recently received an issue where our client was unable to see a project in their Project Status Report. They had tried publishing the project and received a “Failed But Not Blocking Correlation”. The error below was found in the project server queue: ReportingProjectChangeMessageFailed (24006) – The INSERT statement conflicted with the FOREIGN KEY constraint “FK_MSP_EpmAssignmentByDay_ProjectUID_AssignmentUID”.

Read More


Blog Posted In 

An Error has Occurred During Report Processing

Posted By Posted by: EPM Partners on May 21, 2014

Environment: Project Server 2010, Report Server in Native Mode Background: A report throws the below error message when it runs in the Report Manager. Refer to the Snapshot below: Solution: The cause of the issue is that the password is incorrect or expired for the report reader account. (‘DomainName\svc_aumhd_bas02_) configured in the report data source. For example,

Read More


Blog Posted In Blog Posted In: How to, Project Server
Blog Posted In 

Error: Could not Allocate Space for Object ‘dbo.MSP_PROJECTS’

Posted By Posted by: EPM Partners on April 9, 2014

Environment: Project Server 2010 Background: New Project failed to publish. Error Details: <Error><Class>2</Class><LineNumber>9</LineNumber><Number>1105</Number> <Procedure>MSP_PUBLISH_PROJECTS_INSERT</Procedure>  <Message>  System.Data.SqlClient.SqlError: Could not allocate space for object ‘dbo.MSP_PROJECTS’.’UQ_MSP_PROJECTS_PROJ_UID’ in database ‘Prod_ProjectServer_Published’ because the ‘PRIMARY’ filegroup is full. Create disk space by deleting unneeded files, dropping objects in the … 590d3019-a6a5-426a-83ff-85188bf2a3ca. The cause of the issue is  a published database had either reached

Read More


Blog Posted In Blog Posted In: How to, Project Server
Blog Posted In 

EPM Partners’ 2014 Webinar Series

Posted By Posted by: Laith Adel on February 16, 2014

EPM Partners’ Centre of Excellence is a series of webinars about knowledge, best practices and challenges around Microsoft Project Server-based management solutions. The Centre of Excellence is about real life situations and challenges. Rather than demonstrating product features and functions, it is a presentation from experts and leaders in the field, and where appropriate, will reference real-life

Read More


Blog Posted In Blog Posted In: Reporting
Blog Posted In 

Seven Steps to Correct The Error: “The Root of the Certificate Chain is not a Trusted Root Authority” in SharePoint and Project Server Workflows 2013

Posted By Posted by: EPM Partners on December 18, 2013

I was recently completing an installation of Workflow for Project Server and I received the following error: “The root of the certificate chain is not a trusted root authority” During this installation I received the error at two different points.The first whilst running the Register-SPWorkflowService command, however I could by-pass this by utilize the –force. This

Read More


Blog Posted In 

Project Server 2013 and Using Reserved Fields

Posted By Posted by: EPM Partners on October 16, 2013

I recently encountered an interesting issue that I thought would be valuable to share and it could quiet easily occur for anyone. I provisioned a Project Server 2013 instance and created many Enterprise Custom fields. One of interest that I created was called Description. Once the environment was configured I decided I wanted to create

Read More


Blog Posted In 

Making Branding and Images Unified for Non Developers

Posted By Posted by: EPM Partners on August 29, 2013

We’ve all had the pain of trying to make images, text and different items in web parts alight to ensure multiple different pages provide a unified display of branding or information. Sometimes if you try to complete this manually via the user interface it can be time-consuming or impossible to replicate exactly. Recently I designed

Read More


Blog Posted In