Today was the big announcement for Microsoft Office 365.  Steve Ballmer, in NYC, made the announcement of the general availability of Office 365 and gave many great examples of the power and flexibility you get from having Office 365 deployed.

This really also allows SMB customers, those that typically have not had IT resources, to finally get features such as Sharepoint and Lync at their companies.

Take a look at the collateral on our new Partnersource site that is up today for more information, and check back shortly, as more DemoMate materials are coming soon!

Jay

https://mbs.microsoft.com/partnersource/marketing/marketingcollateral/demos/MSDYGP_Office365Integration

This demo, featuring Business Analyzer, illustrates how Microsoft Dynamics GP can provide you and your company with more insight and greater efficiency.

What's new in Microsoft Dynamics GP 2010 R2? This PowerPoint presentation highlights the new features you'll find in Dynamics GP 2010 R2.

Wondering what to do after you’ve installed Microsoft Management Reporter? Click this link for tips and info to ensure a smooth migration.

Management
Reporter - Migrating from Microsoft FRx

Connector is a unique solution that integrates Microsoft Dynamics ERP with Microsoft Dynamics CRM. Check out the Connector team's blog site at   http://blogs.msdn.com/b/dynamicsconnector/ to watch demos and learn more!

Sorry, I LOVE anything dealing with pivot tables . . . especially if you add power pivot to them.  Thanks to Belinda Allen for this video.

Have you ever wanted a list of all the Microsoft Dynamics GP 2010 R2 SRS Reports, but were afraid to ask?

No fears!  Here is the list of all SRS reports that we now have in Microsoft Dynamics GP 2010 R2!

<See attached PDF>

I've been deliquent on these but you can go back to see the other posts.  We had a great celebration last night.  Here is the article.

Microsoft partner, The TM Group, Inc., has embraced the social media wave to build connected end-to-end marketing campaigns while also incorporating mainstays like telemarketing and direct mail into the mix. They are also funneling and monitoring these activities through their in-house Microsoft Dynamics CRM solution.  See more HERE.

It's all in the family at the Schoenfish house . . . we live Microsoft.   :)   Article here.   

The local Fargo paper is doing a series of articles celebrating the 10 year anniversary of Microsoft's acquisition of Great Plains Software.  HERE.

Here's another picture from the past.  We had a barbershop group that sang at various company events (including Stampede).  Can you figure out which one is me?

The New Business Analyzer in Microsoft Dynamics GP 2010 R2 renders SQL Server Reporting Services (SRS) reports at the time and place that makes sense for you. Business Analyzer can display reports from your Navigation Lists or right on your desktop. Not only can reports be viewed but you can also take actions against those reports to easily edit and collaborate with others.

Here's how.

1. Create an ODBC connection to the Excel file you want to use as a data source

Start>>Control Panel>>System and Security>>Administrative Tools>>Data Sources (ODBC)

Select the System DSN from the ODBC Data Source Administrator window

Select the Add

Select Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb) from drop down list of available drivers

 Select Finish

Enter a Data Source Name and Description

Select the Select Workbook ...  Button

Browse to the file you want to use as the data source and select OK.

Select OK

Your data source should now appear in the list of System DSN's.

Select OK to close the window.

2.  Create the SQL Server Reporting Services Report

a. Open Report Builder 2.0 or Report Builder 3.0 (Start > All Programs > Report Builder 2.0/3.0)

b.  Select to create a blank report.

Right Mouse click over Data Sources and select Add Data Source

Enter a Name for the data source

Select radio option to “Use a connection embedded in my report”

Select ODBC from the Select connection type drop down

Select the Build button

On the Connection Properties window select the System DSN you created

Select Test Connection

Select OK to close the window

Select OK to close the Data Source Properties window

Perform a right mouse click over Datasets and select Add Dataset

Enter a Name for the dataset.

Select the radio option to “Use a dataset embedded in my report.”

Select “Excel” as your data source (step 2D)

Enter “Select * from [sheet$]“in the query field

Select Query Designer…

Execute the query by selecting the red exclamation point to valid your query

Select OK to close the Query Designer window

Select OK to close the Dataset Properties window

You now have your Excel file set as your data source and you are ready to build a report.