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 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 read more about CR Dispatch by downloading the user manual.
You can also see a quick demo of the application in action here.
Please contact us if you are interested in purchasing a licence 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 travelling 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 synchronised 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 syncronization 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 syncronized to the client, they will be unzipped automatically and your old files will be refreshed. It is always much faster syncronizing 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 tranferred 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 2,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.