Features Exsion SQL
The possibility to transfer all data in your database to Excel, is one of the functionalities we are proud of. The strength of Exsion Reporting is that you can get started yourself, with easily identifiable descriptions of data.
Reports can easily be changed
Exsion is very simple and user-friendly – you can easily change reports. Exsion seamlessly integrates with NAV, you can retrieve all data present in the system. The retrieve function is very easy and it just works. Afterwards, you can get started with Excel formulas. Exsion really is very well-built.
Thanks to Exsion, we now have much more unambiguous data
At a certain point in time, we were very busy with reports for days on end, it was an unworkable situation. In 2008, we switched to Microsoft Dynamics NAV, combined with Exsion and other software, which saved us a lot of time. Thanks in part to Exsion, we now have much more unambiguous data at our disposal.
Janssen de Jong
Read more reviews and testimonials
Exsion SQL provides solutions to your problems
Below, you can read about issues that controllers encounter and solutions that Exsion SQL provides.
Features and benefits of
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?
Are you interested in Exsion SQL? We will happily demonstrate it to you. In our free, no-obligation Exsion SQL demo, the Exsion team will introduce the operation behind the blazingly fast combination of all administrational disciplines.
Exsion SQL Demo
You will see example reports, just like the ones you and your staff use, and will discover how Exsion can provide so much flexibility in reporting at such low costs.
Does Exsion SQL work for us?
Would you like to consult one of our experts whether Exsion SQL matches your specific situation or needs? We will happily contribute ideas and explore the possibilities.