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









टिप्पणियाँ

इस ब्लॉग से लोकप्रिय पोस्ट

Tally Chapter 153 TDL for Custom List of Stock Item By Rajiv Mishra Computer Class

Tally Chapter 105 TDL for Receipt contra Payment BULK Entry by Rajiv Mishra Computer Class

TDL CODE for New Column in Invoice by Rajiv Mishra Computer class