/ɪːzɪˈpɪːzɪ/ Reportgenerator for FIVEWIN and mod harbour

[Otto]

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.

[Otto]

Word for designing



source code



preview

[Otto]

table header - table is autosizeing



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

[AIDA]

Looks very interesting

table header - table is autosizeing



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

[Otto]

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

[AIDA]

I really liked it , I hope I understand well how to do it


Saluditos

[Otto]

Placeholders
Word template


create placeholders



placeholders


paste placeholders


save as HTML

extract placeholders from HTML

[Otto]

Replace placeholder with data:






sourcecode to replace "placeholders"

[Otto]

Now changing design with WORD

[Silvio.Falconi]

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

[Otto]

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

[Otto]

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: Select all | Expand

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: Select all | Expand

<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

[elvira]

Hello,

Is there a sample prg to test?

Thank you

[Otto]

Hello,
I am working on a sample.
Page and printer setup is ready.
So, I have all the necessary components.

Best regards,
Otto