How to Make Measures Total Correctly in Power BI Tables

Microsoft Power BI is a great tool for creating and publishing dynamic and interactive reports, but it has a few quirks that can be tricky to navigate. When creating a Power BI report with a table that contains Measures, sometimes the columns in the table don’t total correctly. When a Measure is used on rows… Continue reading How to Make Measures Total Correctly in Power BI Tables

The Top Eight KPIs Retailers Should Be Tracking (with Formulas) for Your Retail KPI Dashboard

As a retailer with a top notch retail management system, you have access to a plethora of metrics. It’s easy to get overwhelmed with the amount of data at your fingertips, so this is where Key Performance Indicators (KPIs) help you determine which metrics can be used to keep your business moving in the right… Continue reading The Top Eight KPIs Retailers Should Be Tracking (with Formulas) for Your Retail KPI Dashboard

How to Dynamically Filter in Jet Reports Using a Drop Down-List

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, when working with Jet Global’s Jet Reports, it can be time consuming to create multiple versions of the same report… Continue reading How to Dynamically Filter in Jet Reports Using a Drop Down-List

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 with Jet Global’s Jet Reports, sometimes you need to create replicating rows using the NL Rows function using custom data or combinations instead of… Continue reading How to Create Custom Replicating Rows in Jet Reports

Reporting, Business Analytics, Business Intelligence, and Corporate Performance Management

We often hear, “BI? Yeah, we have that.” But when we ask what it’s being used for, we hear about all the cool reports they can run. If this is all they are doing with the data, are they truly benefitting as much as they could with these powerful tools? You should ask yourself the… Continue reading Reporting, Business Analytics, Business Intelligence, and Corporate Performance Management

Jet Reports Made Easy – Creating an Income Statement

This video provides a quick overview on creating an income statement with Jet Professional or Jet Express. While a Jet report may look complex and difficult to create, the reality is far from that. Setting up a Jet Report is an easy and intuitive process. This video walks you through the steps of using Jet to… Continue reading Jet Reports Made Easy – Creating an Income Statement

Jet Reports and SQL Azure

As we have covered in previous blogs regarding Jet Reports, this tool is quite versatile and works well with a variety of other software tools. Connecting Jet Reports with SQL Azure is simple using a universal data connector.  To connect to your hosted database, open Jet Reports and add a new data source using the… Continue reading Jet Reports and SQL Azure

The Magical World of Rectangles in Dynamics NAV RDLC Reports

One of the challenges of report writing in Microsoft Dynamics NAV’s (Navision) Report Definition Language Client (RDLC) reports is creating multiple repeating data sections pulling from a single dataset. The easiest example I can think of comes from sales orders: You want to have your sales order show the sales lines attached to the sales… Continue reading The Magical World of Rectangles in Dynamics NAV RDLC Reports