Page 1 of 2

HTML Report - is there a reason nobody cares?

PostPosted: Mon Aug 02, 2021 8:07 am
by Otto
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

Re: HTML Report - is there a reason nobody cares?

PostPosted: Mon Aug 02, 2021 8:55 am
by anserkk
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

Re: HTML Report - is there a reason nobody cares?

PostPosted: Mon Aug 02, 2021 9:26 am
by joseluispalma
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.

Re: HTML Report - is there a reason nobody cares?

PostPosted: Mon Aug 02, 2021 9:36 am
by Marc Vanzegbroeck

Re: HTML Report - is there a reason nobody cares?

PostPosted: Mon Aug 02, 2021 10:37 am
by Enrico Maria Giordano
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

Re: HTML Report - is there a reason nobody cares?

PostPosted: Mon Aug 02, 2021 12:52 pm
by Otto
@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: Select all  Expand view
    // 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 &lt;time&gt; 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

Re: HTML Report - is there a reason nobody cares?

PostPosted: Mon Aug 02, 2021 2:18 pm
by Marc Vanzegbroeck
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

Re: HTML Report - is there a reason nobody cares?

PostPosted: Mon Aug 02, 2021 2:25 pm
by Otto
Hello Marc,
to your company address.
I resend it.
Best regards,
Otto

Re: HTML Report - is there a reason nobody cares?

PostPosted: Mon Aug 02, 2021 2:36 pm
by Marc Vanzegbroeck
Otto,

I didn't received anything.

Did you send it to marc at vms dot be ?

Re: HTML Report - is there a reason nobody cares?

PostPosted: Mon Aug 02, 2021 3:10 pm
by Enrico Maria Giordano
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

Re: HTML Report - is there a reason nobody cares?

PostPosted: Mon Aug 02, 2021 3:14 pm
by Otto
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: Select all  Expand view
   // 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 &lt;time&gt; 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.)



Image

Re: HTML Report - is there a reason nobody cares?

PostPosted: Mon Aug 02, 2021 3:24 pm
by Otto
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

Re: HTML Report - is there a reason nobody cares?

PostPosted: Mon Aug 02, 2021 3:28 pm
by Marc Vanzegbroeck
Otto,

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

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

Re: HTML Report - is there a reason nobody cares?

PostPosted: Mon Aug 02, 2021 3:29 pm
by joseluispalma
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

Re: HTML Report - is there a reason nobody cares?

PostPosted: Mon Aug 02, 2021 3:31 pm
by Enrico Maria Giordano
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