topic-40516

Posts: 6983

Joined: Fri Oct 07, 2005 07:07 PM

HTML reporting system for FIVEWIN
Posted: Thu Jun 10, 2021 08:28 AM

Hello friends,

I think to be able to create HTML reports quickly and easily, a mixed mode is necessary: manual editing and WYSIWYG editor.
I have now tested with OpenOffice. The HTML code created by OpenOffice is lean.

What we need next is a cleaning tool,

We can easily create the tool with Fivewin (memoread().STRTRAN (), memowrit() ).

The big advantage of HTML is that we can use our report layout for both FIVEWIN and modHarbour.

Best regards,
Otto

Silvio.Falconi

Posts: 7317

Joined: Thu Oct 18, 2012 07:17 PM

Re: HTML reporting system
Posted: Thu Jun 10, 2021 08:48 AM

Dear Otto, ( Dear Antonio, Dear Nages , Dear Cris)

I think you should start respecting the forum arguments

this forum is about English Forums ‹ FiveWin for Harbour/xHarbour forum and not for mod_harbour

Please move this topic in the relative section http://forums.fivetechsupport.com/viewforum.php?f=45&sid=f0ddc236fc36d1e397e5afd8ce1d12c8

also because if in the future one wants to look for a topic of Mod_harbour he will not find it in the Mod_Harbour forum but scattered in all the other forums

Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)

I use : FiveWin for Harbour March-April 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com

Otto

Posts: 6983

Joined: Fri Oct 07, 2005 07:07 PM

Re: HTML reporting system
Posted: Thu Jun 10, 2021 09:15 AM

Hello Silvio,

>this forum is about English Forums ‹ FiveWin for Harbour/xHarbour forum

This report generator is for FIVEWIN!
It has nothing to do with mod harbour.

Best regards,
Otto

Silvio.Falconi

Posts: 7317

Joined: Thu Oct 18, 2012 07:17 PM

Re: HTML reporting system
Posted: Thu Jun 10, 2021 09:36 AM

Otto wrote:Hello Silvio,

>this forum is about English Forums ‹ FiveWin for Harbour/xHarbour forum

This report generator is for FIVEWIN!
It has nothing to do with mod harbour.

Best regards,
Otto

But which Report generator?
Let the fwhteam be a report designer please
that I have been waiting for at least twenty years for a powerful report designer
that through your fault or for those who use ER we still can't have it and we have to settle for ER that doesn't work

Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)

I use : FiveWin for Harbour March-April 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com

Otto

Posts: 6983

Joined: Fri Oct 07, 2005 07:07 PM

Re: HTML reporting system
Posted: Thu Jun 10, 2021 10:02 AM

Hello Silvio,

OpenOffice for example.

Best regards,
Otto

Otto

Posts: 6983

Joined: Fri Oct 07, 2005 07:07 PM

Re: HTML reporting system for FIVEWIN
Posted: Thu Jun 10, 2021 11:57 AM

Silvio, I changed the subject to HTML reporting system for FIVEWIN.
Best regards,
Otto

Otto

Posts: 6983

Joined: Fri Oct 07, 2005 07:07 PM

Re: HTML reporting system for FIVEWIN
Posted: Thu Jun 10, 2021 12:16 PM

Hello friends,
Here you see HTML code from MS WORD.

Now I made a function to clean up this source code to use with FIVEWIN reports.

Code (fw): Select all Collapse

function getHTMLTags()
   local cText := memoread("C:\html_reports\quittungClean.html")
   local n, cResult := "", nTimes := StrCharCount( cText, "<" ) + 1
   local aText := {}
   local cPlaceholder := ""
   local nAt := 0
   local cTextNeu := cText
   local aTagsReplace := {}
   local I := 0
    *----------------------------------------------------------  
   aTagsReplace := {    { "<p ", "<P>"},;
                        { "<td ","<td>"},;
                        { "<span","<span>"}  }
   
   FOR I:= 1 to len(aTagsReplace)
    cText := memoread("C:\html_reports\quittungClean.html")
       for n = 2 to nTimes
        cPlaceholder := StrToken( cText, n, "<" )
            nAt := At(">", cPlaceholder )
            cPlaceholder := "<"+left( cPlaceholder, nAt )
            
            if  cPlaceholder = aTagsReplace[I,1]  
            AADD( aText, {cPlaceholder,"" } ) 
          
            cTextNeu := STRTRAN( cTextNeu, cPlaceholder, aTagsReplace[I,2] )
          
          endif
       
       next
        memowrit("C:\html_reports\quittungClean.html", cTextNeu)
   next
    xbrowse( aText )
    msginfo( "End" )
  
