Page 1 of 1

Report with array

PostPosted: Sun Mar 10, 2019 2:28 pm
by wartiaga
Hi,

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

Thanks in advance

Re: Report with array

PostPosted: Sun Mar 10, 2019 7:44 pm
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

Re: Report with array

PostPosted: Sun Mar 10, 2019 9:38 pm
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!

Re: Report with array

PostPosted: Mon Mar 11, 2019 4:44 pm
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

Re: Report with array

PostPosted: Mon Mar 11, 2019 6:43 pm
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?

Re: Report with array

PostPosted: Mon Mar 11, 2019 7:31 pm
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

Re: Report with array

PostPosted: Tue Mar 12, 2019 1:03 am
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

Re: Report with array

PostPosted: Wed Mar 13, 2019 12:45 am
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

Re: Report with array

PostPosted: Wed Mar 13, 2019 7:03 am
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 }

Re: Report with array

PostPosted: Wed Mar 13, 2019 5:02 pm
by wartiaga
Thank you Otto I will try!

Re: Report with array

PostPosted: Tue Apr 25, 2023 12:18 pm
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.

Re: Report with array

PostPosted: Tue Apr 25, 2023 12:34 pm
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 view

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.

Re: Report with array

PostPosted: Tue Apr 25, 2023 4:17 pm
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#0uD6SmwgNlSjMT365nDo1LUuv4z-pCi2qs3CWKD8G5s

Regards, saludos.

Re: Report with array

PostPosted: Tue Apr 25, 2023 5:48 pm
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.

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

Best regards,
Otto