Community
Showing results for 
Search instead for 
Do you mean 
Reply

Report if a Company has Documents attached.

New Member
Posts: 6
Country: USA

Report if a Company has Documents attached.

I am looking to create a report in Crystal reports that will display if a company has documents attached. What table/field is this data stored in?

 

Thanks!

Bronze Elite Contributor
Posts: 2,115
Country: United_Kingdom

Re: Report if a Company has Documents attached.

[ Edited ]

dbo.TBL_Attachment

 

*****UPDATE******

Sorry that was a bit terse! You'll need to join with Company_History and Company on the CompanyID and HistoryID.

*********************

Vivek Gargav
Caldere Associates Ltd.
www.caldere.com
vgargav@caldere.com
My Blog
New Member
Posts: 6
Country: USA

Re: Report if a Company has Documents attached.

ACT! 2011 Premium

 

I do not have dbo.TBL_Attachement

New Member
Posts: 6
Country: USA

Re: Report if a Company has Documents attached.

Thanks for the update!
Employee
Posts: 1,163
Country: USA

Re: Report if a Company has Documents attached.

Just to add to what Vivek has already said. Attachments are a type of history, specifically they are a history of type Library Document. 

Matthew Wood
Act! SDK Support
Community Moderator
Silver Super Contributor
Posts: 2,328
Country: USA

Re: Report if a Company has Documents attached.

No "e".  dbo.TBL_ATTACHMENT

 

Stan 


If you would like to get more out of ACT! you can find an ACT! Certified Consultant near you by going to:www.act.com/acc.
-------------------------------------------------------------------------------------
Stan Smith
ACT! Certified Consultant
ADS Programming Services, Inc.
(205) 222-1661
www.adsprogramming.com
www.actwebhosting.com
Click Here to Purchase Act!