Tally Chapter 195 TDL for All in 1 Export Buttons By Rajiv Mishra Computer Class

 

Few lines are missing here.

Pls watch the full video to get full coding

;;-----------------All in 1- EXPORT-----

[#Form: Purchase Color]

Add : Button : InvPDF, InvXml, InvXls

[Button : InvPDF]

Title : "Save As PDF"

Key : Alt + F

Action : call : SaveAsPDF

[Button : InvXml]

Title : "Save As Xml"

Key : Alt + X

Action : call : SaveAsXml

[Button : InvXls]

Title : "Save As Excel"

Key : Alt + C

Action : call : SaveAsXls

[Function : SaveAsPDF]

10: SET : SVExportLocation : "C:\Users\User\Desktop\Daily"

20: SET : SVExportFormat : $$SysName:pdf

30: Set : SVPrintFileName : $$String:$Vouchertypename+"_"+$$String:$vouchernumber

40: SET : SVPrintFileName : $$MakeExportName:##SVPrintFileName:##SVExportFormat

50: Set : SVPrintFileName :##SVExportLocation+"\"+#SVPrintFileName

60: EXPORT REPORT : . : TRUE

[Function : SaveAsXml]

10: SET : SVExportLocation : "C:\Users\User\Desktop\Daily"

20: SET : SVExportFormat : $$SysName:xml

30: Set : SVPrintFileName : $$String:$Vouchertypename+"_"+$$String:$vouchernumber

40: SET : SVPrintFileName : $$MakeExportName:##SVPrintFileName:##SVExportFormat

50: Set : SVPrintFileName :##SVExportLocation+"\"+#SVPrintFileName

60: EXPORT REPORT : . : TRUE

[Function : SaveAsXls]

10: SET : SVExportLocation : "C:\Users\User\Desktop\Daily"

20: SET : SVExportFormat : $$SysName:xls

30: Set : SVPrintFileName : $$String:$Vouchertypename+"_"+$$String:$vouchernumber

40: SET : SVPrintFileName : $$MakeExportName:##SVPrintFileName:##SVExportFormat

50: Set : SVPrintFileName :##SVExportLocation+"\"+#SVPrintFileName

60: EXPORT REPORT : . : TRUE

;;-----------DB-----------

[#Form: Daybook]

Add : Button : InvPDF1, InvXml1, InvXls1

[Button : InvPDF1]

Title : "Save As PDF"

Key : Alt + F

Action : call : SaveAsPDF1

[Button : InvXml1]

Title : "Save As Xml"

Key :  CTRL + 1

Action : call : SaveAsXml1

[Button : InvXls1]

Title : "Save As Excel"

Key : CTRL + E

Action : call : SaveAsXls1

[Function : SaveAsPDF1]

10: SET : SVExportLocation : "C:\Users\User\Desktop\Daily"

20: SET : SVExportFormat : $$SysName:pdf

30: Set : SVPrintFileName : $$String:$Vouchertypename+"_"+$$String:$vouchernumber

40: SET : SVPrintFileName : $$MakeExportName:##SVPrintFileName:##SVExportFormat

50: Set : SVPrintFileName :##SVExportLocation+"\"+#SVPrintFileName

60: EXPORT REPORT : . : TRUE

[Function : SaveAsXml1]

10: SET : SVExportLocation : "C:\Users\User\Desktop\Daily"

20: SET : SVExportFormat : $$SysName:Xml

30: Set : SVPrintFileName : $$String:$Vouchertypename+"_"+$$String:$vouchernumber

40: SET : SVPrintFileName : $$MakeExportName:##SVPrintFileName:##SVExportFormat

50: Set : SVPrintFileName :##SVExportLocation+"\"+#SVPrintFileName

60: EXPORT REPORT : . : TRUE

[Function : SaveAsXls1]

10: SET : SVExportLocation : "C:\Users\User\Desktop\Daily"

20: SET : SVExportFormat : $$SysName:Excel (Spreadsheet)

30: Set : SVPrintFileName : $$String:$Vouchertypename+"_"+$$String:$vouchernumber

40: SET : SVPrintFileName : $$MakeExportName:##SVPrintFileName:##SVExportFormat

50: Set : SVPrintFileName :##SVExportLocation+"\"+#SVPrintFileName

60: EXPORT REPORT : . : TRUE