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

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

Postby Otto » Wed May 19, 2021 1:17 pm

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

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

Postby Otto » Wed May 19, 2021 3:37 pm

Word for designing

Image

source code

Image

preview

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

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

Postby Otto » Wed May 19, 2021 4:48 pm

table header - table is autosizeing

Image

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


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

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

Postby AIDA » Thu May 20, 2021 11:29 pm

Looks very interesting :shock:




Otto wrote:table header - table is autosizeing

Image

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


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

I love Fivewin

séʌǝɹ ןɐ ɐʇsǝ opunɯ ǝʇsǝ
User avatar
AIDA
 
Posts: 877
Joined: Fri Jan 12, 2007 8:35 pm

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

Postby Otto » Fri May 21, 2021 6: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.

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

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

Postby AIDA » Sat May 22, 2021 1: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ǝ
User avatar
AIDA
 
Posts: 877
Joined: Fri Jan 12, 2007 8:35 pm

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

Postby Otto » Thu Jun 03, 2021 10:05 am

Placeholders
Word template
Image

create placeholders
Image


placeholders
Image

paste placeholders
Image

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

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

Postby Otto » Thu Jun 03, 2021 10:51 am

Replace placeholder with data:


Image

Image

sourcecode to replace "placeholders"

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

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

Postby Otto » Thu Jun 03, 2021 11:04 am

Now changing design with WORD

Image

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

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

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

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

Postby Otto » Thu Jun 03, 2021 8:22 pm

Silvio, please see my answer in the English forum.
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: 6005
Joined: Fri Oct 07, 2005 7:07 pm

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

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

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

Postby elvira » Sat Jun 05, 2021 9:21 am

Hello,

Is there a sample prg to test?

Thank you
elvira
 
Posts: 515
Joined: Fri Jun 29, 2012 12:49 pm

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

Postby Otto » 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

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


Return to FiveWin para Harbour/xHarbour

Who is online

Users browsing this forum: Google [Bot] and 74 guests