Notes to myself on troubleshooting issues with SSRS. Error: Report render failure. Error: An error has occurred during report processing. (rsProcessingAborted) This is probably a security issue. Useful article: Microsoft Dynamics CRM 2011: Reports created by report wizard may fail when executing List SPNs associated with a server: setspn –L <servername> SQL […]
Continue readingLet’s say I have a report of my CRM leads that looks like this: Very simple, just name, created on date, and their email address. The only problem is that I could really care less what time they were created, I just need the date. Here’s how you fix that issue: Export the report The […]
Continue readingOne of my local customers recently moved from Small Business Server 2003 to Small Business Server 2008. Among other things, this required a move from SQL Server 2005 to SQL Server 2008 as well. The movement of the databases went pretty much without issue, but we ran into some strange behavior with some of the […]
Continue readingThe final installment in this series contains miscellaneous SQL functions. You may wish to review the following articles before proceeding: CRM 4.0’s Built-in SQL Functions (Part 1 of 5) CRM 4.0’s Built-in SQL Functions (Part 2 of 5) CRM 4.0’s Built-in SQL Functions (Part 3 of 5) CRM 4.0’s Built-in SQL Functions (Part 4 of […]
Continue readingIn this section, we’ll cover year-related functions. You may wish to review the following articles before proceeding: CRM 4.0’s Built-in SQL Functions (Part 1 of 5) CRM 4.0’s Built-in SQL Functions (Part 2 of 5) CRM 4.0’s Built-in SQL Functions (Part 3 of 5) dbo.fn_BeginOfLastYear Returns the beginning date and time for last year. […]
Continue readingToday we are continuing on with part three of our series on using CRM 4.0’s built-in SQL functions. You may wish to review the following articles: CRM 4.0’s Built-in SQL Functions (Part 1 of 5) CRM 4.0’s Built-in SQL Functions (Part 2 of 5) Note: The date used in the following example is 2009-08-16. […]
Continue readingAs we continue onto the second article in our set, you may wish to review the previous article: CRM 4.0’s Built-in SQL Functions (Part 1 of 5) Note: The date used in the following example is 2009-08-16. dbo.fn_BeginOfLastWeek Returns the beginning date and time for last week. This function requires a valid datetime […]
Continue readingAs I mentioned in a previous article, CRM 4.0 includes a group of user-defined functions that are commonly used within SQL Reporting Services reports to query CRM data. I first noticed these functions when modifying a report created using the CRM Report Wizard. That got me to thinking that I needed to explore these functions […]
Continue reading