Tally Customization

Using the ODBC you Can access the Data From External Database Like Excel,Access,sql,sql server,oracle etc. In TDL, Collection is a definition which holds the data. Collection Definition has a capability to gather the data from the external data source through ODBC. if You want To access to Data form Excel then you use following Step- 1) You Make Excel sheet for And Fill Data for your Requrement.      Example -            in this Excel Sheet There re Three filed  first Emp_Name ,Address,Mobile No you can Access the all information in tally. Step 2- In TDL you Make a collection.using following syntax.      [Collection : Name Of Callection]       ODBC   :  you write Driver information Hear.       sql         :  you write sql syntax.

Step 1-  you create the Tally user with Blank password [#Field: SVCUserName] Set as : "a" On : Focus : Yes : Trigger Key : Enter,Enter

Introduction A Variable is a storage location or entity. It is a value that can change, depending on the conditions or on the information passed to the program. In TDL, a Variable is one of the important definitions since it helps control the behavior of Reports and their contents. Variables assume different values during execution and these values affect the behavior of the Reports A Variable definition is similar to any other definition. Syntax [Variable: ] Attribute : Value A Variable should be given a meaningful name which determines its purpose.