FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin para Harbour/xHarbour /ɪːzɪˈpɪːzɪ/ Reportgenerator for FIVEWIN and mod harbour
Posts: 6983
Joined: Fri Oct 07, 2005 07:07 PM
/ɪːzɪˈpɪːzɪ/ Reportgenerator for FIVEWIN and mod harbour
Posted: Wed May 19, 2021 01:17 PM


A catchy project name and an appealing logo are not pure luxury but a helpful marketing tool.

/ɪːzɪˈpɪːzɪ/
easy-peasy | adjective | British informal

very easy; presenting no difficulty at all

The reports are easy-peasy to make.
You can use any HTML editor or WYSIWYG HTML editor - for example WORD - to create /ɪːzɪˈpɪːzɪ/ reports.

/ɪːzɪˈpɪːzɪ/ report definition files are HTML files.
/ɪːzɪˈpɪːzɪ/ report works with with Fivewin and mod harbour.
Posts: 6983
Joined: Fri Oct 07, 2005 07:07 PM
Re: /ɪːzɪˈpɪːzɪ/ Reportgenerator for FIVEWIN and mod harbour
Posted: Wed May 19, 2021 03:37 PM
Word for designing



source code



preview

Posts: 6983
Joined: Fri Oct 07, 2005 07:07 PM
Re: /ɪːzɪˈpɪːzɪ/ Reportgenerator for FIVEWIN and mod harbour
Posted: Wed May 19, 2021 04:48 PM
table header - table is autosizeing



Here I add some styles
cHtml += memoread(".\tagesGaesteListe\tablestyle.html")


Posts: 880
Joined: Fri Jan 12, 2007 08:35 PM
Re: /ɪːzɪˈpɪːzɪ/ Reportgenerator for FIVEWIN and mod harbour
Posted: Thu May 20, 2021 11:29 PM
Looks very interesting :-)




Otto wrote:table header - table is autosizeing



Here I add some styles
cHtml += memoread(".\tagesGaesteListe\tablestyle.html")


Que es mejor que programar? creo que nada :)
Atropellada pero aqui ando :P

I love Fivewin

séʌǝɹ ןɐ ɐʇsǝ opunɯ ǝʇsǝ
Posts: 6983
Joined: Fri Oct 07, 2005 07:07 PM
Re: /ɪːzɪˈpɪːzɪ/ Reportgenerator for FIVEWIN and mod harbour
Posted: Fri May 21, 2021 06:59 AM
Hello Aida,
Thank you.
You can use Word or any other HTML editor, or just HTML code.
Here I tested to replace an oReport.
See report.prg in the Fivewin samples and compare this new code and the result.





This is the sample I started.



Look how easy-peasy you can achieve great effects. The source code is also easy to understand. For example,
I mark all names that begin with "L".

Best regards,
Otto

Posts: 880
Joined: Fri Jan 12, 2007 08:35 PM
Re: /ɪːzɪˈpɪːzɪ/ Reportgenerator for FIVEWIN and mod harbour
Posted: Sat May 22, 2021 01:28 AM

I really liked it :D , I hope I understand well how to do it :mrgreen:

Saluditos :wink:

Que es mejor que programar? creo que nada :)
Atropellada pero aqui ando :P

I love Fivewin

séʌǝɹ ןɐ ɐʇsǝ opunɯ ǝʇsǝ
Posts: 6983
Joined: Fri Oct 07, 2005 07:07 PM
Re: /ɪːzɪˈpɪːzɪ/ Reportgenerator for FIVEWIN and mod harbour
Posted: Thu Jun 03, 2021 10:05 AM
Placeholders
Word template


create placeholders



placeholders


paste placeholders


save as HTML

extract placeholders from HTML
Posts: 6983
Joined: Fri Oct 07, 2005 07:07 PM
Re: /ɪːzɪˈpɪːzɪ/ Reportgenerator for FIVEWIN and mod harbour
Posted: Thu Jun 03, 2021 10:51 AM
Replace placeholder with data:






sourcecode to replace "placeholders"

Posts: 6983
Joined: Fri Oct 07, 2005 07:07 PM
Re: /ɪːzɪˈpɪːzɪ/ Reportgenerator for FIVEWIN and mod harbour
Posted: Thu Jun 03, 2021 11:04 AM
Now changing design with WORD



Posts: 7317
Joined: Thu Oct 18, 2012 07:17 PM
Re: /ɪːzɪˈpɪːzɪ/ Reportgenerator for FIVEWIN and mod harbour
Posted: Thu Jun 03, 2021 07:57 PM

Otto,
I not Use Microsoft Office applications, and with me all my clients and friends
we use alternative products, for free
you sell your program to your client but then you tell him that he has to buy office to create reports?
what a beautiful prospect