return( aText )   

//----------------------------------------------------------------------------//

And that is what the code looks after cleaning.

Best regards,
Otto

Silvio.Falconi

Posts: 7317

Joined: Thu Oct 18, 2012 07:17 PM

Re: HTML reporting system for FIVEWIN
Posted: Thu Jun 10, 2021 01:24 PM

but OpenOffice and winword can be compiled into our applications?
no?
it's no usefull, sorry....

Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)

I use : FiveWin for Harbour March-April 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com

Silvio.Falconi

Posts: 7317

Joined: Thu Oct 18, 2012 07:17 PM

Re: HTML reporting system for FIVEWIN
Posted: Thu Jun 10, 2021 01:34 PM

you cannot force the user to purchase Microsoft Office or download OpenOffice.

We have to make a fillable report generator within our applications.

I could mention many famous applications at least in Italy such as Danra easyfatt. this application that has sold millions and millions of copies works because it is a report generator within the same application. You still don't understand the importance of having the generator within the application.

you cannot force the user to purchase Microsoft Office or download OpenOffice. We have to make a fillable report generator within our applications. I could mention many famous applications at least in Italy such as Danra easyfatt. this application that has sold millions and millions of copies works because it is a report generator within the same application. You still don't understand the importance of having the generator within the application. In the past they told me

Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)

I use : FiveWin for Harbour March-April 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com

Otto

Posts: 6983

Joined: Fri Oct 07, 2005 07:07 PM

Re: HTML reporting system for FIVEWIN
Posted: Thu Jun 10, 2021 04:13 PM

Hello Silvio,

For me HTML reporting is working fine.

Best regards,
Otto

Silvio.Falconi

Posts: 7317

Joined: Thu Oct 18, 2012 07:17 PM

Re: HTML reporting system for FIVEWIN
Posted: Thu Jun 10, 2021 04:31 PM

otto you are losing only your time

Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)

I use : FiveWin for Harbour March-April 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com

Otto

Posts: 6983

Joined: Fri Oct 07, 2005 07:07 PM

Re: HTML reporting system for FIVEWIN
Posted: Thu Jun 10, 2021 05:52 PM

Here is a photo of a printed receipt.
Important for black and white receipt printers in general
You can only use monochrome images or only the colors black and white.

elvira

Posts: 518

Joined: Fri Jun 29, 2012 12:49 PM

Re: HTML reporting system for FIVEWIN
Posted: Mon Jun 14, 2021 08:47 AM

Hi,

Is there a sample to test or it is just an advertisement?

Thank you Otto for your work.

Otto

Posts: 6983

Joined: Fri Oct 07, 2005 07:07 PM

Re: HTML reporting system for FIVEWIN
Posted: Mon Jun 14, 2021 09:29 AM

Hello,
I am working on samples.
Best regards,
Otto

leandro

Posts: 1816

Joined: Wed Oct 26, 2005 02:49 PM

Re: HTML reporting system for FIVEWIN
Posted: Mon Jun 14, 2021 12:18 PM

Me gusta la idea

Al ser html, se pueden usar archivos .css?

Cuando lo podemos probar?, Gracias Otto por el tiempo invertido.

Saludos
LEANDRO AREVALO
Bogotá (Colombia)
https://hymlyma.com
https://hymplus.com/
leandroalfonso111@gmail.com
leandroalfonso111@hotmail.com

[ Turbo Incremental Link64 6.98 Embarcadero 7.70 ] [ FiveWin 25.01 ] [ xHarbour 64 bits) ]

FiveTech Support Forums