Single or combined report

Guys,

I need some help on figuring out how to go forward with this issue. (I posted a topic where JFV does not work and as a work around I need a report.)

This revolves around 3 objects Accounts, Custom Object 15 (Location) & Custom Object 5 (Demand)
I'll explain the data view with an example

Account Records       Location Records
Account 1                   Location A
Account 2                   Location B
Account 3                   Location C

Demand Records
1-->  Account 1 Location A
2-->  Account 1 Location B
3-->  Account 1 Location C

4-->  Account 2 Location B
5-->  Account 2 location C

Each account can be linked to multiple locations and similarly each location has multiple accounts (NOT DIRECTLY but via the demand profile). Basically a M-to-M relation but with additional data, therefore we have to use a 3rd object to use as the intersection record/table.