Our solutions & services
enable you to
save time. save money. make decisions. make sense of your data.

Latest News


Here you will find all the latest news from APB Reports.
Send us an email if you would like an automated email each time we add a news entry.
We update this news site when we release new tools and updates so please visit regularly to read the latest announcements.

New Power BI Dashboard Project

We are pleased to announce the recent delivery of a new Power BI and data warehouse solution for a client in the Offshore Industry. This project involved specifying and configuring ETL jobs from a TM Master Production database which included data related to equipment, inventory, purchasing, maintenance and replication checks. This data was then setup in various tables in a new data warehouse to track trends, summaries and the current status onboard the vessels. With close cooperation with the client's technical department, we then designed a collection of Power BI dashboard pages to present this data in the best way possible, making it fast and easy to see the necessary trends and information at a glance. The Power BI dashboard pages connect securely through a Microsoft gateway and automatically refreshes several times a day.

The advantage of using the Microsoft Power platform is that it is both a fast and cost effective way of presenting your data in professional dashboards for all your employees. Dashboards can be setup with powerful filtering and drill-down capabilites which enable your users to "slice and dice" the data and use them on a daily basis as business tools. Remember if you can't measure it, you can't manage it.

If you need assistance in building Power BI dashboard pages please email, call, or fill out our contact form to speak with a qualified Consultant.

New high performance database replication

We are pleased to announce we have just delivered a new data warehouse to one of our clients in the Energy Industry. This project involved setting up a brand new MS SQL Server data warehouse and to ensure all data is 100% in sync with an Oracle production database. With some "first principles" thinking we managed to design an automated setup which enables more than 120 tables to replicate in just 40 seconds. In previous projects we have seen similar replication tasks taking in excess of 30 minutes so we are very pleased with this performance.

If you would like to setup a new data warehouse database for reporting/dashboards that will not impact your production database please let us know.
Our team has 15+ years experience with both MS SQL Server and Oracle. Email, call, or fill out our contact form to speak with a qualified Consultant.

New Customers in 2022

We are very pleased to have delivered software and reporting solutions to the following new Customers this year in the following industries:
Software, Manufacturing, Transport, Construction, Government, Legal, Publication, Home/Furniture and Architecture.

At APB Reports we work with businesses of all shapes and sizes to understand their reporting requirements and help build the necessary reports and dashboards to help save them time and money. Try us out with a couple of reports to see how it goes. We promise you will be impressed.
Email, call, or fill out our contact form to speak with a qualified Consultant.

Arms, Hogia, DRS Inc, Peerless, ASOPLAST, FSL Group, UBC Press, Porter Corp, Davis & Davis,
Arizona Courts, GLP Attourneys, Cascade Computers, Lueder Construction

Google Data Studio Dashboard (Tesla Bjørn)

At APB Reports we are big fans of Electric Vehicles and since we are based in Norway we are also big fans of Tesla Bjørn (Bjørn Nyland).
He makes very entertaining and informative youtube videos where he tests all the latest Electric Vehicles in areas such as charging, range, storage, efficiency, comfort, sound, safety and of course the famous 1000km challenge.

We thought it would be interesting to connect to Bjørn's live data and present some of the numbers in a Google Data Studio dashboard. This dashboard focuses on range and efficiency and is a good tool if you want to make some fast comparisions between vehicles and seasons.

For those of you who don't know, Google Data Studio is a great tool for making Dashboards and sharing them with the public, internally at your company or just a small set of users. It has loads of functionality and maybe the best part - it is completely free to develop and share dashboards!

We have made several Dashboards that connect to Google sheets including some client dashboards, internal company dashboards and even a Strava dashboard. If you need assistance in building Google Data Studio dashboard pages please email, call, or fill out our contact form to speak with a qualified Consultant.

Check out the dashboards here: Google Data Studio   |    Check out Tesla Bjørn's youtube channel here: Youtube

Global Football Search

At APB Reports we love all sport and one of the sports we are most passionate about is Football.

So just for a bit of fun we thought we would build a football search engine where you could quickly view the
table, goal scorers, assists and cards for any country, any league and any season.

Give the new page a test run and let us know how it goes: APB Global Football Search
Please contact us if you need a company dashboard to present your Key Performance Indicators or any other business related data.

