Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2020 Release Wave 2Discover the latest updates and new features to Dynamics 365 planned through March 2021.
Release overview guides and videos Release Plan | Preview 2020 Release Wave 2 TimelineWatch the 2020 Release Wave 2 virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
As time goes on, GP databases are getting larger and larger and users are looking for a great way to pull up the data they need.
This is usually done great through SmartLists, but sometimes you need to pull very large sets of data, and can’t tie up a computer waiting on SmartList to load tens of thousands of lines. Simply put, SmartList is great for moderate amounts of data, but anything over a few thousand is going to take quite some time. That is, if it works at all.
This is where the Excel Refreshable Reports come in. These reports are great as they pull data from SQL views, and only really tie up a single Excel instance.
To that end, I wanted to walk through some items to help you make the most of the Excel Refreshable Reports. Over the next few weeks, we will be walking through everything you need to know; from publishing them, modifying them, to even making custom reports from scratch.
Let’s start off simple:
How do I deploy the Excel Refreshable Reports?
Deploying the reports can be relatively simple, just follow these steps:
Note: If you have previously deployed reports and want to deploy them again you can mark the ‘Redeploy all reports for selected companies’ option. This will redeploy EVERYTHING, including SSRS reports.
This is it! Once the bar completes, you can go out to the report folder you made in step 1 and look at your new reports. These are mostly based on the default SmartLists, so usually you can find something close to what you need. These reports can also be found in the same list as your Navigation Lists on the left side of the each of the different (Financial, Sales, Purchasing) area panes.
So, what happens if these reports are close, but you are missing a column you added in SmartList?
This leads us to editing the default reports, which we will get into next week!
The Excel Reports blog series:
Starting off with Excel Refreshable ReportsGetting more Advanced with Excel Refreshable ReportsGetting Custom with Excel Refreshable Reports
Business Applications communities