HTML reporting system for FIVEWIN

User avatar
Otto
Posts: 6403
Joined: Fri Oct 07, 2005 7:07 pm
Has thanked: 22 times
Been thanked: 2 times
Contact:

HTML reporting system for FIVEWIN

Post by Otto »

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
Last edited by Otto on Thu Jun 10, 2021 11:56 am, edited 1 time in total.
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
User avatar
Silvio.Falconi
Posts: 7133
Joined: Thu Oct 18, 2012 7:17 pm
Been thanked: 1 time

Re: HTML reporting system

Post by Silvio.Falconi »

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 November 2023 - January 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
User avatar
Otto
Posts: 6403
Joined: Fri Oct 07, 2005 7:07 pm
Has thanked: 22 times
Been thanked: 2 times
Contact:

Re: HTML reporting system

Post by Otto »

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
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
User avatar
Silvio.Falconi
Posts: 7133
Joined: Thu Oct 18, 2012 7:17 pm
Been thanked: 1 time

Re: HTML reporting system

Post by Silvio.Falconi »

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 November 2023 - January 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
User avatar
Otto
Posts: 6403
Joined: Fri Oct 07, 2005 7:07 pm
Has thanked: 22 times
Been thanked: 2 times
Contact:

Re: HTML reporting system

Post by Otto »

Hello Silvio,

OpenOffice for example.


Best regards,
Otto
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
User avatar
Otto
Posts: 6403
Joined: Fri Oct 07, 2005 7:07 pm
Has thanked: 22 times
Been thanked: 2 times
Contact:

Re: HTML reporting system for FIVEWIN

Post by Otto »

Silvio, I changed the subject to HTML reporting system for FIVEWIN.
Best regards,
Otto
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
User avatar
Otto
Posts: 6403
Joined: Fri Oct 07, 2005 7:07 pm
Has thanked: 22 times
Been thanked: 2 times
Contact:

Re: HTML reporting system for FIVEWIN

Post by Otto »

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

Image

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

Code: Select all | Expand


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

Image
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
User avatar
Silvio.Falconi
Posts: 7133
Joined: Thu Oct 18, 2012 7:17 pm
Been thanked: 1 time

Re: HTML reporting system for FIVEWIN

Post by Silvio.Falconi »

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 November 2023 - January 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
User avatar
Silvio.Falconi
Posts: 7133
Joined: Thu Oct 18, 2012 7:17 pm
Been thanked: 1 time

Re: HTML reporting system for FIVEWIN

Post by Silvio.Falconi »

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 November 2023 - January 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
User avatar
Otto
Posts: 6403
Joined: Fri Oct 07, 2005 7:07 pm
Has thanked: 22 times
Been thanked: 2 times
Contact:

Re: HTML reporting system for FIVEWIN

Post by Otto »

Hello Silvio,

For me HTML reporting is working fine.

Best regards,
Otto

Image
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
User avatar
Silvio.Falconi
Posts: 7133
Joined: Thu Oct 18, 2012 7:17 pm
Been thanked: 1 time

Re: HTML reporting system for FIVEWIN

Post by Silvio.Falconi »

otto you are losing only your time
Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)
I use : FiveWin for Harbour November 2023 - January 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
User avatar
Otto
Posts: 6403
Joined: Fri Oct 07, 2005 7:07 pm
Has thanked: 22 times
Been thanked: 2 times
Contact:

Re: HTML reporting system for FIVEWIN

Post by Otto »

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.

Image
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
elvira
Posts: 516
Joined: Fri Jun 29, 2012 12:49 pm

Re: HTML reporting system for FIVEWIN

Post by elvira »

Hi,

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

Thank you Otto for your work.
User avatar
Otto
Posts: 6403
Joined: Fri Oct 07, 2005 7:07 pm
Has thanked: 22 times
Been thanked: 2 times
Contact:

Re: HTML reporting system for FIVEWIN

Post by Otto »

Hello,
I am working on samples.
Best regards,
Otto
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
User avatar
leandro
Posts: 1744
Joined: Wed Oct 26, 2005 2:49 pm
Location: Colombia
Has thanked: 34 times
Been thanked: 10 times
Contact:

Re: HTML reporting system for FIVEWIN

Post by leandro »

Me gusta la idea :D

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 24.09 ] [ xHarbour 64 bits) ]
Post Reply