FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour HTML Report - is there a reason nobody cares?
Posts: 6984
Joined: Fri Oct 07, 2005 07:07 PM
HTML Report - is there a reason nobody cares?
Posted: Mon Aug 02, 2021 08:07 AM

Hello friends,
Is there a reason why - apart from a lack of time - nobody is seriously interested in HTML as a report definition language here?

Sometimes you yourself believe that something is good and overlook things in the process.

I look forward to your feedback.

Best regards,
Otto

Posts: 1335
Joined: Fri Jun 13, 2008 11:04 AM
Re: HTML Report - is there a reason nobody cares?
Posted: Mon Aug 02, 2021 08:55 AM

I am not very much clear about the concept of HTML report.
The tools required to create the HTML report ?
The tools required to view/display the HTML report inside the FiveWin application ? Maybe using Shellexecute( NIL, "open", cHtmlFile )

From the scattered information available in this forum, what I understand is that we have to prepare a template in html format first (maybe using Word or some HTML editors) and later from the application we replace the data using StrTran() in the HTML file. If it is so, how do we prepare an invoice in HTML where the number of line items are dynamic ? (May be inserting a whole table itself onto the HTML )

I am not sure whether I understood the concept correctly

Posts: 109
Joined: Mon Apr 30, 2012 09:10 AM
Re: HTML Report - is there a reason nobody cares?
Posted: Mon Aug 02, 2021 09:26 AM

Hello Otto,

Thank you very much for your efforts, but I don't see it useful. The customer wants to be able to customize reports and documents. That is what a WYSIWYG type editor like Word, Easy Report or FastReport allows. That is the dominant direction of the FWH community.

Thank you.

Posts: 1195
Joined: Mon Oct 17, 2005 05:41 AM
Re: HTML Report - is there a reason nobody cares?
Posted: Mon Aug 02, 2021 09:36 AM
Regards,

Marc



FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite
Posts: 9022
Joined: Thu Oct 06, 2005 08:17 PM
Re: HTML Report - is there a reason nobody cares?
Posted: Mon Aug 02, 2021 10:37 AM
Otto wrote:Hello friends,
Is there a reason why - apart from a lack of time - nobody is seriously interested in HTML as a report definition language here?

Sometimes you yourself believe that something is good and overlook things in the process.

I look forward to your feedback.

Best regards,
Otto


I'm already using HTML to print reports from web applications since years. For desktop I prefer FWH TPrinter and TReport, maximum power and versatility.

EMG
Posts: 6984
Joined: Fri Oct 07, 2005 07:07 PM
Re: HTML Report - is there a reason nobody cares?
Posted: Mon Aug 02, 2021 12:52 PM
@Anser
Dear Anser,
Thank you for your contribution, and greetings from us to all of you.
Has Ayen started programming?

I can't describe it better.

page break

I solve the page break similar to EasyReport.
I specify an area height and then count the loops and make a break when it is reached.
Code (fw): Select all Collapse
    // insert a table
    cHtml += memoread("table_th.htm")
    for I := 1 to 25
        if I = 10
            cText := "</table>" + CRLF 
            cText += "<div style='page-break-after: always;'></div>" + CRLF 
            cText += "<div>&nbsp;" + CRLF 
            cText += "</div>" + CRLF 
            cText += "<table>" + CRLF 
            cText += "Second page (This will be printed in the second page)" + CRLF
            cHtml += cText
        endif
    
        cText := "<tr>" + CRLF
        cText += "<td>Nr. " + str(I) + "</td>" + CRLF
        cText += "<td>Represent a machine-readable format of the <time> element</td>" + CRLF
        cText += "</tr>" + CRLF   
        cHtml += cText
    next
    
    cHtml += memoread("table_end.htm")
    
    cText := "<div style='break-after:page'></div>" + CRLF 
    
    cText += " page (This will be printed in the second page)" + CRLF
    cHtml += cText
    memowrit(cHtmlOrUrl, cHtml)
    
    PrintHtml(cHtmlOrUrl,1,.t.)

But I think that if Cristobal releases the Edge based web control, then you can easily check it with javascript.

With HTML as output format for the reports, you can easily do everything with standard software.
Open with WORD and export to EXCEL, ...

@Jose
You can also use a designer with HTML. There are so many options here that one currently has the problem of choosing the best (online-offline) and easiest option.
Take the invoice that Leandro posted. Do you really seriously believe that you can let an end user get in with the WYSIWYG editor and make changes?

@Mark, I sent you my email address yesterday. Just send me the test - prg.

@Endico, "maximum power and versatility" that's just an assertion that you have to prove in a comparison and competition. :-)
I know you are a superb web programmer.

Let's make a list of the appearance of the reports, simplicity of the source code, time it takes to create the reports, etc. and start the race.

