I have already wrote similar article using SSIS 2008. Following article describes how to use the same functionality using new version of SSIS.
Tuesday, November 13, 2012
Friday, November 09, 2012
I believe every person who developed complex reports for CRM used T-SQL Union operation to display different types of records at the same table.
In T-SQL I used following T-SQL Query to get results:
Select AccountId RecordId ,Name RecordName ,'account' RecordTypeName From FilteredAccount Union Select ContactId RecordId ,FullName RecordName ,'contact' RecordTypeName From FilteredContact
When CRM 2011 was released we got possibility to create reports for CRM Online but it is limited to usage of FetchXml reports that doesn’t have Union operation. Following article describes workaround.
Monday, November 05, 2012
Today I faced with this issue. I published standard ‘Quote’ report for external use tried it and it didn’t worked. I got following message once I tried to run a report:
Thursday, November 01, 2012
Today I have got requirement – create custom ribbon button placed to Associated View of entity, execute some logic and invoke refresh of grid. Last point was the trickiest one and that’s why I decided to share with approach how to do it.