Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 267 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Query and Excel Report - Practice
Administrator
Member, Moderator, Administrator Posts: 2,496
Query and Excel Report - Practice
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 directly make real time reports 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.
- Retrieve data from multiple companies.
- 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 NAV objects at http://www.mibuso.com/dlinfo.asp?FileID=1591
and download introduction video at http://www.mibuso.com/dlinfo.asp?FileID=1589
or watch introduction video at https://www.youtube.com/watch?v=d-ZpkulWojU
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.
This 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
http://www.mibuso.com/dlinfo.asp?FileID=1600
Discuss this download here.
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 directly make real time reports 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.
- Retrieve data from multiple companies.
- 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 NAV objects at http://www.mibuso.com/dlinfo.asp?FileID=1591
and download introduction video at http://www.mibuso.com/dlinfo.asp?FileID=1589
or watch introduction video at https://www.youtube.com/watch?v=d-ZpkulWojU
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.
This 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
http://www.mibuso.com/dlinfo.asp?FileID=1600
Discuss this download here.
0