FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour Report with array
Posts: 253
Joined: Wed May 25, 2016 01:04 AM
Report with array
Posted: Sun Mar 10, 2019 02:28 PM

Hi,

Anyone have a sample how i can relationate 2 arrays (masterdata/detail) and pass to fastreport?

Thanks in advance

Posts: 6984
Joined: Fri Oct 07, 2005 07:07 PM
Re: Report with array
Posted: Sun Mar 10, 2019 07:44 PM

Hello,
can you show how the report should look.
Why don't you use EasyReport.
This is very easy with EasyReport.
Best regards
Otto

Posts: 253
Joined: Wed May 25, 2016 01:04 AM
Re: Report with array
Posted: Sun Mar 10, 2019 09:38 PM
Otto wrote:Hello,
can you show how the report should look.
Why don't you use EasyReport.
This is very easy with EasyReport.
Best regards
Otto


Hi Otto, I use fastreport with dbf but I trying mariadb and someone told me to work with array resulting of query.
I don't use EasyReport because all my reports are made with fastreport.
I want to pass 2 arrays to fastreport one with datas of one order and other the itens of this order.
Thanks for your help!
Posts: 6984
Joined: Fri Oct 07, 2005 07:07 PM
Re: Report with array
Posted: Mon Mar 11, 2019 04:44 PM

Hello,
are you developing inhouse applications.
If I install FastRepot FrSystH.dll is blocked by the most Antivirus programs.
Have you a solution for that.
Thank you in advance
Otto

Posts: 253
Joined: Wed May 25, 2016 01:04 AM
Re: Report with array
Posted: Mon Mar 11, 2019 06:43 PM
Otto wrote:Hello,
are you developing inhouse applications.
If I install FastRepot FrSystH.dll is blocked by the most Antivirus programs.
Have you a solution for that.
Thank you in advance
Otto


Hi Otto, I dont have problems with this. Did you try to adding FrSystH.dll in exception antivirus list?
Posts: 6984
Joined: Fri Oct 07, 2005 07:07 PM
Re: Report with array
Posted: Mon Mar 11, 2019 07:31 PM

Hello
thank you for your answer.
But this is a problem if you have many costumers. You need admin rights which is not always possible.
And FrSystH.dd has no future as no one has the sources.
For in house this might be a solution. But if you sell your software over internet and self installing this is no good solution.
For a fivewinner EasyReport is the most productive tool. You can do all you want. In FastReport you have to learn another scripting language.
FastReport designer is at the first look better but as always the work is in detail.
Best regards
Otto

Posts: 253
Joined: Wed May 25, 2016 01:04 AM
Re: Report with array
Posted: Tue Mar 12, 2019 01:03 AM
Otto wrote:Hello
thank you for your answer.
But this is a problem if you have many costumers. You need admin rights which is not always possible.
And FrSystH.dd has no future as no one has the sources.
For in house this might be a solution. But if you sell your software over internet and self installing this is no good solution.
For a fivewinner EasyReport is the most productive tool. You can do all you want. In FastReport you have to learn another scripting language.
FastReport designer is at the first look better but as always the work is in detail.
Best regards
Otto


I agree with you Otto, where I can download easy report and find information about initiate, is easy like fastreport? Thanks
Posts: 6984
Joined: Fri Oct 07, 2005 07:07 PM
Re: Report with array
Posted: Wed Mar 13, 2019 12:45 AM
Hello,
here is a sample with EasyReport.
Download: http://mybergland.com/FWForum/ER_DemoArray.zip
Please copy to FWH\samples. Let me know if it compiles.
Best regards
Otto
Posts: 6984
Joined: Fri Oct 07, 2005 07:07 PM
Re: Report with array
Posted: Wed Mar 13, 2019 07:03 AM

Hello,
Itemvalues must always be character strings. Also formatting must be done before passing to ER.
Best regards
Otto

PRINTAREA 4 OF oVRD ;
ITEMIDS { 102, 103 ,104, 105 } ;
ITEMVALUES { aTemp[ I,2 ], dtoc( aTemp[ I,8 ]),aTemp[ I,4 ],aTemp[ I,5 ] }

Here another sample

cMenge := "1"
cBezeichnung := reschein->Bezeichnun
cPreis := transform(reschein->v_preis,"99,999.99")
cWert := ""
cRabatt := ""

        PRINTAREA 3 OF ::oVrd ;
           ITEMIDS { 101,102,105,106,107 } ;
           ITEMVALUES { cMenge,;
           cBezeichnung, ;
           cPreis,;
           cWert,;
           cRabatt }
Posts: 253
Joined: Wed May 25, 2016 01:04 AM
Re: Report with array
Posted: Wed Mar 13, 2019 05:02 PM

Thank you Otto I will try!

Posts: 8523
Joined: Tue Dec 20, 2005 07:36 PM
Re: Report with array
Posted: Tue Apr 25, 2023 12:18 PM

Good morning my good friend OTTO, do you have examples other than using ARRAY()? Thanks. Hugs.

Buenos días, mi buen amigo OTTO, ¿tienes otros ejemplos que no sean ARRAY()? Gracias. Abrazos.

Regards, saludos.

João Santos - São Paulo - Brasil - Phone: +55(11)95150-7341
Posts: 8523
Joined: Tue Dec 20, 2005 07:36 PM
Re: Report with array
Posted: Tue Apr 25, 2023 12:34 PM
Dear Otto, does Easy Report have its own EDITOR for .VRD?
Estimado Otto, ¿Easy Report tiene su propio EDITOR para .VRD?

Code (fw): Select all Collapse
13/03/2019  01:25               505 States.v01
13/03/2019  01:25               469 States.v02
13/03/2019  01:25               683 States.v03
13/03/2019  01:25               785 States.v04
13/03/2019  01:25               754 States.v05
13/03/2019  01:25               422 States.v06
13/03/2019  01:25               794 States.v07
13/03/2019  01:25             1.284 States.vrd
Thanks.

Regards, saludos.
João Santos - São Paulo - Brasil - Phone: +55(11)95150-7341
Posts: 8523
Joined: Tue Dec 20, 2005 07:36 PM
Re: Report with array
Posted: Tue Apr 25, 2023 04:17 PM
New Version. Nueva version.

I still haven't mastered how to control the printing FORMS. Learning is very difficult.

Todavía no domino cómo controlar los FORMULARIOS de impresión. Aprender es muy difícil.

Download complete:

https://mega.nz/file/NN9X0JQQ#0uD6SmwgNlSjMT365nDo1LUuv4z-pCi2qs3CWKD8G5s

Regards, saludos.
João Santos - São Paulo - Brasil - Phone: +55(11)95150-7341
Posts: 6984
Joined: Fri Oct 07, 2005 07:07 PM
Re: Report with array
Posted: Tue Apr 25, 2023 05:48 PM
Dear Joao,
I am working with a very old copy of xvrd.exe.
This copy does not run safely either. But in the meantime we know the problem areas and are working around them.

I think Cristobal has the best state of the designer.

I myself have converted the reports to HTML.
Now with webview2 HTML is even better.

https://forums.fivetechsupport.com/viewtopic.php?f=3&t=42879&start=0&hilit=webview2

Best regards,
Otto

Continue the discussion