Best regards,
Otto
Posts: 1195
Joined: Mon Oct 17, 2005 05:41 AM
Re: HTML Report - is there a reason nobody cares?
Posted: Mon Aug 02, 2021 02:18 PM
Otto,

Where did you send you your email to?

Otto wrote:@Anser


@Mark, I sent you my email address yesterday. Just send me the test - prg.


Otto
Regards,

Marc



FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite
Posts: 6984
Joined: Fri Oct 07, 2005 07:07 PM
Re: HTML Report - is there a reason nobody cares?
Posted: Mon Aug 02, 2021 02:25 PM

Hello Marc,
to your company address.
I resend it.
Best regards,
Otto

Posts: 1195
Joined: Mon Oct 17, 2005 05:41 AM
Re: HTML Report - is there a reason nobody cares?
Posted: Mon Aug 02, 2021 02:36 PM

Otto,

I didn't received anything.

Did you send it to marc at vms dot be ?

Regards,

Marc



FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite
Posts: 9022
Joined: Thu Oct 06, 2005 08:17 PM
Re: HTML Report - is there a reason nobody cares?
Posted: Mon Aug 02, 2021 03:10 PM
Otto wrote:@Endico, "maximum power and versatility" that's just an assertion that you have to prove in a comparison and competition. :-)


I already prove it because, as I said, I've been using HTML for years to write reports for web applications. At least to me, FWH TPrinter and TReport are the best for desktop applications.

EMG
Posts: 6984
Joined: Fri Oct 07, 2005 07:07 PM
Re: HTML Report - is there a reason nobody cares?
Posted: Mon Aug 02, 2021 03:14 PM
Hello Marc,
can't you answer the mail where I sent you the program first?
Anyway it ist otto at atzwanger dot com

Best regards,
Otto

I attach the picture from page-break here. I forgot in my previose post.

Code (fw): Select all Collapse
    // insert a table
    cHtml += memoread("table_th.htm")
    for I := 1 to 25
        if I = 10
            cText := "</table>" + CRLF
            cText += "<div style='page-break-after: always;'></div>" + CRLF
            cText += "<div>&nbsp;" + CRLF
            cText += "</div>" + CRLF
            cText += "<table>" + CRLF
            cText += "Second page (This will be printed in the second page)" + CRLF
            cHtml += cText
        endif
   
        cText := "<tr>" + CRLF
        cText += "<td>Nr. " + str(I) + "</td>" + CRLF
        cText += "<td>Represent a machine-readable format of the <time> element</td>" + CRLF
        cText += "</tr>" + CRLF  
        cHtml += cText
    next
   
    cHtml += memoread("table_end.htm")
   
    cText := "<div style='break-after:page'></div>" + CRLF
   
    cText += " page (This will be printed in the second page)" + CRLF
    cHtml += cText
    memowrit(cHtmlOrUrl, cHtml)
   
    PrintHtml(cHtmlOrUrl,1,.t.)



Posts: 6984
Joined: Fri Oct 07, 2005 07:07 PM
Re: HTML Report - is there a reason nobody cares?
Posted: Mon Aug 02, 2021 03:24 PM

Hello Enrico,
I am sorry I was too fast with my answer.
I deleted my post.
I read your post again, and you write "At least to me".
OK.

Best regards,
Otto

Posts: 1195
Joined: Mon Oct 17, 2005 05:41 AM
Re: HTML Report - is there a reason nobody cares?
Posted: Mon Aug 02, 2021 03:28 PM
Otto,

I think you are mistaking with someone else. I Think you mean Marc Venken, that's another Marc from Belgium :-)

I will send you the test-prg by email.

Otto wrote:Hello Marc,
can't you answer the mail where I sent you the program first?
Anyway it ist otto at atzwanger dot com

Best regards,
Otto
Regards,

Marc



FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite
Posts: 109
Joined: Mon Apr 30, 2012 09:10 AM
Re: HTML Report - is there a reason nobody cares?
Posted: Mon Aug 02, 2021 03:29 PM

Hello Otto,

Our users have been doing this for many years with FastReport. The problem is that it does not work on 64-bit applications and we would like to have technological sovereignty over all our source code.

Regards

Posts: 9022
Joined: Thu Oct 06, 2005 08:17 PM
Re: HTML Report - is there a reason nobody cares?
Posted: Mon Aug 02, 2021 03:31 PM
Otto wrote:Hello Enrico,
I am sorry I was too fast with my answer.
I deleted my post.
I read your post again, and you write "At least to me".
OK.


Best regards,
Otto


No problem. Anyway, I'm always open to change my mind for a better tool. Only, "better" is a very poorly defined word... :-)

EMG