Community
Contact us | Act.com
Turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Do you mean 
Reply

Report if a Company has Documents attached.

New Member
dotcom
Posts: 6
Country: USA

Report if a Company has Documents attached.

‎08-09-2011 08:37 AM

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!

Report Inappropriate Content
Message 1 of 6 (1,932 Views)
Reply
0 Kudos
Bronze Elite Contributor
Bronze Elite Contributor
vivek
Posts: 2,119
Country: United_Kingdom

Re: Report if a Company has Documents attached.

[ Edited ]

‎08-09-2011 08:59 AM - edited ‎08-09-2011 09:01 AM

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
Report Inappropriate Content
Message 2 of 6 (1,929 Views)
Reply
New Member
dotcom
Posts: 6
Country: USA

Re: Report if a Company has Documents attached.

‎08-09-2011 09:19 AM

ACT! 2011 Premium

 

I do not have dbo.TBL_Attachement

Report Inappropriate Content
Message 3 of 6 (1,924 Views)
Reply
0 Kudos
New Member
dotcom
Posts: 6
Country: USA

Re: Report if a Company has Documents attached.

‎08-09-2011 09:23 AM

Thanks for the update!
Report Inappropriate Content
Message 4 of 6 (1,920 Views)
Reply
0 Kudos
Employee
Employee
mwood
Posts: 1,163
Country: USA

Re: Report if a Company has Documents attached.

‎08-09-2011 09:32 AM

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
Report Inappropriate Content
Message 5 of 6 (1,918 Views)
Reply
0 Kudos
Silver Super Contributor
Silver Super Contributor
wellmet
Posts: 2,342
Country: USA

Re: Report if a Company has Documents attached.

‎08-09-2011 10:24 AM

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!
Report Inappropriate Content
Message 6 of 6 (1,918 Views)
Reply
0 Kudos