In my org and sandbox I have a Custom Report Type (CRT),
Accounts with Applications, based on
Accounts with at least one Opportunity. I recently used a Change Set to deploy new custom fields on the Opportunity as well as updating the fields available on the CRT. The Change Set validated and deployed but not without odd behavior:
- Existing reports based on the CRT lost all filters, including date ranges. When reconfigured they produce results, but if you try to modify the columns present then you get no records returned.
- New reports based on the CRT show no records (tested as System Admin, top of the role hierarchy.)
- The CRT's field layout is correct; the sections and fields are present as expected
- The CRT's object relationship is wrong. It is Accounts with at least one other Custom Object
I've verified the XML in the Change Set on both sides is correct and identical. I've tried deploying a brand new Change Set with just the CRT and nothing changes.
Has anybody experienced this?
Similar: Custom Report Type Broken