How to Change the Date Field Format to DD/MM/YYYY in a SSRS report

Posted By Posted by: EPM Partners on March 25, 2014

Solution: Open the report in the Business Intelligence Development Tool (BIDS)/SQL data tool In the design mode, right click the date textbox and click on properties You have multiple options to do this task. Here are three options for when you select the textbox property dialog box: Option 1 Select the tab ‘Number’ then category ‘Date’ you can then

Read More


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

SQL Function to Display Multi-field Values in a SSRS Report

Posted By Posted by: EPM Partners on February 20, 2014

Background: I recently had a requirement from a client requiring the display of multi-value custom field values in a SSRS report. Technical Information: The RDB includes an association table view for each multi-value custom field that contains values. View names for multi-value custom fields are of the form MSPCFxxx_Custom Field Name_AssociationView, where xxx can be PRJ, RES,

Read More


Blog Posted In Blog Posted In: Project Server
Blog Posted In 

FREE WHITE PAPER: Online and On-Premises Solutions for Project Server 2013.

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

EPM Partners are currently attending the Project Conference 2014 in Anaheim California and have just received a great whitepaper: Online and On-Premises Solutions for Project Server 2013. An analytical comparison of a cloud solution and an on-premises solution. We thought you would enjoy this article: Project_Server_2013_Online_and_On-Premises_Solutions.pdf


Blog Posted In Blog Posted In: Reporting
Blog Posted In 

Unable to View Schedule PDP in Project Server 2013

Posted By Posted by: Peter Williams on January 7, 2014

If you are unable to view the Schedule PDP in Project Server 2013 (using IE11/Windows 7) check that the Project Server web address has been added to the compatibility view setting list in Internet Explorer as per the screen shots below.         Once the website has been added to the Compatibility View,

Read More


Blog Posted In Blog Posted In: Project Server
Blog Posted In 

The Solution to Error ID: 9133 or 26000 – Project Server 2010

Posted By Posted by: EPM Partners on September 3, 2013

Background: When a user updates the project using the PWA, the below error message will be received via email: Your Project Update job failed.  Its current state is failed.  It was 50% complete.  It entered the queue Error ID: 9133 Error ID: 26000 Detailed error below – send it to the administrator for more detailed troubleshooting.

Read More


Blog Posted In Blog Posted In: Project Server
Blog Posted In 

Project Server 2013 Permission Mode

Posted By Posted by: EPM Partners on July 11, 2013

In Project Server 2013 Microsoft has introduced a new permissions Mode. This mode has been introduced to try and help simplify the management approach of permissions. Many people who haven’t dealt with the project server’s permissions matrix before struggled to understand this design. Microsoft have provided an out of the box permissions mode that masks

Read More


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

Earned Value Demystified

Posted By Posted by: Laith Adel on May 16, 2013

What is Earned Value Analysis? žEV is KPIs that measure the Cost and Schedule performance of a project., žIt’s like (green, orange and red) but better. ž Here is the main blocks of the EV calculations: So What? Earned value indicators that are variances or ratios can help you determine if there is enough money left

Read More


Blog Posted In Blog Posted In: Project Server, Reporting
Blog Posted In Comments Off on Earned Value Demystified

Issue: No Prompt for Document Check In Option in the Project Documents List

Posted By Posted by: EPM Partners on March 27, 2013

Issue: Users don’t get prompted to Check In a document after closing the document and saving changes to a sharepoint document library. Reason: By Default, Checked OUT option is disabled in the Project Document Library settings:) Objective: To enable the Checked Out option in the Project Document list so the user will be prompted to

Read More


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

Removing Corrupted Web Parts from a Project Site/Project Server Web Part Page

Posted By Posted by: EPM Partners on February 27, 2013

Issue: Project Site home page displays Closed/Corrupted WebPart on the page after saving as a Project Site Template. Cause: Web part corruption or closed web parts which have not been deleted on the page. Solution: To fix, you need to follow these steps: 1. Click on Site Actions then Site Settings. 2. Click on Site and

Read More


Blog Posted In 

Renaming Fields on PDPs

Posted By Posted by: EPM Partners on February 4, 2013

Problem Need to change the default project field “Owner” to another custom name such as “Project Manager” Solution Notes This is a little bit of a hack to rename the “Owner” field on the page it is displayed in without changing internally on the back end. The solution only updates the text displayed on the

Read More


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