Crm Data To Share Point Reports

50 %
50 %
Information about Crm Data To Share Point Reports

Published on July 16, 2009

Author: Peter1020



CRM reporting in SharePoint, with Jet Reports

Presented By Peter Ward - Business Collaboration Manager Tara May - Report Writer July 15th 2009

 The conference call dial in will be put on mute for the presentation  Q&A – We will have time at the end of the presentation for questions  A copy of the presentation is on my blog:

 Reporting information  How we want information now  Current GP/ CRM reports  Jet Reports  Demo This is not a tip session

 We use information in 4 ways  Read it - report  Glance at it - dashboard  Store it  Ignore it  Today we store information in the wrong format

Web 1.0 Web 2.0 Hi, have you CRM/GP seen the Hi, have you report seen the report Database Tag Rate It’s in my in GP/CRM box Database Hi, have you seen the report Comment

 Save the files locally and post onto SharePoint when it’s a necessary  People still email everything around….all manually  All reports are in Excel files  The following quick win functionality is not being used:  Alerts  Workflows  Dashboards  2 click approaches  Everyone still asks for the reports…

GP/CRM Data Power user (Non technical) Reporting tool Straight connection to the GP/CRM data schema or other data No cube building Reports can scheduled Output is Excel or web page (SharePoint)

 Excel   or HTML (Excel saved as HTML)        All formatting, graphs, calculations, ALL EXCEL  Real-time access to data  Multi: Database, Dimension, Company, etc  Anything ODBC/OLE Compliant  Automated distribution with Jet Reports Scheduler  Integration with CRM/Great Plains and Customized databases  Simple and short implementation  Great Support and training.  Support site access for licensed designers.  Types of Users  Licensed Designer: Can Design and View Reports  Licensed Viewers: Can View Reports with Drilldown and Refresh.  Anyone can view static reports once they have been generated

Designer: Create reports Have access to the data Ultimately set up the format and filtering on the reports and statements Control what non-designers can see or run. Viewers: Jet Reports’ Viewers are licensed to run reports that Designers create, Real time data within the database (refresh), directly in Excel/html. Viewers are also able to change filters/parameters Non design capabilities Excel Users: Because all Jet Reports are Excel files, anyone with Excel can see a report. For these users, reports will be static and will not be able to be refreshed.

For the demo, please observe: Types of reports Webinized information Drill down functionality Ease of use

 Webinized information  Information that is available to the right people at the right time  The IT department is finances best friend  In fact the IT department is everyone's best friend  There are no surprises with performance

 SharePoint has a self service model  Do you need SharePoint/Jet Reports for report writing?  Ask yourself ‘What is your almost certain predictable future with your  organization’s reports?’  More reports?  Less resources  Greater demands from the business on performance indicators  Shorter time frames  This is a major win in any organization- to take you to the next level.

 InterDyn SharePoint/ Jet Report Quick Start Program  Jet Report Pricing / Promotions

Questions?  Email :   Phone: 212 502 3937 Microsoft confidential internal use only Be part of the experience

Add a comment

Related pages

Reporting & Analytics CRM | Reporting Suite Sharepoint ...

... on data stored in your CRM. Tools such as SQL Server Reporting Services can deliver ... and export data. ... SharePoint CRM solution is 100 ...
Read more

Integrating SQL Reports into SharePoint for CRM | CRM ...

2 Responses to Integrating SQL Reports into SharePoint for CRM. crmconsultancy says: ... Integrating Dynamics CRM Data into SharePoint 2010
Read more

Integrating Dynamics CRM Data into SharePoint 2010 | CRM ...

10 Responses to Integrating Dynamics CRM Data into SharePoint 2010. Usman says: January 8, 2012 at 11:45 pm.
Read more

SharePoint 2013 & CRM: A True Love Story - YouTube

Need to report the video? Sign in to report inappropriate content. Sign in. Transcript; Statistics; ... SharePoint 2010 and CRM 2011 Integration ...
Read more

PowerView Reports in Dynamics CRM 2013 - Concurrency

PowerView Reports in Dynamics CRM 2013. ... post for further details on creating PowerView reports from LOB data ... Report in SharePoint Online.
Read more

Customize and organize reports | Microsoft Dynamics CRM

Customize and organize reports. ... All reports read Microsoft Dynamics CRM data from filtered views, ... such as Microsoft SharePoint or custom programs.
Read more

Create a Power View Report in Excel with CRM Data

... we'll show you how to create a Power View report ... workbooks to a gallery in SharePoint, ... a Power View Report in Excel with CRM Data ...
Read more

Download Microsoft Dynamics CRM 2013 List Component for ...

Microsoft Dynamics CRM 2013 List Component for SharePoint. ... The Microsoft Dynamics CRM 2013 List component for SharePoint makes Microsoft Dynamics CRM ...
Read more

Accessing CRM from SharePoint | The CRM Book

Accessing CRM from SharePoint. ... Microsoft Dynamics CRM Report Wizard; Data Management. Auditing; Importing Data in Microsoft Dynamics CRM.
Read more