The Datasheet View Cannot be Displayed

Posted By Posted by: Dan Stopher on February 19, 2013

In my previous blog Getting the Most of SharePoint’s Datasheet View I highlighted the functions the DataSheet view in SharePoint provides to a user trying to update list items quickly including by using Fill Handle we have come to love from Excel. However there are a couple of common reasons that stop a user from

Read More


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

Display Percentage Values on Labels of SSRS Charts

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

By default an SSRS chart does not display a label on the chart. In order to display them, right click on the actual chart and enable “Show Data Labels”. The problem is how do we display a numeric value as a percentage to the total values? Firstly, select the label and go to the Label

Read More


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

SSRS Report – Repeating Tablix Headers

Posted By Posted by: EPM Partners on November 29, 2012

Problem: Created a tablix in a SSRS report and header row of the tablix not repeating on each page of the report even after checking “Repeat header columns on each page“. Solution: Enable Advanced Mode in the Groupings pane by clicking the down arrow to the right of Column Groups and select Advanced Mode Enabling advanced

Read More


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

Repairing a Corrupt Project

Posted By Posted by: EPM Partners on November 28, 2012

Problem: A project has been corrupted Solution 1 – Ensure your using the latest version of MS Project 2010 Ensure you are using the latest version of MS Project 2010 (at least 14.0.6112.5000) – MS Project 2010 > File > Help Republish the project using MS Project 2010 Solution 2 – Use the Save for Sharing Feature Repair

Read More


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

License Management in 2013

Posted By Posted by: EPM Partners on November 23, 2012

One of the few questions that I have regularly been asked by just about every customer I have ever worked with is about licensing. Unfortunately I don’t have an MS Degree in the topic, as these days it seems you need to have one! It’s far too easy to get conflicting advise as to how and what features can

Read More


Blog Posted In Blog Posted In: SharePoint
Blog Posted In 

Adding VB Scripts Inside SSRS Reports

Posted By Posted by: EPM Partners on November 12, 2012

Problem: Converting a comma separated string outputted from a multi select parameter into an array of strings to be used in SSRS report expressions. Solution: You can store custom VB code in an SSRS report and this functionality can be used to include a variety of custom built functions but in this case it will be used to convert a

Read More


Blog Posted In Blog Posted In: Reporting
Blog Posted In 

SharePoint List Parent/Child Relationship – E.g. Creating List B items from List A

Posted By Posted by: EPM Partners on January 16, 2012

SharePoint List Parent/Child Relationship – E.g. Creating List B items from List A Problem The best solution to be able to efficiently create 1 or more linked child list items from a parent list. Solution 1 The blog below outlines how to achieve the above using workflows – (See link below). http://ppm.griff-in.net/2011/10/creating-actions-from-issues-and-risks.html E.g. A user

Read More


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

Error in MS Project: ‘The value you entered does not exist in the lookup table of this code. All values must be predefined in the code lookup table. Contact your server administrator to get new values

Posted By Posted by: EPM Partners on June 29, 2011

  The following error can appear in MS Project. In my case it was when I was attempting to insert sub projects into a Master Schedule. It may also appear in regards to modifying resource custom fields such as the RBS. Cause: It seems that MS Project is unable to handle custom lookup fields that

Read More


Blog Posted In 

Removing Unwanted HTML Contents from SQL Server Reporting Services (SRS) Reports

Posted By Posted by: EPM Partners on June 20, 2011

When using SRS to deliver reports derived from data entered through multiline text fields, SRS frequently returns non alphabetic characters like those returned below: The following VB function removes unwanted HTML content from data retrieved from the Project Server Reporting database that is managed originally within a multiple-Line field on a Project Detail Page (PDP).\

Read More


Blog Posted In Blog Posted In: Reporting
Blog Posted In Comments Off on Removing Unwanted HTML Contents from SQL Server Reporting Services (SRS) Reports