Ok so im at a lost and hopefully someone can help me. So SF reporting is very limited and I need to pull a report that I can show to the user and allow for them to export to excel if needed. So here we go:
I have an object called wineclub and it is related to a contact. A contact can be referred by another contact which is listed on their record. What we need to display is the following in one row (is this even possible).
ContactID ContactName WineclubID WineClub WineclubStartDate ContactPrimeShippingAddress ContactEmail ReferredBy (related contact)
and related to that contact the referred by info of
ReferredbyContactID ReferredbyContactName ReferredbyWineclubID ReferredbyWineClub ReferredbyWineclubStartDate ReferredbyContactPrimeShippingAddress ReferredbyContactEmail
I tried using a cross filter and a joined report in SF but had no luck so thinking ill see if VF can help me accomplish my goal.
Any thought or help would be awesome......