We are wanting to put together a report that lists phone calls by completed.
When the report runs, we would like to have any Notes that are attached to
the phone call show up in the report.

Anyone know how to accomplish this? Thanks!!

Cammie

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