DEFINE REPORT (with filtered data)
Moderator: Rathinagiri
DEFINE REPORT (with filtered data)
Hola a todos
Alguno de ustedes a utilizado el DEFINE REPORT con registros filtrados ?
Me explico mejor, el DEFINE REPORT me saca el reporte con TODOS los registros
de la DB seleccionada en ese momento, yo quiero sacar solo los de cierta fecha
o cierta condicion. Gracias.
----------------------------------------------------------------------------
Hello everyone
Some of you used the DEFINE REPORT with filtered records?
Let me explain better, the DEFINE REPORT takes the report with me ALL records
of the currently selected DB, I want to get only a certain date
or certain condition. Thanks.
Alguno de ustedes a utilizado el DEFINE REPORT con registros filtrados ?
Me explico mejor, el DEFINE REPORT me saca el reporte con TODOS los registros
de la DB seleccionada en ese momento, yo quiero sacar solo los de cierta fecha
o cierta condicion. Gracias.
----------------------------------------------------------------------------
Hello everyone
Some of you used the DEFINE REPORT with filtered records?
Let me explain better, the DEFINE REPORT takes the report with me ALL records
of the currently selected DB, I want to get only a certain date
or certain condition. Thanks.
Andrés González López
Desde Guadalajara, Jalisco. México.
Desde Guadalajara, Jalisco. México.
- esgici
- Posts: 4543
- Joined: Wed Jul 30, 2008 9:17 pm
- DBs Used: DBF
- Location: iskenderun / Turkiye
- Contact:
Re: DEFINE REPORT (with filtered data)
Hola Andyandyglezl wrote: Some of you used the DEFINE REPORT with filtered records?
Let me explain better, the DEFINE REPORT takes the report with me ALL records
of the currently selected DB, I want to get only a certain date
or certain condition.
Did you try to build your own filter yourself ?
For example adding this line :
Code: Select all
SET FILTER TO "Chile" $ COUNTRY
to top of ( BEFORE DEFINE REPORT Report1 line ) CreateReport function of <...>\SAMPLES\Controls\ReportAdvanced\REPORT.ADVANCED.1\demo.prg
![Wink ;)](./images/smilies/icon_e_wink.gif)
Happy HMG'ing
![Very Happy :D](./images/smilies/icon_e_biggrin.gif)
Viva INTERNATIONAL HMG ![Very Happy :D](./images/smilies/icon_e_biggrin.gif)
![Very Happy :D](./images/smilies/icon_e_biggrin.gif)
Re: DEFINE REPORT (with filtered data)
Garcias esgici
Crei que asi seria, pero pense que el "Report" le podia indicar lo que queria imprimir.
Lo solucione asi, espero que les sirva !
------------------------------------------------------------------------------
Thanks Esgici
I thought that was so, but I thought the "Report" you could indicate what I wanted to print.
It solves so, I hope they serve!
Crei que asi seria, pero pense que el "Report" le podia indicar lo que queria imprimir.
Lo solucione asi, espero que les sirva !
------------------------------------------------------------------------------
Thanks Esgici
I thought that was so, but I thought the "Report" you could indicate what I wanted to print.
It solves so, I hope they serve!
- Attachments
-
- CreateRep.rar
- (15.33 KiB) Downloaded 605 times
Andrés González López
Desde Guadalajara, Jalisco. México.
Desde Guadalajara, Jalisco. México.
- esgici
- Posts: 4543
- Joined: Wed Jul 30, 2008 9:17 pm
- DBs Used: DBF
- Location: iskenderun / Turkiye
- Contact:
Re: DEFINE REPORT (with filtered data)
Congrats !andyglezl wrote: I thought that was so, but I thought the "Report" you could indicate what I wanted to print.
It solves so, I hope they serve!
You have ask a question and also you respond by a way more complex than mine
![Smile :)](./images/smilies/icon_e_smile.gif)
Sadly, since I don't know your language, it not served to me in any manner
![Sad :(](./images/smilies/icon_e_sad.gif)
Anyway, Viva HMG
![Very Happy :D](./images/smilies/icon_e_biggrin.gif)
Viva INTERNATIONAL HMG ![Very Happy :D](./images/smilies/icon_e_biggrin.gif)
![Very Happy :D](./images/smilies/icon_e_biggrin.gif)
Re: DEFINE REPORT (with filtered data)
Lo siento por eso esgici
Pero a excepcion de los "titulos" y los arreglos de "dias" de la semana y "meses"
(que ya traduje con google) lo demas es variables, campos, lenguaje en HMG y Harbour...
aqui va de nuevo traducidos al ingles
--------------------------------------------------------------------------------------
Sorry about that Esgici
But with the exception of the "titles" and arrangements of "days" of the week and "months"
(already translated with google) the rest is variables, fields, and Harbour HMG language ...
here goes again translated into English
Pero a excepcion de los "titulos" y los arreglos de "dias" de la semana y "meses"
(que ya traduje con google) lo demas es variables, campos, lenguaje en HMG y Harbour...
aqui va de nuevo traducidos al ingles
--------------------------------------------------------------------------------------
Sorry about that Esgici
But with the exception of the "titles" and arrangements of "days" of the week and "months"
(already translated with google) the rest is variables, fields, and Harbour HMG language ...
here goes again translated into English
- Attachments
-
- crearep.rar
- (2.22 KiB) Downloaded 579 times
Andrés González López
Desde Guadalajara, Jalisco. México.
Desde Guadalajara, Jalisco. México.
- esgici
- Posts: 4543
- Joined: Wed Jul 30, 2008 9:17 pm
- DBs Used: DBF
- Location: iskenderun / Turkiye
- Contact:
Re: DEFINE REPORT (with filtered data)
OKandyglezl wrote: Sorry about that Esgici
But with the exception of the "titles" and arrangements of "days" of the week and "months"
(already translated with google) the rest is variables, fields, and Harbour HMG language ...
here goes again translated into English
Thank to your extra efforts
![Smile :)](./images/smilies/icon_e_smile.gif)
Viva HMG
![Very Happy :D](./images/smilies/icon_e_biggrin.gif)
Viva INTERNATIONAL HMG ![Very Happy :D](./images/smilies/icon_e_biggrin.gif)
![Very Happy :D](./images/smilies/icon_e_biggrin.gif)
- danielmaximiliano
- Posts: 2612
- Joined: Fri Apr 09, 2010 4:53 pm
- Location: Argentina
- Contact:
Re: DEFINE REPORT (with filtered data)
Gracias por compartir Andy....
probando.....
probando.....
*´¨)
¸.·´¸.·*´¨) ¸.·*¨)
(¸.·´. (¸.·` *
.·`. Harbour/HMG : It's magic !
(¸.·``··*
Saludos / Regards
DaNiElMaXiMiLiAnO
Whatsapp. := +54901169026142
Telegram Name := DaNiElMaXiMiLiAnO
¸.·´¸.·*´¨) ¸.·*¨)
(¸.·´. (¸.·` *
.·`. Harbour/HMG : It's magic !
(¸.·``··*
Saludos / Regards
DaNiElMaXiMiLiAnO
Whatsapp. := +54901169026142
Telegram Name := DaNiElMaXiMiLiAnO
- Pablo César
- Posts: 4059
- Joined: Wed Sep 08, 2010 1:18 pm
- Location: Curitiba - Brasil
Re: DEFINE REPORT (with filtered data)
Buena solucion André, felicitaciones. Creando un dbf virtual, buena idea !andyglezl wrote:Lo solucione asi, espero que les sirva !
![Smile :)](./images/smilies/icon_e_smile.gif)
---
Good solution André, congratulations. Creating a virtual dbf, good idea !
HMGing a better world
"Matter tells space how to curve, space tells matter how to move."
Albert Einstein
"Matter tells space how to curve, space tells matter how to move."
Albert Einstein
- SALINETAS24
- Posts: 667
- Joined: Tue Feb 27, 2018 3:06 am
- DBs Used: DBF
- Contact:
Re: DEFINE REPORT (with filtered data)
Es una opción que nos saca del apuro, pero no es muy ortodoxa. El sistema trabaja el doble, por un lado procesando y grabando y despues sacando el REPORT.
Lo suyo sería que se implementara dentro de la misma funcion de activacion, como ya la teníamos para el Clipper 5,2.
Pero muchas gracias por la idea.
ACTIVATE REPORT rptComis ;
WHILE ! Clien ->( EoF() ) .AND. LASTKEY(INKEY())!=K_ESC ;
.AND. Clien->NUMERO <= nFinal ;
ACTION Clien ->( DbSkip() )
Lo suyo sería que se implementara dentro de la misma funcion de activacion, como ya la teníamos para el Clipper 5,2.
Pero muchas gracias por la idea.
ACTIVATE REPORT rptComis ;
WHILE ! Clien ->( EoF() ) .AND. LASTKEY(INKEY())!=K_ESC ;
.AND. Clien->NUMERO <= nFinal ;
ACTION Clien ->( DbSkip() )
Como dijo el gran pensador Hommer Simpson..., - En este mundo solo hay 3 tipos de personas, los que saben contar y los que no. ![Shocked :shock:](./images/smilies/icon_eek.gif)
![Shocked :shock:](./images/smilies/icon_eek.gif)
Re: DEFINE REPORT (with filtered data)
Hola Salinetas
No entiendo que es lo que te preocupa, ya no estamos en la epoca de D.O.S.,
ya no hay problema con el espacio en disco, en memoria, los procesadores
son de varios nucleos, etc. etc. yo lo hice hace 5 años y no tuve problema.
Que equipo tienes ?
No entiendo que es lo que te preocupa, ya no estamos en la epoca de D.O.S.,
ya no hay problema con el espacio en disco, en memoria, los procesadores
son de varios nucleos, etc. etc. yo lo hice hace 5 años y no tuve problema.
Que equipo tienes ?
Andrés González López
Desde Guadalajara, Jalisco. México.
Desde Guadalajara, Jalisco. México.