+ Start a Discussion
StaciStaci 

custom report with custom object, child object

I need a report but everything I try isn't giving me what I need.

I have an object (Support Subscriptions).  I have a master-detail relationship with another custom object (Subscription Assets)
Master - Support Subscription
Detail - Subscription Asset

Support Subscription has a lookup to Accounts.  I have the related list on Accounts layout.

In my report I need to see what accounts have what assets.

In my custom report I used Accounts as the top object, then subscriptions using "A", then added assets using "B".

When I put the report and the assets are all -.  I know there are some assets so there should be something showing up in that column. Please help! 
Best Answer chosen by Staci
AnudeepAnudeep (Salesforce Developers) 
There is a good example outlined in this post that I recommend reviewing