Introducing: APB Minify

We have just finished developing another useful .Net tool which provides minify and compression methods for CSS, JavaScript and HTML files.

With APB Minify you can select one or more files, entire folders and even sub folders and automatically minify/compress the files. The application can be run automatically from a batch file which references a specific config file which contains the folder/file path you wish to compress. This application supports JS minification, Css minification and also HTML minification. On average you can expect to reduce standard HTML document by 5-10% and that could save you precious bandwidth and load times. We use APB Minify to minify all our dashboard pages at our clients to save bandwidth and increase performance by a minimum of 5%. You simply run the batch file before uploading your pages to your FTP site or production web server.

Please contact us if you are interested in purchasing a license of APB Minify for only $20 USD.

New Crystal Report Viewer: CR Dispatch

We have just finished developing our new Crystal Report Viewer: CR Dispatch.

CR Dispatch was developed to enable your staff/clients to view Crystal Reports as fast as possible and without any distractions. There are several other Crystal Report viewers on the market with powerful functionality, however, we decided to develop a “lite” Crystal Reports viewer that would enable you to view a report, securely, with only one click of a button. We like to think of CR Dispatch as a shortcut to view a Crystal Report instantly. We also think the default Crystal Reports runtime has all the functionality you actually need: View, Navigate, Filter, Export, Print, Search, Bookmarks, Drill-down, Zoom etc.

You can learn more about CR Dispatch here.
Check out a quick demo of the application in action here.
Please contact us if you are interested in purchasing a license of CR Dispatch for only $20 USD.



Introducing Dashboard Sync

We are pleased to announce the release of our latest application: Dashboard Sync.
This new tool will solve a number of business requirements for your static HTML projects.

Offline viewing: You can now automatically sync your static html projects to your local PC. This will allow you to view all your sites while you are at home, out traveling or presenting at a conference for example. Once you are back at the office the latest files on the server will automatically sync to your local PC.

Lightning fast performance: Once your HTML files have copied to your local PC, you will benefit from very impressive browser performance. Your HTML files will load almost instantly. Even large HTML files with thousands of rows can be viewed in just a few seconds.

Sync Technology: Dashboard sync has 2 fast synchronization methods: Zip Sync or Parallel File Sync.
Zip Sync: For very large HTML projects that get updated frequently, you can choose to only sync 7z/zip files in the root directory. Once these zip files have synchronized to the client, they will be unzipped automatically and your old files will be refreshed. It is always much faster synchronizing just a few large zip files instead of thousands of smaller files across the network.
Parallel File Sync: This sync method compares all files between the server and client based on the file size and modification date. Files are transferred in parallel and files will sync as fast as your CPU permits. This parallel file transfer results in very fast sync times. This sync method is ideal for smaller HTML projects where the total amount of files is less than 5,000.

Chromium core: Many Enterprise employees are stuck using older IE versions. Fortunately, we have integrated the Chromium browser (Chrome) in this application so you can include all the latest web functionality in your HTML sites and ensure your pages are processed as quickly as possible. You can also ensure that all your employees see the exact same view since there are no browser versions or settings to worry about.
Furthermore, there is no installation necessary since it is a pure .Net application. Just copy, paste and run.

Useful features:
*  Full-screen mode: this is useful to display the HTML site on a TV in the office or during a presentation.
*  Hide settings in application: this is useful if you do not want some employees viewing/changing the configuration setup.
*  Encrypted login: the username and password which is used to sync the files between the server and client are encrypted in the configuration file.
*  Multiple sync locations: sync up to 4 different locations (source) to your clients (destination).
    This is useful if you want to combine up to 4 projects into a single local project.
*  Query string paramaters: append a query string to the end of all .html hyperlinks in the application.
    This is useful if you want to pass default filters and information to all pages. E.g. Office=Trondheim&User=John_Smith.
*  Flexible sync interval: files will sync automatically from the server at an interval you define.
    You can also choose to sync with Zip sync or Parallel file sync.

This tool is a perfect addition to our ADD (Auto Data Deploy) tool which enables you to automatically create static HTML files from your MSSQL and Oracle databases. We have a simple licencing setup for this application. For a low fixed price, you can install it on unlimited PCs within your organisation. No annual maintenance fees will be charged.

Please contact us if you are interested in learning more about Dashboard Sync.



