Advance Options

In reality, to make own report depend on many elements. Partly because of conditions of fields, other depend on structure of reports and source of datas...Add-in A-Tools supply helful options such as: HR, INSERT, DBKEY, SERVERSOURCE
Ex: BS_SQL("SELECT * FROM INVENTORY","HR=NO;INSERT=YES;DBKEY=NAME;")
HR: Default is HR=YES. If your reports are set header, you add options HR=NO
INSERT: Default is INSERT=NO. If your reports are set footer, you want rows of report  to line spacing automatically. You add options INSERT=YES
DBKEY: Not default. This options use when you need excel to get data from other database such as: Other Excel files, Access, FOXPRO, SQL Server, MySQL, Paradox, Oracle...
SERVERSOURCE: Not default. This options use when you get data to excel from other personal computer or server via local network or internet by TCP/IP.