Greetings!
I'm new here and want to develop a billing software for my dad.
He's a legal consultant at various industries and charges particular amount monthly to the clients every month.
I want to develop a software which generates bill in PDF Format or Word with the help of any DBMS.
Kindly Support
Hi Sharan,
I'm sorry but I can't see an easy way to programmatically generate a PDF or Word document using HyperNext as their internal formats are quite complex. On the plus side, HyperNext does have MySQL functionality though.
However, a HyperNext program could indirectly create a PDF or Word file, by printing a client's bill to the printer driver that is set up to create a PDF or Word document, although this is clumsy.
I've tester this with the trial version of a printer driver called
Print to Word that can actually create a Word document using HyperNext but its very clumsy as described below.
HyperNext prints to the driver which then opens up a
Printer to Word dialog box asking where the file should go. The
Windows OS printer dialog can be skipped using the
PrinterOpenDefaultFN function.
This code if from the HyperNext Printing project.
@If pageSetup=1 Then
Put PrinterOpenDefaultFN(0) into printOkay
Put printOkay into field 1
If printOkay=1 Then
PrinterTest
EndIf
@EndIf
Note, the Print to Word driver creates the word document correctly but always launches Microsoft Word. Perhaps there is a way around this.
Note, you can find the Print to Word driver below although the trial versions just prints the first two pages of a document.
http://www.bullzip.com/products/ptw/info.php Regarding programmatically converting text to a PDF or Word file, these websites show how complex it is, if you are writing the code yourself:-
https://blog.idrsolutions.com/2013/01/understanding-the-pdf-file-format-overview/#helloworldhttps://msdn.microsoft.com/en-us/library/bb264572(office.12).aspxBy the way, some other programming languages such as C# and Java can use libraries for programmatically converting text to PDF or Word.
Malkom
