Report with array

Report with array

Postby wartiaga » Sun Mar 10, 2019 2:28 pm

Hi,

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

Thanks in advance
wartiaga
 
Posts: 212
Joined: Wed May 25, 2016 1:04 am

Re: Report with array

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

Re: Report with array

Postby wartiaga » Sun Mar 10, 2019 9: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!
wartiaga
 
Posts: 212
Joined: Wed May 25, 2016 1:04 am

Re: Report with array

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

Re: Report with array

Postby wartiaga » Mon Mar 11, 2019 6: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?
wartiaga
 
Posts: 212
Joined: Wed May 25, 2016 1:04 am

Re: Report with array

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

Re: Report with array

Postby wartiaga » Tue Mar 12, 2019 1: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
wartiaga
 
Posts: 212
Joined: Wed May 25, 2016 1:04 am

Re: Report with array

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

Re: Report with array

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

Re: Report with array

Postby wartiaga » Wed Mar 13, 2019 5:02 pm

Thank you Otto I will try!
wartiaga
 
Posts: 212
Joined: Wed May 25, 2016 1:04 am

Re: Report with array

Postby karinha » 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
User avatar
karinha
 
Posts: 7831
Joined: Tue Dec 20, 2005 7:36 pm
Location: São Paulo - Brasil

Re: Report with array

Postby karinha » 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: Select all  Expand view  RUN

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
User avatar
karinha
 
Posts: 7831
Joined: Tue Dec 20, 2005 7:36 pm
Location: São Paulo - Brasil

Re: Report with array

Postby karinha » Tue Apr 25, 2023 4: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
User avatar
karinha
 
Posts: 7831
Joined: Tue Dec 20, 2005 7:36 pm
Location: São Paulo - Brasil

Re: Report with array

Postby Otto » Tue Apr 25, 2023 5: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.

viewtopic.php?f=3&t=42879&start=0&hilit=webview2

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: 6334
Joined: Fri Oct 07, 2005 7:07 pm


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: No registered users and 61 guests