Financial Quarters in SSRS

Use case to determine Qtr based on month datepart

This example uses Invoice created on date and has a Fiscal year of 1st Oct

SELECT CASE WHEN (DATEPART(mm, FilteredInvoice.createdon) > 9)
THEN 1 WHEN (DATEPART(mm, FilteredInvoice.createdon) < 4) THEN 2 WHEN (DATEPART(mm, FilteredInvoice.createdon) < 7)
THEN 3 WHEN (DATEPART(mm, FilteredInvoice.createdon) < 10) THEN 4 END AS Qtr
FROM FilteredInvoice

How to trigger system form functions from ISV buttons

• open up the form in question
• hit F12 to open IE Developer Tools
• Find button in question
• Find the function name
• Export ISV.config
• Within relevant entity add a new button and paste function into Javascript tag
  
• See below code to create an associated record from ISV of parent form
• (in this case it's a custom entity called Site Survey Request from Opportunity entity)

{Entity name="opportunity"}
{ToolBar ValidForCreate="0" ValidForUpdate="1"}
{Button JavaScript="locAddRelatedToNonForm(10045,3,crmForm.ObjectId, '')" ValidForCreate="0" ValidForUpdate="1"}
{Titles}
{Title LCID="1033" Text="Request Site Survey" /}
{/Titles}
{/Button}
{/ToolBar}
{/Entity}

Recursive Workflows in Dynamics CRM

http://www.dynamicscrmtrickbag.com/2010/06/02/recursive-workflows/

Useful Dynamics CRM Form Scripts #2

http://www.dynamicscrmtrickbag.com/2010/06/03/useful-form-scripts-2/

Update Rollup 11 for Microsoft Dynamics CRM 4.0

http://support.microsoft.com/kb/981328

Microsoft Business Intelligence

http://www.microsoft.com/events/series/bi.aspx?tab=overview

International friendly SSRS format code formatting

Number:
N0

Currency:
C0

Percentage:
P0

Note: 0 refers to precision

ASP.NET 2.0 FileUpload Control

http://www.c-sharpcorner.com/uploadfile/mahesh/fileupload10092005172118pm/fileupload.aspx?articleid=79850d6d-0e91-4d7b-9e27-a64a09b0ee6b

Reading a Delimited File Using ASP.Net

http://www.devarticles.com/c/a/ASP.NET/Reading-a-Delimited-File-Using-ASP.Net-and-VB.Net/1/

Building a Simple CSV Parser in C#

http://www.switchonthecode.com/tutorials/building-a-simple-csv-parser-in-csharp

5 ways to import data

http://www.microsoft.com/dynamics/crm/using/configure/chooseimport.mspx

Tool to Update MSCRM 4.0 data inline and Export to CSV for Re-import

http://mscrmimport.codeplex.com/

RecordCounter.zip

http://cid-f63e4bcd4a7f64a4.skydrive.live.com/self.aspx/BlogFiles/RecordCounter.zip

Record Counter For Microsoft Dynamics CRM 4.0

http://blogs.msdn.com/crm/archive/2010/04/05/record-counter-for-microsoft-dynamics-crm-4-0.aspx

CRM Plugin Registration Tool

http://code.msdn.microsoft.com/crmplugin/Release/ProjectReleases.aspx?ReleaseId=2010

Populate CRM Fields from Parent Window

http://dmcrm.blogspot.com/2010/03/populate-crm-fields-from-parent-window.html

Read only fields

unsupported:

crmForm.all.fieldname.readOnly = true;

Managing the MSCRM Asynchronous Service

http://dmcrm.blogspot.com/2010/05/managing-mscrm-asynchronous-service.html

CRM 4 and Outlook 2010

http://bovoweb.blogspot.com/2009/10/ms-outlook-2010-and-dynamics-crm.html

Metadata Browser

http://blogs.msdn.com/crm/archive/2007/02/21/metadata-browser.aspx