+ Start a Discussion
Teach_me_howTeach_me_how 

activities with contacts report type?

why i dont see the 'related to' field for task or event when im using this report in report builder?
sandeep@Salesforcesandeep@Salesforce

You can make this field visible by editing it's report Type layout.

Teach_me_howTeach_me_how
editing report layout? really even if is standard report type? how?
AroraAnupAroraAnup

If I understand correctly, when you do an Activities report, the RELATED TO is not visible as this relationship comes from the report data type that you select. For example: if you select Activities with Opportunity, it will by default have Related to as Opportunities. Similary, if you select Activities with Accounts, it will by default have Related to as Accounts

 

However, if you select your report type as Tasks and Events, then you will be able to see the Related To field.

Hope this helps!

Teach_me_howTeach_me_how

Im using the report type "Activities with Contact" and using this report type i want to get the information from campaign because our activities is related to campaign. Now upon building report using "Activities with Contact" report type it so happen that the "Related to" field is not visible on report builder.

 

 

I dont want to use the "Activities with campaigns" because i need also to get the infos from contacts thats why i choose to use "activities with contacts"

AroraAnupAroraAnup

Have you considered using Joined Reports? Since you need Activities with Contacts as well as Activities with Campaigns both, you may want to create 2 separate reports and join them using Contact as the link between the two.

 

Here are a few areas that you can read through to get started on Joined Reports:

 

https://help.salesforce.com/help/doc/en/reports_joined_format_overview.htm

https://help.salesforce.com/help/doc/en/reports_working_with_joined.htm

http://help.salesforce.com/help/doc/en/reports_examples_joined.htm

 

Let me know if this helps!

Teach_me_howTeach_me_how

joined report might be the closer option but the two block should group by "related to" and i cant do it because "related to" is not visible in report builder :-(