I need to generate a Report on Daily basis for Contacts. I want to see daily
activities and notes at the end of day. i want to see it with user name.

Currently Filter is applied on Contact or Activity. But If user has entered
a notes whole day and he didnot enter any activity then
That record will not appear.

any help what i can do to get my desired report.

Regards,

BizWorld

Hi,

You should use LEFT OUTER JOIN instead of INNER JOIN to obtain your
data. (Inner join restricts the data to only those in both tables,
while a left join from Contact to Notes and Contact to Activity will
get you all contacts, and any notes against them, and all contacts with
any activities against them. HTH,

Dave

-------------------------------------------------
David L. Carr, President
Visionary Software Consulting, Inc.
Main #: 971-327-6944

Introducing our newest software product...
VAST - an auditing solution for Microsoft CRM 1.2
VAST shows you "Who Did What When" in Microsoft CRM
To download our free trial, get more info, or to order, visit
http://www.VSCRM.com

Dave,
I am not writing any sql query. I am talking about CRM Available Reports.
Activities and Notes list report is behaving like this. Is there any way we
can get the desired result in CRM.


"Dave Carr (dave- no spam-@vscrm.com" <dave@vscrm.com> wrote in message
news:1115923825.105539.191950@z14g2000cwz.googlegr oups.com...