THE week+

Some weeks are better than others, but I just wrapped up what has to be the most fun I have had while working in one week!

Sunday - great doubles match against some old and new friends (in 101F heat)
Monday - not the best doubles play, but tennis nonetheless
Tuesday - swim meet where Annie had a Gold time in backstroke
Wednesday - the 4th of July started with wakeboarding on the James, a win at the GRSA regatta and a fun evening waiting for the fireworks
Thursday - more tennis with Aaron!
Friday - Wakeboard and waterskiing, then on to Friday Cheers!
Saturday - Watched Wimbledon women's final, planted flowers and had a great dinner and slip/slide with friends
Sunday - Shopping in Williamsburg and then on to Kingsmill
Monday - Terrific breakfast and spent the day at the beach, with a nice lunch at the new marina.  Finished up the day with 9 holes at the Independence short course and dinner at Wild Ginger.

It truly was THE week!

Refresh SQL Management Studio query window intellisense cache

I have been using OneNote instead of blogging to capture quick lessons learned, but I just realized that this tip didn't end up in either place, so I'm going to go back to the tried and true...blogging

Best trick for Dynamics CRM Report writers: CTRL + SHIFT + R to refresh SQL Server Management Studio query window's local intellisense cache:

http://blogs.msdn.com/b/dtjones/archive/2008/09/11/refreshing-the-intellisense-cache.aspx 

CRM 2011 Reports SSRS Error SetExecutionCredentials

If you are getting the error below running Reports, not to worry. Generally this is an easy fix. Find out what account Reporting Services is running under and add it to the Active Directory group PrivReportingGroup. If SRS is running as a LocalService or NetworkService (local accounts), you will need to add the SRS computer object to the AD group. After doing that, just restart the Reporting Services windows service and you should be good to go! Exception information: Exception type: CrmReportingException Exception message: An error occurred during report rendering. at Microsoft.Crm.Web.Reporting.SrsReportViewer.SetExecutionCredentials(ServerReport reportObj) at Microsoft.Crm.Web.Reporting.RemoteSrsReportViewer.LoadReportAndSetParameters() at Microsoft.Crm.Application.Controls.AppUIPage.OnPreRender(EventArgs e) at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) An error has occurred during report processing. (rsProcessingAborted) at Microsoft.Reporting.WebForms.ServerReportSoapProxy.OnSoapException(SoapException e) at Microsoft.Reporting.WebForms.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection.ProxyMethodInvocation.Execute[TReturn](RSExecutionConnection connection, ProxyMethod`1 initialMethod, ProxyMethod`1 retryMethod) at Microsoft.Reporting.WebForms.ServerReport.SetDataSourceCredentials(IEnumerable`1 credentials) at Microsoft.Crm.Web.Reporting.SrsReportViewer.SetExecutionCredentials(ServerReport reportObj) Cannot create a connection to data source 'CRM'. (rsErrorOpeningConnection)