Tech Tues: Update to Automatically Refreshing Pivot Tables in Excel Refreshable Reports

  Tuesday, July 12, 2016   /     Nicole Albertson   /     0 Comments
There has been some discussion lately on the refreshing of the Pivot Tables in Excel Refreshable Reports.  I previously had written a Tech Tuesday post about how to get a Pivot Table pulling data from an Excel Refreshable Report.  You can view that post here:With this post brought many different… [Read More]

Tech Tues: Automatically refreshing Pivot Tables in Excel Refreshable Reports

  Tuesday, December 1, 2015   /     Nicole Albertson   /     21 Comments
Using the refreshable Excel Reports is a great option to be able to view your Microsoft Dynamics GP data in a tool we all love.  Whether they are the default refreshable ones that can be deployed from Microsoft Dynamics GP or ones you create using eOne's Excel Report Builder, getting the list and… [Read More]

Tech Tuesday: SmartList Builder Call to Action

  Tuesday, February 3, 2015   /     Nicole Albertson   /     2 Comments
This week I want to shake things up a little bit with our Tech Tuesday. Instead of me telling you something great about what you can do with one of the eOne products, I want you to tell me what you are using SmartList Builder for. This includes SmartList Builder, Excel Report Builder, and Navigation… [Read More]

Tech Tuesday: Excel Report Builder and Office 365

  Tuesday, November 11, 2014   /     Nicole Albertson   /     0 Comments
Excel Report Builder and Office 365 interact a little bit differently than a local installation of Office or SharePoint.Excel Report Builder and Office 365 SharePointCurrently, Excel Report Builder will not publish directly to a SharePoint site on Office 365. You can publish them locally and upload… [Read More]

Tech Tuesday: Remove All Date Formatting in Excel Report Builder

  Tuesday, June 17, 2014   /     Danielle Erickson   /     0 Comments
This week's Tech Tuesday is from Jared Dux in Quality Assurance. He highlights the Excel Report Builder aspect of SmartList Builder and how to remove all date formatting within it.In Excel Report Builder version 12.00.0067 and 12.00.0068 you can add a line to the Dex.ini to remove all date… [Read More]

Tech Tuesday: Using Drill Down Builder outside of Excel Report Builder

  Tuesday, May 20, 2014   /     Nicole Albertson   /     0 Comments
Drill Down Builder has been a part of SmartList Builder for a few releases now. It can be used to give you the ability to drill back from an outside application to the GP windows. Of course, it does require that you have security to the window that you are trying to drill back to and that you are… [Read More]

Tech Tuesday: Table Joins in SmartList Builder

  Tuesday, March 18, 2014   /     Nicole Albertson   /     0 Comments
Our Product Specialist, Nicole Albertson, will be clearing up the confusion around which Link Method to use when you are joining two tables in SmartList Builder for today's Tech Tuesday. Equals:This option will exclude any records that don't exist in both tables from the results. A record must… [Read More]

Excel Report Builder – why bother?

  Sunday, May 30, 2010   /     Martin Olsen   /     4 Comments
I was recently asked the question "Why would I use Microsoft Dynamics GP Excel Report builder, when I could just export a SmartList to Excel? ". This question is huge? Not huge in that it is a deeply mind troubling question, but huge in the number of Dynamics GP customers that do not know the… [Read More]

open all | close all