Re: Adding Notes Field to a Phone Call Report by Amy
Amy
Tue Mar 25 14:48:43 CDT 2008
On Mar 25, 3:24=A0pm, Camilla Turner
<CamillaTur...@discussions.microsoft.com> wrote:
> We are wanting to put together a report that lists phone calls by complete=
d. =A0
> When the report runs, we would like to have any Notes that are attached to=
> the phone call show up in the report. =A0
>
> Anyone know how to accomplish this? =A0Thanks!!
>
> Cammie
We used the following code when including opportunity notes. The key
is that you need the annontation table.
FROM FilteredOpportunity LEFT OUTER JOIN
Annotation ON FilteredOpportunity.opportunityid
=3D Annotation.ObjectId