HTML Report - is there a reason nobody cares?

[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

[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

[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.

[Marc Vanzegbroeck]

Otto,

The problem is that I get an error in Printhtml.

http://forums.fivetechsupport.com/viewtopic.php?p=243266&sid=c96dcc6d09f9b884a29d473937c95e50&sid=91489e458c70ad38c9bd4a2de82514e9#p243266

[Enrico Maria Giordano]

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

[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

    // 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

[Marc Vanzegbroeck]

Otto,

Where did you send you your email to?

@Anser


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


Otto

[Otto]

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

[Marc Vanzegbroeck]

Otto,

I didn't received anything.

Did you send it to marc at vms dot be ?

[Enrico Maria Giordano]

@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

[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

    // 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.)

[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

[Marc Vanzegbroeck]

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.

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

[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

[Enrico Maria Giordano]

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