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 

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 

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 

How to Concatenate Two Column Values in a CSV File

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

#Import the CSV file in the Variable and Select the column names that you want to be displayed into #updated CSV file $CSV = import-csv “D:\CSV File\Temp.csv” | select Surname,Given_Names,Email_Address,Employee_ID,Employee_Number,User_Name,Position_Title, @{n=’ResourceName’;e={$_.Surname + ” ” + $_.Given_Names}} # script @{n=’ResourceName’;e={$_.Surname + ” ” + $_.Given_Names}} will create the new #column Resource name and concatenate the Surname

Read More


Blog Posted In Blog Posted In: How to
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 

How to Insert a Sequential Unique Integer ID Value in a CSV File Using PowerShell

Posted By Posted by: EPM Partners on May 30, 2013

#Import the CSV file data into Variable and add the blank new ID column $CSV = import-csv “D:\Temp File\Temp.csv” | select Employee_ID, @{Name=”Id”;Expression={$_.””}} # so we start from ID = 1 in the CSV file $x=1; # this will loop each row in CSV and insert the incremental unique ID value FOREACH($ReadData in $CSV) {$ReadData.Id=$x;$x++}

Read More


Blog Posted In Blog Posted In: How to
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

Query Risks & Issues from Content Database

Posted By Posted by: EPM Partners on May 2, 2013

Sometimes you need to be able to query custom fields from the default risks and issues list using SQL queries and apply conditions/filters. Risks from Content DB SELECT     REPLACE(w.FullUrl, ‘PWA/’, ”) AS ProjectName, d.nvarchar3 AS CurrentStatus, d.nvarchar8 AS Priority, d.nvarchar6 AS IssueType, d.nvarchar7 AS Severity,                       d.nvarchar9 AS IssueName, d.ntext2 AS ActionUpdateDiary, d.ntext3 AS FinalResolution,

Read More


Blog Posted In Blog Posted In: How to, Reporting
Blog Posted In Comments Off on Query Risks & Issues from Content Database

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 

Sum Values Returned From LookupSet Function

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

The LookUpSet function returns objects or array of objects. Cannot use the default SUM function to sum the values returned. The following VB script needs to be added as a function in the report (Report > Report Properties > Code) Public Function SumLookup(ByVal items As Object()) As Decimal Dim suma As Decimal = 0 For

Read More


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