Page 1 of 1

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

PostPosted: Wed May 19, 2021 1:17 pm
by Otto
Image

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.

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

PostPosted: Wed May 19, 2021 3:37 pm
by Otto
Word for designing

Image

source code

Image

preview

Image

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

PostPosted: Wed May 19, 2021 4:48 pm
by Otto
table header - table is autosizeing

Image

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


Image

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

PostPosted: Thu May 20, 2021 11:29 pm
by AIDA
Looks very interesting :shock:




Otto wrote:table header - table is autosizeing

Image

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


Image

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

PostPosted: Fri May 21, 2021 6:59 am
by 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.

Image

Image

This is the sample I started.

Image

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

Image

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

PostPosted: Sat May 22, 2021 1:28 am
by AIDA
I really liked it :D , I hope I understand well how to do it :mrgreen:


Saluditos :wink:

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

PostPosted: Thu Jun 03, 2021 10:05 am
by Otto
Placeholders
Word template
Image

create placeholders
Image


placeholders
Image

paste placeholders
Image

save as HTML
Image
extract placeholders from HTML
Image

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

PostPosted: Thu Jun 03, 2021 10:51 am
by Otto
Replace placeholder with data:


Image

Image

sourcecode to replace "placeholders"

Image

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

PostPosted: Thu Jun 03, 2021 11:04 am
by Otto
Now changing design with WORD

Image

Image

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

PostPosted: Thu Jun 03, 2021 7:57 pm
by 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

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

PostPosted: Thu Jun 03, 2021 8:22 pm
by Otto
Silvio, please see my answer in the English forum.
Best regards,
Otto

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

PostPosted: Fri Jun 04, 2021 3:41 pm
by 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 view

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 view



<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 )
                       

 

Image
LG
Otto

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

PostPosted: Sat Jun 05, 2021 9:21 am
by elvira
Hello,

Is there a sample prg to test?

Thank you

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

PostPosted: Sat Jun 05, 2021 12:58 pm
by Otto
Hello,
I am working on a sample.
Page and printer setup is ready.
So, I have all the necessary components.

Best regards,
Otto

Image