+ Start a Discussion
MaheemSamMaheemSam 

Report on contact and attachment

Hi, 

  Is there a way to prepare report based on contract object and associated attachment. 

Thanks
Sudhir
Khan AnasKhan Anas (Salesforce Developers) 
Hi Sudhir,

Greetings to you!

You can't run a report on Attachments but you can download a list of attachments by using Data Loader, Excel Connector, or the Data Export tool in Salesforce. Here is a list of the fields that can be exported:

Attachment ID
Body
File Name
Parent ID
Content Type
Private
Owner ID
Body Length
Created By ID
Created Date
Deleted
Last Modified By ID
Last Modified Date
System Modstamp

When exporting it will create an attachments.csv file that can be opened in excel and then you can create some basic graphs or pivot tables using this info.

The easiest way is to use Workbench. If you need to export it select Bulk CSV instead of List and you can download the results.

There's an idea which is active on the success community with a similar discussion for which you can upvote so that it gets available in the future.

https://success.salesforce.com/ideaView?id=08730000000BrhNAAS

Please refer to the below links which might help you further with the above requirement.

http://www.arkusinc.com/archive/2013/how-to-report-on-salesforce-notes-attachments

https://salesforce.stackexchange.com/questions/128782/report-on-opportunities-and-their-attached-files

I hope it helps you.

Kindly let me know if it helps you and close your query by marking it as solved so that it can help others in the future. It will help to keep this community clean.

Thanks and Regards,
Khan Anas