Skip to main content
  • How to create a drop down filter in Jet Reports
    How to Dynamically Filter in Jet Reports Using a Drop Down-List
    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
    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…
  • Navigating and Optimizing Power BI for More Effective Reporting
    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
    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
    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
    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 Ranking Report in Jet Reports
    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 Made Easy
    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…
  • How to format Power BI
    Power BI Formatting Issues Resolved
    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…
  • The Future of Budgeting: An Insider’s View
    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…
Subscribe to Elly Combow's blog