Search
You are here
Execute SQL in Excel and create dynamic report
Query, Share and Manage Excel workbooks on LAN, Internet
HOME
PRODUCTS
Add-in A-Tools Query, Share Excel file on LAN, internet with multiple users
Bluesofts ActiveX Controls (BSAC) for VBA programming
QuickCSV - Merge and split multiple CSV, JSON, TXT, EXCEL data files
Add-in AccHelper - Number to words (Đọc số thành chữ)
BS QRcode Creator
BS Barcode to PC
TUTORIAL
Tutorial - Documents
Video Tutorials
Tips
PURCHASE
PURCHASE ONLINE
ORDER
DOWNLOAD
Download Add-in A-Tools - Share Excel file on LAN, Internet, Query data on worksheet
Download BSAC ActiveX Controls
Download QuickCSV - Merge and split multiple CSV, JSON, TXT, EXCEL
BS QRcode - Tạo QRcode cho chuyển tiền nhanh và chuỗi bất kỳ
FAQS
SUPPORT
LEARN EXCEL & VBA
Excel Tips
VBA Programming
Program VBA with BSAC activex
Microsoft Excel 2007 Tutorials
Tech info
Android Tips
Add-in A-Tools Programming
Program function
Program network: Client-Server
Skip to content
Execute SQL in Excel and create dynamic report
Title Filter
Display #
5
10
15
20
25
30
50
100
All
#
Article Title
1
Create dynamic report support drill-down with BS_SQL function
2
Lesson 02 - Creating Dynamic Reports in Excel and Add-in A-Tools
3
Lesson 01 - Creating Dynamic Reports in Excel and Add-in A-Tools
4
Create report with column split combining IN and VTC in BS_SQL function
5
Creating group reports with multiple levels in Excel and A-Tools Lesson 1
6
Function GROUP_CONCAT in BS_SQL to join value each group
7
Function BS_JOIN Merge multiple sheets and multiple Excel files into spreadsheet
8
Function BS_SQL retrieves data from another computer in the network
9
Create dynamic report with Query Table in SQL Builder
10
Hướng dẫn tạo báo cáo động Query Table trong Excel và Add-in A-Tools
Page 1 of 2
«
Start
Prev
1
2
Next
End
»
A-Tools Articles
How to register Add-in A-Tools Pro
How to start server with Add-in A-Tools in Microsoft Excel
Server set up and client permissions in Excel and Add-in A-Tools
Client connect to the server in Excel and Add-in A-Tools
How to restore lost in Add-In A-tools toolbar in Microsoft Excel
Advanced Input, Dropdown List - Select list with multi columns, filter, date
List of extension functions in Add-In A-Tools in Microsoft Excel
Download and set up Add-in A-Tools
Setup Add-in A-Tools
Advanced Input - Drop down list find and filter
Execute SQL in Excel and create dynamic report
Share Excel online with restrict rights users
Function return Dynamic array
Database functions
Color functions
Accounting functions
Extended functions
Excel connect to external database
Create formula array of Excel by click Formula Builder - Mouse click only
Settings in A-Tools Options
Add-in A-Tools Function Programming
Add-in A-Tools Network Programming
Sync data from Excel to Google Sheets by Add-in A-Tools
Sync data from Excel to Excel online by Add-in A-Tools