SAP Crystal Solutions Success Profile

We were recently selected as one of the SAP Crystal Solutions Success Profiles.
Feel free to have a read of our interview with SAP Digital here.

In the interview we discussed some of the benfits using SAP Crystal Reports. With SAP Crystal Reports, you can create powerful, richly formatted, dynamic reports from virtually any data source, delivered in dozens of formats, in up to 28 languages. A robust production reporting tool, SAP Crystal Reports turns almost any data source into interactive, actionable information that can be accessed offline or online, from applications, portals and mobile devices.



New CSV Import Tool

A client recently had a requirement to automatically import data from CSV files into their database on a daily/weekly basis. Today we are pleased to annouce the release of a new CSV Import Tool which does exactly that.

The CSV Import Tool enables you to automatically import all data from a CSV file into an MSSQL & Oracle database. The tool allows you to configure the folder, file name (begins with), tab name and of course the destination table name. The tool gives you the the option to ignore the first N rows if it includes headers and other information you wish to ignore. The tool can also archive the CSV file into a folder once it has been successfully imported into the database. You can schedule the application to run automatically by calling the executable in a batch file with a configuration file. You can run multiple instances of the .NET application if you need to import large numbers of files in parallel.

Please contact us if you are interested in automatically importing CSV data into a database automatically.



New Excel Import Tool

A client recently had a requirement to automatically import data from excel files into their database on a daily/weekly basis. Today we are pleased to annouce the release of a new Excel Import Tool which does exactly that.

The Excel Import Tool enables you to automatically import all data from an excel file into an MSSQL & Oracle database. The tool allows you to configure the folder, file name (begins with), tab name and of course the destination table name. The tool also imports the values from cell formulas and you also have the option to ignore the first row if it includes headers. The tool can also archive the excel file into a folder once it has been successfully imported into the database. You can schedule the application to run automatically by calling the executable in a batch file with a configuration file. You can run multiple instances of the .NET application if you need to import large numbers of files in parallel.

Please contact us if you are interested in automatically importing excel data into a database automatically.



New Dashboard Functionality: Pivot-grid Chart

We are always trying to add more functionality to our dashboard pages and at the same time improve performance. However, increased functionalty often results in decreased performance. Today we are pleased to announce a new dashboard control which adds a huge amount of functionality while at the same time providing very fast load times.

If you preview this example you will see a simple page which includes a chart and many filters in the header. What you don't see is that the page includes more than 22,000 rows of data and a huge amount of functionality for the end-user. You can now filter on many multi-select filters and even a free text filter which queries all applicable fields. When you apply a filter, the chart will automatically refresh. You can hover over any bar to get additional details. You can also click any bar, category description or legend item to open the drill-down data grid for the applicable data. The drill-down grid also has many features including vertical & horizontal scrolling, filters and instant export to excel. This dashboard page is created with our new ADD (Auto data deploy) in less than 5 seconds. The page includes several javascript components from Devexpress such as dxChart, dxPivotGrid & dxGrid.

Please contact us for a free demo and discussion.



New Dashboard Generator: ADD (Auto Data Deploy)

We are pleased to announce the release of our new dashboard generator: ADD (Auto Data Deploy).

ADD enables you to connect to your on-premise MSSQL & Oracle databases and automatically populate existing HTML templates. HTML templates can include powerful javascript libraries which enable you to present your data in charts, grids and pivot tables. This provides your users with the necessary tools to interact with your business data with filters, sorting & grouping controls, tooltips and drill-down. Since all pages are static there is zero risk of anyone gaining unauthorized access to your databases and load times are almost instant.

ADD also supports single-pass bursting. Bursting enables you to automatically create separate HTML pages based on a subset of the data. For example you may need to create separate HTML pages per country, region, department, customer or sales person. ADD handles data bursting in a very efficient way and can export separate HTML pages in just milliseconds. This means you can refresh and upload an entire website very quickly. It is also quick and easy to automatically refresh your HTML pages, simply setup a windows schedule task to run the ADD processes. You may choose to refresh your HTML pages every 15 minutes, hourly, daily or monthly. You can run multiple instances of the .NET application if you need to export large numbers of HTML files in parallel.

Please contact us if you are interested in implementing auto-refreshing static html pages.