Category Archives for "Reporting"

1 Random SSRS Troubleshooting Notes

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 reading

CRM 4.0’s Built-in SQL Functions (Part 5 of 5)

The 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 reading

CRM 4.0’s Built-in SQL Functions (Part 4 of 5)

In 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 reading