what would this thing be?
a form for not being autonomous?
Fivewin needs a powerful report designer
if you are drawing with Word then it means that you no longer use ER, but as for you it was more ultra now you do not use it anymore?
you have to be consistent with yourself, you always said you use ER and it works fine for you now you can't use it with mod_harbour?

please move this topic to Mod Harbour forum

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
Posts: 6983
Joined: Fri Oct 07, 2005 07:07 PM
Re: /ɪːzɪˈpɪːzɪ/ Reportgenerator for FIVEWIN and mod harbour
Posted: Thu Jun 03, 2021 08:22 PM

Silvio, please see my answer in the English forum.
Best regards,
Otto

Posts: 6983
Joined: Fri Oct 07, 2005 07:07 PM
Re: /ɪːzɪˈpɪːzɪ/ Reportgenerator for FIVEWIN and mod harbour
Posted: Fri Jun 04, 2021 03:41 PM
Hello friends,
I have the first response from my users.

/ *
Hello Otto,
great thank you!
Would it be possible for the first column to be smaller?
So in principle we wouldn't need it at all.
I don't know what the CH actually means. ?
And if you can, the font is larger for the room number, arrival and departure, half board and comments.
We don't need the last 5 columns either (D + T + Aktion + Ki + EW) is above.
* /

The changes are easy.
In the function that decides which columns are printed,
the switches are simply set to "N" for no.

Code (fw): Select all Collapse
function check4prn( nCol, cCol )
//               1234567890123456 
local cPrint := "NJJJJJJJJJJNNNNN"
    
    if substr(cPrint, nCol, 1 ) <> "J"
        cCol := ""
    endif
  
return( cCol )
//----------------------------------------------------------------------------//


The styling is done in CSS.

For example the column HP:

.mytd {
border: 1px solid #dddddd;
text-align: center;
padding: 4px;
background: #A4C400;
font-size: 18px;
}


Code (fw): Select all Collapse
<style>
        .mytd {
          border: 1px solid #dddddd;
          text-align: center;
          padding: 4px;
          background:  #A4C400;
          font-size: 18px;
        }       
        .tdname  {
          font-size: 18px;
          border: 1px solid #dddddd;
          text-align: left;
          padding: 4px;
        }       
        
        .tdmedium  {
          font-size: 22px;
          border: 1px solid #dddddd;
          text-align: left;
          padding: 4px;
        }       
        
        .tdlarge {
          font-size: 26px;
          border: 1px solid #dddddd;
          text-align: left;
          padding: 4px;
        }       
        
</style>    

    
cText += check4prn(  1, "<td>" + cMarker+ "</td>" + CRLF )
cText += check4prn(  2, "<td class='tdlarge'>" + VRDZiNr + "</td>" + CRLF )
cText += check4prn(  3, "<td class='tdname'>" + convertUmlaute( VRDName ) + "</td>" + CRLF )
cText += check4prn(  4, "<td class='tdmedium'>" + VRDAnAbreise + "</td>" + CRLF )
cText += check4prn(  5, "<td>" +VRDZF + "</td>" + CRLF )
cText += check4prn(  6, "<td>" +VRDZFKi + "</td>" + CRLF )
cText += check4prn(  7, "<td class='mytd'>" + VRDHP + "</td>" + CRLF )
cText += check4prn(  8, "<td>" +VRDHPKi + "</td>" + CRLF )
cText += check4prn(  9, "<td>" +VRDVP + "</td>" + CRLF )
cText += check4prn( 10, "<td>" +VRDVPKi + "</td>" + CRLF )
cText += check4prn( 11, "<td  class='tdname'>" +convertUmlaute(VRDBErmerkung) + "</td>" + CRLF )
cText += check4prn( 12, "<td>" +VRDEW + "</td>" + CRLF )
cText += check4prn( 13, "<td>" +VRDKi + "</td>" + CRLF )
cText += check4prn( 14, "<td>" +VRDAktion + "</td>" + CRLF )
cText += check4prn( 15, "<td>" +VRDD + "</td>" + CRLF )
cText += check4prn( 16, "<td>" +VRDT + "</td>" + CRLF )


LG
Otto
Posts: 518
Joined: Fri Jun 29, 2012 12:49 PM
Re: /ɪːzɪˈpɪːzɪ/ Reportgenerator for FIVEWIN and mod harbour
Posted: Sat Jun 05, 2021 09:21 AM

Hello,

Is there a sample prg to test?

Thank you

Posts: 6983
Joined: Fri Oct 07, 2005 07:07 PM
Re: /ɪːzɪˈpɪːzɪ/ Reportgenerator for FIVEWIN and mod harbour
Posted: Sat Jun 05, 2021 12:58 PM
Hello,
I am working on a sample.
Page and printer setup is ready.
So, I have all the necessary components.

Best regards,
Otto

Continue the discussion