Author Topic: Develop a proper Billing Software using HyperNext and DBMS  (Read 93 times)

sharan

  • Newbie
  • *
  • Posts: 1
Develop a proper Billing Software using HyperNext and DBMS
« on: October 18, 2017, 11:36:11 AM »
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

Malkom

  • Administrator
  • Newbie
  • *****
  • Posts: 371
  • Here to help you
Re: Develop a proper Billing Software using HyperNext and DBMS
« Reply #1 on: October 18, 2017, 02:20:54 PM »
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.

Code: [Select]
@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/#helloworld

https://msdn.microsoft.com/en-us/library/bb264572(office.12).aspx


By the way, some other programming languages such as C# and Java can use libraries for programmatically converting text to PDF or Word.
 
Malkom

« Last Edit: October 18, 2017, 02:43:05 PM by Malkom »
I am sorry but I do not have time to answer questions by PM or email.
If you post your questions in this forum then it might help others.