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.
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.
Read more reviews and testimonials
EXSION SQL offers
solutions for your problems
Read below what controllers run into and what solution Exsion SQL offers.
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?
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.