Add-in A-Tools can create dynamic reports by using the functions to query the database (DB) with T-SQL language. This is the best function helf users who are not good about VBA. In other hand, about speed of BS_SQL function faster than using Excel's functions and VBA. 
Bs_SQL Function features:
- Make report (unlimited column and rows) with only one function
- The result of this functions is text -> Helf reduce capacity, speed up workbooks
- In BS_SQL function can combine with many supporting funtions such as: Sum, AVG, Count, Max, Min, VTC, recno, top, distinct....
- Users can creat BS_SQL function by dragging and dropping
- User able to use both of  VBA of Excel and use programming library of A-Tools
- And more advance in BS_SQL function otpions: Connect to other databases, use BS_SQL function online, Auto or not creat headers, auto or not creat names, auto or not insert rows....
BS_SQL Structure:
=BS_SQL("Select List_fields from Name_Data where Conditional Group by List_fields_groups Having List_Number_fields Order by List_Number_Fields","Optional")
List_Fields: All fields (*), list_fields are seperated by comma (,)
Optional: HR=NO; INSERT=YES; DBKEY=NAME_DBKEY; SERVERSOURCE=YES....


0 Comment:

Đăng nhận xét

Excel Thỉnh Vũ. Được tạo bởi Blogger.