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
Category: Reporting
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
Jet Reports Web Portal Setup
The new Jet Reports Web Portal brings collaboration and sharing to a new level. Features include version control, central permissions, sharing settings as well as the ability to use Office 365 to use your reports anywhere. Jet Reports: Server Setup To publish reports to the Jet Web Portal you first need to install the Services… Continue reading Jet Reports Web Portal Setup
Getting started with Jet Reports and Dynamics NAV
Jet Reports makes doing budgets simple. With real-time automated metrics and a familiar interface, it is easy (and free) to get started with Jet Reports. Just download Jet Express to get started. For Jet to connect to your NAV system, you first need to give it the address. You can do this by clicking Data… Continue reading Getting started with Jet Reports and Dynamics NAV
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
Microsoft Dynamics NAV 2013 Report Printing Oddity (and a Solution!)
I have to give credit to my colleague, Suresh Kulla, for helping me out with this one, since I only figured it out after he explained it to me. I was working on a report yesterday when something maddening happened. I was making some customizations to the Service Quote report in Microsoft Dynamics NAV 2013… Continue reading Microsoft Dynamics NAV 2013 Report Printing Oddity (and a Solution!)
Microsoft Dynamics NAV 2013 RDLC Reporting RBC Attacks: Part 3 of 10
NAV 2013 RDLC Reports can create a vast ocean of issues for the developer to resolve. Yet in the midst of our pain and frustration, there are answers. Within our own developer community, the Dynamics User forum and the Microsoft Business Solutions (MiBuSo) forum are full of answers to RDLC report problems. But…you need to… Continue reading Microsoft Dynamics NAV 2013 RDLC Reporting RBC Attacks: Part 3 of 10