Exsion Reporting SQL

Reportage

No matter the structure of your Microsoft SQL database, Exsion SQL allows you to create reports and lists in Excel.

Features Exsion SQL

One of the features we are proud of is that you can get all the data from your database in Excel. The strength of Exsion Reporting is that you can work with data descriptions that are recognizable to you.

Simple Excel reporting

Exsion Reporting makes it possible for each controller to create reports.

Recognizable user data

Names of tables and data are recognizable names for users.

Combine all your data

What we are proud of is that you can get all the data from your database in Excel.

Refreshing of reports

Refresh again and again, so that your report contains up-to-date information.

Quick data refresh

Exsion Reporting is designed to make it easy to gain insight into your business.

Reporting after training

For most reports, one day's training is enough. Also for advanced users.

Testimonials

Reports are very easy to modify

Exsion is very simple and easy to use. Reports are very easy to edit. Exsion seamlessly connects to NAV. You can just pick up what's inside. And that function to retrieve it is very simple and just works. Then you can use Excel formulas with data. Exsion is really well put together.

Gebroeders Blokland

Exsion is for making reports a no-brainer

We have been working with Exsion for over 10 years. We find the program very user-friendly. The use of Exsion for making reports and composing NAV-downloads is a no-brainer. Do it right away.

Cogentix Medical

More reviews

Read more reviews and testimonials

EXSION SQL offers
solutions for your problems

Read below what controllers run into and what solution Exsion SQL offers.

  • No data from Microsoft SQL database

    I am not getting any data from my Microsoft SQL database. View problem and solution

  • Do not select any data

    I can't select any data. View problem and solution

  • Cut and paste

    I cut and paste a lot to get everything right. See problem and solution

  • Hiring expensive consultants

    I have to hire expensive consultants to change a report. View problem and solution

  • Waiting a long time

    I always have to wait a long time for the data to finally be generated. View problem and solution

  • No help

    When I ask for help, I never get an answer or it's too late. View problem and solution

  • Installation is difficult

    The installation of the software is complex, takes a long time and is error-prone. View problem and solution

Your problem

I don't get any data from my Microsoft SQL database

You may have a financial administration, or a custom application that uses Microsoft SQL. The tricky thing is, you can't create reports without pasting and cutting, or you have to learn a query language.

No expensive consultant

You can call a consultant or work with PowerBI, but the first is expensive and the second is complicated.

Exsion's solution

With Exsion you can easily transfer your selected data to Excel.

The power of Exsion Reporting is that you only need to know which data you want to combine in your report. You click on it in Exsion and it will ask you a question to the database without you having to worry about it. The data is stored in Excel, so you can edit it as well.

Your problem

I can't select any data

If you want to analyse your business properly or make a simple list, you'd prefer to combine all the data as you see fit. AX is great for filtering, but it is difficult to combine data from different screens. This is also difficult with other tools available on the market.

Exsion's solution

You can use the download to select the data yourself

The power of Exsion Reporting for SQL is that you can really combine the data you choose. We call that making a download. The advantage of a download is that it is not an export. You have to make an export over and over again and you can't make a selection.

Download endlessly usable and customizable

Once the download has been created, you can use it endlessly and make any changes or filters you want.

Your problem

I have to work with cutting and pasting to get everything right

You may be able to create an Excel export from within the application, but you will need to paste and cut to get the set you want. You have to do that over and over again. This is work that doesn't make you happy. It is a lot of executive work, takes a lot of time and remains error-prone. In addition, you always have to save your versions separately and comparing data over a period of time is very difficult.

Exsion's solution

After you have made a download, all you have to do is press the Refresh button

With Exsion Reporting you don't have to paste and cut anymore. With the download definition you have your report ready, even for all future times you want to use it. Pressing the Refresh button updates your report without pasting and cutting, so it's up to date and error-free.

No more separate Excel versions

Because you get the data directly from the database. Use Excel for what you need to use it: arithmetic. And the database for data. Your work gets complicated when you use Excel to manage a dataset. Unfortunately, a lot of users still do that.

Your problem

I have to hire expensive consultants to change a report.

Standard reports are often already present in standard and custom applications, which are useful. Changing them yourself, however, is very difficult. First of all, if you want to change the dataset, you need to know how BC's complex database works. Secondly, if you want to change the visualisation in a report, for example, you will have to make yourself familiar with the functionality of the tool in question.  If this is not your daily work, it often doesn't pay off.

Exsion's solution

With Exsion you can create your own reports after 1 day of training.

