How To: Create a Dropdown Filter in a Jet Report  This blog provides step-by step instructions on how to create a dropdown list for end users to use to filter a Jet Report without the end user needing Jet Reports license. As a report designer,…

How To: Create Custom Replicating Rows in Jet Reports This blog provides step-by step instructions on how to create replicating rows in Jet Reports using the NL Rows function without referencing a table in your database or cube. When working…

How to Navigate and Optimize Power BI for More Effective Reporting Microsoft Power BI is a reporting and analytics tool that can analyze data from a myriad of sources, including Microsoft Dynamics NAV, Excel, Google Analytics, social networks, APIs…

How to Set Custom Color Themes in Microsoft Power BI  When publishing internal and external reports for your business it is important to be consistent with your branding standards by using the same color schemes and logos. Microsoft Power BI it a…

How to Save Commonly Used Filters in Dynamics NAV Often when we work in Dynamics NAV, we use the same filters and settings over and over again.  You might have a customer list that you pull to review every month, or a set of invoices you need to…

Creating a Date Table in Power BI   Often when using Microsoft Power BI, you will find that you need a calendar or date reference for your data to organize it by months or weeks, or even the day of the week. If your data has some date information…

Creating a Ranked Jet Report Those of us who use Jet Reports are painfully aware that Jet does not have a ranking feature for replicated lists. However, there is a workaround: you can create an automatically sorted Jet report with nested Jet…

Microsoft Power BI Map Visualizations   Microsoft Power BI is a powerful tool that allows users to pull real time data directly from Microsoft Dynamics NAV and other sources for analysis and reporting. Included in the analyzation options are two…

Formatting Data to Create an Issue-Free Report in Power BI   Microsoft Power BI is an amazing tool. It allows me to build reports that update with real-time information from our ERP system, Microsoft Dynamics NAV, so that all of our team members…

Budgeting and Microsoft Dynamics NAV At ArcherPoint, we strive to be on the cutting edge of all new software advances and tools in the market. We even have a core value to learn and challenge ourselves. Yet, while we focus on technology to help…