+ Start a Discussion

Reports - Problem


I have a custom object "Financial Account" which have Master Lookup to Account.


I want to create a report in which i want to display the fields of Account and their associated contacts and their associated "Financial Account" object records.


But when i go through to create a report choose report type Account & Financial Account the fields tab do not show the fields of contact.



From your description both the Contact and the custom object Financial Account have many to one relationship with Account standard object.


So both the Contact and Financial Account are in the same hierarchy.


So using standard report type or Custom report Type (allows only for hierarchal object, not between parent and sibling) there are no reporting available.


If strongly required you need to develop a VisualForce  page to show data from the 3 objects.



Dinesh Nasipuri