Report with array

Post Reply
wartiaga
Posts: 216
Joined: Wed May 25, 2016 1:04 am

Report with array

Post by wartiaga »

Hi,

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

Thanks in advance
User avatar
Otto
Posts: 6403
Joined: Fri Oct 07, 2005 7:07 pm
Has thanked: 22 times
Been thanked: 2 times
Contact:

Re: Report with array

Post by Otto »

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
********************************************************************
wartiaga
Posts: 216
Joined: Wed May 25, 2016 1:04 am

Re: Report with array

Post by wartiaga »

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!
User avatar
Otto
Posts: 6403
Joined: Fri Oct 07, 2005 7:07 pm
Has thanked: 22 times
Been thanked: 2 times
Contact:

Re: Report with array

Post by Otto »

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
********************************************************************
wartiaga
Posts: 216
Joined: Wed May 25, 2016 1:04 am

Re: Report with array

Post by wartiaga »

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?
User avatar
Otto
Posts: 6403
Joined: Fri Oct 07, 2005 7:07 pm
Has thanked: 22 times
Been thanked: 2 times
Contact:

Re: Report with array

Post by Otto »

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
********************************************************************
wartiaga
Posts: 216
Joined: Wed May 25, 2016 1:04 am

Re: Report with array

Post by wartiaga »

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
User avatar
Otto
Posts: 6403
Joined: Fri Oct 07, 2005 7:07 pm
Has thanked: 22 times
Been thanked: 2 times
Contact:

Re: Report with array

Post by Otto »

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: 6403
Joined: Fri Oct 07, 2005 7:07 pm
Has thanked: 22 times
Been thanked: 2 times
Contact:

Re: Report with array

Post by Otto »

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
********************************************************************
wartiaga
Posts: 216
Joined: Wed May 25, 2016 1:04 am

Re: Report with array

Post by wartiaga »

Thank you Otto I will try!
User avatar
karinha
Posts: 7932
Joined: Tue Dec 20, 2005 7:36 pm
Location: São Paulo - Brasil
Been thanked: 3 times
Contact:

Re: Report with array

Post by karinha »

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: 7932
Joined: Tue Dec 20, 2005 7:36 pm
Location: São Paulo - Brasil
Been thanked: 3 times
Contact:

Re: Report with array

Post by karinha »

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

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: 7932
Joined: Tue Dec 20, 2005 7:36 pm
Location: São Paulo - Brasil
Been thanked: 3 times
Contact:

Re: Report with array

Post by karinha »

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#0uD6SmwgN ... s3CWKD8G5s

Regards, saludos.
João Santos - São Paulo - Brasil - Phone: +55(11)95150-7341
User avatar
Otto
Posts: 6403
Joined: Fri Oct 07, 2005 7:07 pm
Has thanked: 22 times
Been thanked: 2 times
Contact:

Re: Report with array

Post by Otto »

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/view ... t=webview2

Best regards,
Otto
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
Post Reply