HTML reporting system for FIVEWIN

HTML reporting system for FIVEWIN

Postby Otto » Thu Jun 10, 2021 8: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
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
Otto
 
Posts: 6364
Joined: Fri Oct 07, 2005 7:07 pm

Re: HTML reporting system

Postby Silvio.Falconi » Thu Jun 10, 2021 8: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 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: 7090
Joined: Thu Oct 18, 2012 7:17 pm

Re: HTML reporting system

Postby Otto » Thu Jun 10, 2021 9: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
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
User avatar
Otto
 
Posts: 6364
Joined: Fri Oct 07, 2005 7:07 pm

Re: HTML reporting system

Postby Silvio.Falconi » Thu Jun 10, 2021 9: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 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: 7090
Joined: Thu Oct 18, 2012 7:17 pm

Re: HTML reporting system

Postby Otto » Thu Jun 10, 2021 10:02 am

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: 6364
Joined: Fri Oct 07, 2005 7:07 pm

Re: HTML reporting system for FIVEWIN

Postby Otto » Thu Jun 10, 2021 11:57 am

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: 6364
Joined: Fri Oct 07, 2005 7:07 pm

Re: HTML reporting system for FIVEWIN

Postby Otto » Thu Jun 10, 2021 12:16 pm

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 view  RUN

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
Otto
 
Posts: 6364
Joined: Fri Oct 07, 2005 7:07 pm

Re: HTML reporting system for FIVEWIN

Postby Silvio.Falconi » Thu Jun 10, 2021 1: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 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: 7090
Joined: Thu Oct 18, 2012 7:17 pm

Re: HTML reporting system for FIVEWIN

Postby Silvio.Falconi » Thu Jun 10, 2021 1: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 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: 7090
Joined: Thu Oct 18, 2012 7:17 pm

Re: HTML reporting system for FIVEWIN

Postby Otto » Thu Jun 10, 2021 4:13 pm

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
Otto
 
Posts: 6364
Joined: Fri Oct 07, 2005 7:07 pm

Re: HTML reporting system for FIVEWIN

Postby Silvio.Falconi » Thu Jun 10, 2021 4: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 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: 7090
Joined: Thu Oct 18, 2012 7:17 pm

Re: HTML reporting system for FIVEWIN

Postby Otto » Thu Jun 10, 2021 5: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.

Image
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
User avatar
Otto
 
Posts: 6364
Joined: Fri Oct 07, 2005 7:07 pm

Re: HTML reporting system for FIVEWIN

Postby elvira » Mon Jun 14, 2021 8:47 am

Hi,

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

Thank you Otto for your work.
elvira
 
Posts: 516
Joined: Fri Jun 29, 2012 12:49 pm

Re: HTML reporting system for FIVEWIN

Postby Otto » Mon Jun 14, 2021 9:29 am

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
Otto
 
Posts: 6364
Joined: Fri Oct 07, 2005 7:07 pm

Re: HTML reporting system for FIVEWIN

Postby leandro » Mon Jun 14, 2021 12:18 pm

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

[ Embarcadero C++ 7.60 for Win32 ] [ FiveWin 23.07 ] [ xHarbour 1.3.0 Intl. (SimpLex) (Build 20230914) ]
User avatar
leandro
 
Posts: 1688
Joined: Wed Oct 26, 2005 2:49 pm
Location: Colombia

Next

Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: No registered users and 87 guests