Upgrading to CRM3 and the Activitybase

I have just upgraded to CRM V3.

I use crystal reports with CRM and have had no problems until I upgraded.
The Table Activitymase no longer exsists and I cannot see the replacment
table.


Please Help.

Thank you
Mark

Dave
Fri Jan 27 10:15:20 CST 2006

Mark;

CRM 3.0 no longer uses Crystal for it's reports - assuming you knew that
already.

Regardless of the report writer you use, the activitybase table has now been
split out into a separate table for each activity type (ie, faxbase,
emailbase, appointmentbase, etc).

Dave



"Mark Gallagher" <Mark Gallagher@discussions.microsoft.com> wrote in message
news:72853D80-0032-4DB2-B8D0-B85D7272F3EE@microsoft.com...
>I have just upgraded to CRM V3.
>
> I use crystal reports with CRM and have had no problems until I upgraded.
> The Table Activitymase no longer exsists and I cannot see the replacment
> table.
>
>
> Please Help.
>
> Thank you
> Mark

Dave
Fri Jan 27 14:36:29 CST 2006

Mark,
Rather than re-doing all activity reports, you may want to look at
creating a SQL Server view that contains the activitypointerbase and
<appointmentbase, faxbase, etc.> tables that you need joined in that
SQL view. HTH,

Another Dave (He's Dave Ireland, maybe I should be Dave Oregon ;-)

-------------------------------------------------
David L. Carr, President
Visionary Software Consulting, Inc.
http://www.vscrm.com
971-327-6944

For a free, fully functional demo version of VAST, the Microsoft CRM
auditing solution, please visit
http://www.vscrm.com/vast_download_page.php

Dave
Sun Jan 29 13:33:06 CST 2006

:)

"Dave Carr" <dave@vscrm.com> wrote in message
news:1138394189.532666.304550@g47g2000cwa.googlegroups.com...
> Mark,
> Rather than re-doing all activity reports, you may want to look at
> creating a SQL Server view that contains the activitypointerbase and
> <appointmentbase, faxbase, etc.> tables that you need joined in that
> SQL view. HTH,
>
> Another Dave (He's Dave Ireland, maybe I should be Dave Oregon ;-)
>
> -------------------------------------------------
> David L. Carr, President
> Visionary Software Consulting, Inc.
> http://www.vscrm.com
> 971-327-6944
>
> For a free, fully functional demo version of VAST, the Microsoft CRM
> auditing solution, please visit
> http://www.vscrm.com/vast_download_page.php
>