Report with array
Report with array
Hi,
Anyone have a sample how i can relationate 2 arrays (masterdata/detail) and pass to fastreport?
Thanks in advance
Anyone have a sample how i can relationate 2 arrays (masterdata/detail) and pass to fastreport?
Thanks in advance
- Otto
- Posts: 6403
- Joined: Fri Oct 07, 2005 7:07 pm
- Has thanked: 22 times
- Been thanked: 2 times
- Contact:
Re: Report with array
Hello,
can you show how the report should look.
Why don't you use EasyReport.
This is very easy with EasyReport.
Best regards
Otto
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
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
Re: Report with array
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!
- Otto
- Posts: 6403
- Joined: Fri Oct 07, 2005 7:07 pm
- Has thanked: 22 times
- Been thanked: 2 times
- Contact:
Re: Report with array
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
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
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
Re: Report with array
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?
- Otto
- Posts: 6403
- Joined: Fri Oct 07, 2005 7:07 pm
- Has thanked: 22 times
- Been thanked: 2 times
- Contact:
Re: Report with array
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
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
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
Re: Report with array
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
- Otto
- Posts: 6403
- Joined: Fri Oct 07, 2005 7:07 pm
- Has thanked: 22 times
- Been thanked: 2 times
- Contact:
Re: Report with array
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](https://mybergland.com/FWForum/ERArray.jpg)
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](https://mybergland.com/FWForum/ERArray.jpg)
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
- Otto
- Posts: 6403
- Joined: Fri Oct 07, 2005 7:07 pm
- Has thanked: 22 times
- Been thanked: 2 times
- Contact:
Re: Report with array
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 }
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
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
- 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
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.
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
- 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
Dear Otto, does Easy Report have its own EDITOR for .VRD?
Estimado Otto, ¿Easy Report tiene su propio EDITOR para .VRD?
Thanks.
Regards, saludos.
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
Regards, saludos.
João Santos - São Paulo - Brasil - Phone: +55(11)95150-7341
- 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
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.
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
- Otto
- Posts: 6403
- Joined: Fri Oct 07, 2005 7:07 pm
- Has thanked: 22 times
- Been thanked: 2 times
- Contact:
Re: Report with array
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
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
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************