Author Archives: Bernado

About Bernado

Based in Australia, I am a freelance SharePoint and Dynamics CRM developer. I love developing innovative solutions that address business and everyday problems. Feel free to contact me if you think I can help you with your SharePoint or CRM implementation.

Retrieving related records in an N:N relationship using QueryExpression in CRM

Posted on April 19, 2014 by Bernado

This post explains how the QueryExpression class can be used in conjunction with IOrganizationService.RetrieveMultiple() in CRM 2013 to retrieve related records for an entity in an N:N relationship. This is something that I could not find much documentation on, and it … Continue reading →

Posted in CRM | 8 Comments

Form notification with timeout in CRM 2013

Posted on April 15, 2014 by Bernado

Form and field notification are new to CRM 2013 and there have already been quite a few posts about these. I was playing around with form notification and wanted to display an Info notification that would automatically go away after … Continue reading →

Posted in CRM | Leave a comment

CRM 2013: Web.config error (HTTP 500.19) after installing .NET Framework 4.5

Posted on April 9, 2014 by Bernado

I had a vanilla installation of CRM 2013 running smoothly on Windows Server 2008 R2. I installed Visual Studio 2013, which adds .NET Framework 4.5. I then started getting the error below when browsing to CRM: HTTP Error 500.19 – Internal … Continue reading →

Posted in CRM | Leave a comment

How to update SharePoint web.config for ASP.NET ReportViewer control

Posted on January 31, 2014 by Bernado

If you have been trying to use the ASP.NET ReportViewer control in your SharePoint project then you may have found that you need to make several changes to the web.config, including: Remove the existing ReportViewerMessages appSettings Remove the existing ReportViewerWebControl handler Add … Continue reading →

Posted in Report Viewer, SharePoint | Leave a comment

How to add links with query string to Quick Links/Current Navigation using code

Posted on January 9, 2014 by Bernado

In SharePoint 2010 you will find that you can add links with query string to Quick Links (aka Current Navigation) using the UI without any issue. If you enter something like http://mySite/pages/myPage.aspx?key=abc into the dialog, then it’d happily accept it. … Continue reading →

Posted in SharePoint | 1 Comment

Connecting to SQL from SharePoint with claims based authentication and integrated security

Posted on December 17, 2013 by Bernado

Recently I had to retrieve data from SQL Server and display in a SharePoint portal. Data security trimming was implemented in SQL, which means I needed to connect to SQL using the current user’s identity. ASP.NET impersonation is enabled by … Continue reading →

Posted in Claim Authentication, SharePoint | Leave a comment

Cannot add new item to term set even when term set is opened

Posted on November 27, 2013 by Bernado

A business user reported that the Add New Item link on the managed metadata term picker has disappeared. Easy one I thought, the term set needs to be set to Opened. I did just that, but the user still cannot … Continue reading →

Posted in Managed Metadata, SharePoint | 1 Comment

How to debug OOTB minified JavaScript in SharePoint

Posted on November 15, 2013 by Bernado

When time gets desperate you may need to debug into SharePoint’s OOTB JavaScript to work out a particular problem. The challenge here is that the OOTB JavaScript are minified, which makes debugging almost impossible. This post describes three approaches you … Continue reading →

Posted in JavaScript, SharePoint | Leave a comment

Cannot login with FBA and AD LDS: The security token username and password could not be validated

Posted on July 23, 2013 by Bernado

I configured FBA and AD LDS in SharePoint 2010 and was able to grant permissions to AD LDS users in SharePoint. I however could not login with these users. The ULS shows multiple errors similar to below: An exception occurred … Continue reading →

Posted in AD LDS, Form Based Authentication, SharePoint | 1 Comment

Choosing between InfoPath Form Library and InfoPath List Form

Posted on July 15, 2013 by Bernado

Recently I had to decide between InfoPath Form Library and InfoPath List Form. We first ventured down the Form Library path, but due to certain issues, we ended up re-doing the solution using List Form. This post summarises the issues … Continue reading →

Posted in InfoPath, SharePoint | 4 Comments