Page 1 of 3

DEFINE REPORT (with filtered data)

Posted: Tue Aug 13, 2013 2:58 am
by andyglezl
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.

Re: DEFINE REPORT (with filtered data)

Posted: Tue Aug 13, 2013 10:17 am
by esgici
andyglezl 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.
Hola Andy

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 ;)

Happy HMG'ing :D

Re: DEFINE REPORT (with filtered data)

Posted: Tue Aug 13, 2013 5:44 pm
by andyglezl
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!

Re: DEFINE REPORT (with filtered data)

Posted: Tue Aug 13, 2013 6:16 pm
by esgici
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!
Congrats !

You have ask a question and also you respond by a way more complex than mine :)

Sadly, since I don't know your language, it not served to me in any manner :(

Anyway, Viva HMG :D

Re: DEFINE REPORT (with filtered data)

Posted: Tue Aug 13, 2013 9:00 pm
by andyglezl
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

Re: DEFINE REPORT (with filtered data)

Posted: Tue Aug 13, 2013 9:10 pm
by esgici
andyglezl 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
OK

Thank to your extra efforts :)

Viva HMG :D

Re: DEFINE REPORT (with filtered data)

Posted: Tue Aug 13, 2013 9:41 pm
by danielmaximiliano
Gracias por compartir Andy....


probando.....

Re: DEFINE REPORT (with filtered data)

Posted: Tue Aug 13, 2013 10:43 pm
by Pablo César
andyglezl wrote:Lo solucione asi, espero que les sirva !
Buena solucion André, felicitaciones. Creando un dbf virtual, buena idea ! :)

---

Good solution André, congratulations. Creating a virtual dbf, good idea !

Re: DEFINE REPORT (with filtered data)

Posted: Sun Apr 08, 2018 9:44 pm
by SALINETAS24
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() )

Re: DEFINE REPORT (with filtered data)

Posted: Mon Apr 09, 2018 1:35 am
by andyglezl
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 ?