Query and Excel Report (for NAV2013 to NAV2017)

As you know Microsoft Excel has tremendous capabilities such as Formula, Chart, Power Pivot, Slicer, and Condition Format ... help you build stunning dashboards and reports. Now with our solution, user without programming skill can push data to Excel and make real time reports directly from Microsoft Dynamics Navision. Below is "Query and Excel Report" functionality:
- User interaction or prepare reports silently.
- Capacity of using pre-built Excel template.
- Distribute reports through email automatically.
- Report built-in security by standard NAV Role and Permission, and report owner.
- Ability to share reports to other users in same company or using different NAV systems.
- Support aggregation functions such as Group, Summary, Count, Average, Max, and Min.
- Capacity to sort and keep top rows for reports such as Top 10 Customer, Top 20 Item.
- Support joins tables for linking information, Report Parameter for filtering.
- Multiple Excel Worksheets, Format Value, Format Cell, Column Width support.
- Support Web client, export report data to XML with or without Schema.

You can download demo video at http://mibuso.com/downloads/query-and-excel-report-nav2013-video

Update 14/04/2017:

• Optimize and new special value in Excel Cell Value as Text.
• New Values Lookup page to assist edit Filter Expression and Parameter Value.
• New feature: check and Swap Link Field function in Filter Part.
• New feature: duplicate Structure by Companies function.
• New feature: open XML file with.
• New feature: notes and links for Report Definition.
• New feature: incremental Excel Template.
• New feature: dynamic Output Filename.
• New feature: opposite Sign.

Update 15/08/2016:

• Optimize tool to increase performance.
• Edit tool for NAV Limited User License Type to save NAV License Cost.
• Enable Partners to localize tool, all use captions instead of names.
• Combined License, simpler management for both Partners and Customers.
• More interactive dialog status allows users to stop report at any time.
• Support lookup data and select available values in Filter Expression.
• Review Filters on Run allows users to review desired Parameters and Filters.
• Import report definition with existing check, and let user decide what to do.
• New way of Table Alias and Field Alias suggestion based on caption.
• More meaningful with new way of parsing Excel Cell Value as Text.

Update 15/03/2016:

• Navision objects for version 9.0 (2016).
• Align with new Library to increase performance.
• New videos on creating Document Layout Excel Report and Wizard.

Update 13/09/2015:
- Unlimited Pack Trial to 30/11/2015.

Update 10/07/2015:
- Trial to 30/11/2015.

Update 14/03/2015:
1. New feature: Report by Wizard, including select Tables, Fields and arrange Fields.
2. Change Tables 56201, 56202 to 50008, 50009 - Excel Report Header and Line.
3. Make data of Tables 50008, 50009 visible to all companies.
4. Related videos at https://www.youtube.com/playlist?list=PLfgzNr8_2Gkp8o589mH7XLFqEUBywciry

Update 01/11/2014:
- Support version 8.0 (2015)

Update 28/09/2014:
New features:
- Hide % completed status to increase speed.
- Retrieve data from multiple companies.
- Table Alias Cell Reference with Row and Column Offset.
- Field as Excell Cell Text Value in Fields part.
- Parameter Formula with DateFormula.
- Duplicate and delete multiple reports in list page.

Changes:
- Change Codeunit ID from 50041 to 50008
- Excel Report Management.
- Field Display Name is unique within Group of Top Table only.

Introduction video content:
- Introduction.
- Installation.
- Create Top 10 Customers Report.
- Select Tables and Fields.
- Link Tables and Filters.
- Sort and Keep top rows.
- Excel Pivot, Chart and Slicer.
- Create report from Excel Template.
- Email report.
- Create and Email report automatically by NAS Service.
- Download at Mibuso http://www.mibuso.com/dlinfo.asp?FileID=1589
- Watch at Youtube https://www.youtube.com/watch?v=d-ZpkulWojU

Practice video content:
- PRACTICE-01 Customer Sales
- PRACTICE-02 Customer Sales with Filter
- PRACTICE-03 Customer Top Sales
- PRACTICE-04 Customer Top Sales with %
- PRACTICE-05 Customer Salesperson Sales
- PRACTICE-06 Sales Consolidation
- PRACTICE-07 Sales Consolidation and Total
- PRACTICE-08 Gross Sales by Time
- PRACTICE-09 Gross Sales by Time Summary
- PRACTICE-10 Gross Sales & Return by Time

- Download at Mibuso http://www.mibuso.com/dlinfo.asp?FileID=1600
- Watch at Youtube https://www.youtube.com/watch?v=pRXY7aZMcz4