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
Posted by: Dan Stopher on February 5, 2013
I frequently get asked –“Is there some way I can upload multiple documents to a SharePoint site in the same way that I can move files around on a file server”. In asking this users are typically looking for a way to place documents in different folders on the site quickly. The good news is
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
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
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
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
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
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
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
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).\
Comments Off on Removing Unwanted HTML Contents from SQL Server Reporting Services (SRS) Reports
