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 

Getting the Most of SharePoint’s Datasheet View

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

SharePoint lists offer users access to some great features by tracking list items such as Risks and Issues as individual items. Features such as version control, workflow approvals and read write access to multiple list items  – at the same time by different users – are only possible due to each item being a separate

Read More


Blog Posted In Blog Posted In: SharePoint
Blog Posted In 

Bulk Checking in Checked Out Documents

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

If you have read my previous blog on using the Explorer view to upload multiple documents, you have now likely experienced the following scenario. You have just uploaded a number of projects that you can clearly see are on the site, but no one else can see them when they browse to the site. The

Read More


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

Using SharePoint PDF document workflow approvals

Posted By Posted by: Dan Stopher on November 27, 2012

The default workflow settings allows users of Outlook 2010 to approve an approval task from within the body of an email by clicking on the “Open this task” icon from the Outlook email ribbon. Users of other mail clients are not presented with this option. In the case where a word document has been sent

Read More


Blog Posted In Blog Posted In: SharePoint
Blog Posted In 

Default Way of Opening Excel from Web

Posted By Posted by: EPM Partners on February 3, 2012

If you upload excel 2010 workbooks into Pwa, say the Shared Documents folder, select the name of the document to open, it defaults to opening it in Excel web viewer. From here you can open the workbook in excel for further editing and viewing. Fine.   So now you would like to link to these

Read More


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