We have sold Exsion to almost 1000 customers. They all had 1 day of training and were able to work with Exsion.

What can I do to learn Exsion Reporting?

You should be handy in Excel, although we will teach you several clever tricks during the course.

Your problem

I always have to wait a very long time for the data to finally be generated

Many tools in the market are slow. That's because of the technology behind it. Data often has to come to the user via links and services.

Exsion's solution

Met Exsion krijg je snel antwoord

We've made Exsion so that it's fast in almost all cases. Indeed, it says almost, because there is a limit to every technology. Our customers are satisfied with Exsion's performance.

What techniques are used to get Exsion Reporting fast?

If we can access the database directly (usually in hosting and on premises), the database will be queried directly and not via a link. This makes Exsion lightning-fast.

Your problem

When I ask for help, I never get an answer, or it's too late.

Everyone knows the misery of approaching a helpdesk. You are connected, you have to wait and your problem is always unique, so it is not easy to solve.

Exsion's solution

You can call the helpdesk and get an immediate answer

If you have a subscription, you can call our helpdesk directly and get an answer. Almost 90% of all calls are resolved immediately.

Your problem

The installation of the software is complex, takes a long time and is error-prone

Some packages take a very time-consuming process to run on your server or tenant, because they consist of many components that work together.

Exsion's solution

The installation of Exsion has been arranged within one part of the day 

The installation of Exsion is a standard process and it never takes longer than a morning or afternoon. We will drop by or install it remotely.

Features and benefits of
EXSION SQL

Take a look at the features and benefits of Exsion SQL

Easily Create Reports in Excel

This product was developed to accommodate clients already working with Exsion Reporting for Dynamics NAV/BC, who also wanted to process data within the same Excel work folder, but who use a different database, based on Microsoft SQL.

Exsion Reporting allows any application administrator to create his/her reports based on the output generated by applications that use a Microsoft SQL database to store their data.

Combining All Data You Have Stored in the Microsoft SQL Database

After installing and configuring Exsion SQL, you can select and download all data.

How to Select Desired Data?

We have created a Wizard for this purpose, a screen that shows the BC/NAV tables on the left. When you click on a table, the data stored within it are shown, which you can subsequentially click to add them to the collection of data you want to incorporate in your report. It is that simple, which you will learn in just one day.

Once Made, Reports Can Be Refreshed Time and Again

Have you ever slogged away at a database export, using cutting or a sort function to select a subset? The next time you want the report, you will have to do the above again, since you want a report containing the latest data. With Exsion Reporting, this tedious work belongs to the past. Once you have created your data selection (what we call a download definition), you can refresh it time and again, thus ensuring your report will contain the latest data.

Refresh Your Data with a Single Button Click

We have built Exsion Reporting in such a way, that you can effortlessly gain better insight into your company. To make the right decisions, you need accurate reports that can be retrieved at any given moment. The Refresh button takes care of this. Once you have created a download definition, you only have to click Refresh to view the latest data.

Exsion Reporting Is Fast

It goes without saying, that once you click the Refresh button, you do not want to wait a long time. We do everything in our power to ensure that Exsion works fast. Of course, every technology has its limitations, but our clients are very satisfied with Exsion’s overall performance. Ergo, you will not be confronted with annoyances and have quick access to your data.

Create Reports After a One-Day Training Course

People often think that creating reports is very difficult. The basis, however, is quite simple, but you can make things as complicated as you like, due to also having all Excel functionality at your disposal. You can use slicers to add a time dimension to your report, create pivot tables to generate beautiful overviews and much more, but let’s drop that for now. Exsion’s basic functionality is fairly straightforward, a one-day training will suffice for creating most reports.

Would you like to expand your Exsion skills? We provide a training for advanced users, very useful if you want to create complex reports or optimise them.

Work with Recognisable Data

Table names and names of data used in the database are often not recognised by users, because they deviate from how users perceive data on-screen.

Exsion Reporting for SQL allows you to translate ‘technical’ names of tables and data to names that users can recognise, which will make creating reports a lot easier.

Want to know more about Exsion SQL?

Curious about Exsion SQL? We'd be happy to show it to you. In the no-obligation Exsion SQL demo, the Exsion team will show you how it works behind the lightning-fast merge of all administrations.

Exsion SQL Demo

You'll see sample reports as you use them and discover why Exsion offers so much flexibility in reporting for such low costs.

Does Exsion SQL work for us?

Want to hear from one of our specialists whether Exsion SQL fits your specific situation or needs? We like to think along with you.

Scroll to Top