Error Report Definition Language (RDL) file is not valid!

Can’t upload reports to CRM Online

Advertisements

rdl_invalid

It’s been a while since the first time I saw this error when working with SSRS Fetch-based reports for Dynamics CRM Online. Continue reading “Error Report Definition Language (RDL) file is not valid!”

Query data with case-insensitivity string comparison in Linq

Dealing with case sensitivity when querying CRM data

When building a custom email duplication detection, I need to query all records that match an input email ignoring case. I tried following approaches:

Continue reading “Query data with case-insensitivity string comparison in Linq”

Mysterious error: Metadata contains a reference that cannot be resolved. ‘https:///XRMServices/2011/Organization.svc?wsdl&sdkversion= ‘

I had a frustrating error

We built a console app which do the automation of importing flat files of entities into CRM Online. The app is run by a scheduled task in a on-premise VM server. Everything was working fine until recently, the client told us they didn’t see their data imported in CRM for a few days and it held up their work.

Continue reading “Mysterious error: Metadata contains a reference that cannot be resolved. ‘https:///XRMServices/2011/Organization.svc?wsdl&sdkversion= ‘”

Retrieve primary entities along with related entities with one QueryExpression

A colleague asked me how to query multiple primary records and their related records using one QueryExpression. I paused for a moment, I couldn’t answer him certainly. I thought it would be possible, so I started researching. Here is what I found.

Continue reading “Retrieve primary entities along with related entities with one QueryExpression”

[Exp+1] Bug in Calculated and Rollup Fields

Security issues with calculated field and rollup field in CRM V9

I created a new CRM Online trial to try out latest features from July Update 2017. The version is 1612 (9.0.0.2090) (DB 9.0.0.2072) online.

When playing with calculated field and rollup field. I found errors in the two fields. I think they are bugs, but not sure if they are from the same root cause.
Continue reading “[Exp+1] Bug in Calculated and Rollup Fields”