+ Start a Discussion
Parteek Goyal 3Parteek Goyal 3 

Is it possible to use soql join in creating report in salesforce

Hi All,

I want to know that Is there any way to use soql join for creating report in salesforce.

There is no SOQL ability in reports. Maybe you could explain what you are trying to accomplish with the join.
You do have some options to either include or exclude records based on cross filters. https://help.salesforce.com/HTViewHelpDoc?id=reports_cross_filters.htm 
Or if you want to add more information to the report you can use joined reports https://help.salesforce.com/HTViewHelpDoc?id=reports_joined_format_concepts.htm
Parteek Goyal 3Parteek Goyal 3
HI Thomas,

I have a matrix report on Campaigns with Campaign Members. it is group by lead/Contact owner as row. when i select a record and click on show detail it should show all activity history of Campaign as column(suppose campaign have 3 activity history then it should create three column in report). But it only shows last Activity of campaign.

Please help me...
Sorry, I can't help you with a specific report. I was just answering your original post about SOQL joins in reports.