Salesforce reporting across objects

I would like to run a report in Salesforce that pulls in data across multiple objectives (Leads, Activities, Opportunities). Has anyone been able to complete this either with custom reporting or developing a custom app using Force?
Kevin RiceChief Sales and Marketing OfficerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Brett ZikaCommented:
I've found this to be exceedingly difficult. Saleforce out of the box does not solve this issue, you would likely have to create a custom application. Sorry I could not be of more help.
Kevin RiceChief Sales and Marketing OfficerAuthor Commented:
@Brett, Unacceptable.
Amy WallerMarketing Operations ManagerCommented:
The best way to do this would be to convert a lead into a contact and from there you can use the "related to" field to populate with the opportunity name. Doing this retro-actively takes time, and I'm sure, not what you are looking for.
The next way would be to export the two reports and use excel to relate values based on a common field.
Leads are siloed off in Salesforce, making reporting on them (except for activities) very difficult. If you can create a common field across the objects, it will make it easier to relate between the objects.
In the past, we used excel to mashup the data. It was a bit cumbersome, but we were able to get good actionable analysis from it.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Amy WallerMarketing Operations ManagerCommented:
@Kevin Did you see that Microsoft and SFDC recently released the Wave connector that allows you to sync over excel data into Salesforce. This might solve your reporting issue. I haven't had the time to play around with it yet, but it looks pretty neat!

http://microsoft-news.com/salesforce-releases-wave-connector-app-for-microsoft-excel/
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Enterprise Software

From novice to tech pro — start learning today.