Apex Code Development You need to sign in to do that
Don't have an account?
Unable to use 2 fields for grouping in Joined Report
Hi, I have the following Custom Objects and Report Types
CustomObj1 has a Lookup field to Account and another Lookup field to Product
CustomObj2 also has a Lookup field to Account and another Lookup field to Product.
ReportType1 use CustomObj1 as the Primary Object with Account ID and Product ID added via Lookup in Fields Available for Reports section
ReportType2 use CustomObj2 as the Primary Object with Account ID and Product ID added via Lookup in Fields Available for Reports section
I created a Joined Report but the common fields is showing only for Product object when I selecting the 2nd Report Type.
What is missing in my report or is it not achievable?
Thank you.
CustomObj1 has a Lookup field to Account and another Lookup field to Product
CustomObj2 also has a Lookup field to Account and another Lookup field to Product.
ReportType1 use CustomObj1 as the Primary Object with Account ID and Product ID added via Lookup in Fields Available for Reports section
ReportType2 use CustomObj2 as the Primary Object with Account ID and Product ID added via Lookup in Fields Available for Reports section
I created a Joined Report but the common fields is showing only for Product object when I selecting the 2nd Report Type.
What is missing in my report or is it not achievable?
Thank you.