FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour Data groups on xBrowse
Posts: 883
Joined: Tue Oct 11, 2005 11:57 AM
Data groups on xBrowse
Posted: Mon Mar 05, 2012 07:12 PM

Hi everybody

As I asked in the spanish forum, does anyone know or have an idea on how to cretae groups of data in a xbrowse
I need to group some info and show its subtotals

For ex. I have a query of a store, and need to separate diferent cashiers from each other and show its subtotal.

Any idea or tip will be appreciated.

Thanks in advance.

;-) Ji,ji,ji... buena la cosa... "all you need is code"

http://www.xdata.cl - Desarrollo Inteligente
----------
Asus TUF F15, 32GB Ram, 2 * 1 TB NVME M.2, GTX 1650
Posts: 44158
Joined: Thu Oct 06, 2005 05:47 PM
Re: Data groups on xBrowse
Posted: Mon Mar 05, 2012 09:18 PM
Adolfo,

Have a look at FWH\samples\xbgrpsum.prg:

regards, saludos

Antonio Linares
www.fivetechsoft.com
Posts: 883
Joined: Tue Oct 11, 2005 11:57 AM
Re: Data groups on xBrowse
Posted: Mon Mar 05, 2012 11:17 PM
Thanks for your answer Antonio... but what I'll like to do is something like this

http://imageshack.us/photo/my-images/851/ejemploj.jpg/

could it be done by actual xBrowse..
;-) Ji,ji,ji... buena la cosa... "all you need is code"

http://www.xdata.cl - Desarrollo Inteligente
----------
Asus TUF F15, 32GB Ram, 2 * 1 TB NVME M.2, GTX 1650
Posts: 368
Joined: Sun May 31, 2009 06:25 PM
Re: Data groups on xBrowse
Posted: Tue Mar 06, 2012 01:11 AM

If you are browsing an array it should be easy to do, but direct fron database I do not see how it can be done.

Regards,



André Dutheil

FWH 13.04 + HB 3.2 + MSVS 10
Posts: 368
Joined: Sun May 31, 2009 06:25 PM
Re: Data groups on xBrowse
Posted: Tue Mar 06, 2012 01:15 AM
Antonio,

FWH\samples\xbgrpsum.prg


I noticed when you print a report the columns group headers are lost. Is there a way to make columns group headers in treport?
Regards,



André Dutheil

FWH 13.04 + HB 3.2 + MSVS 10
Posts: 883
Joined: Tue Oct 11, 2005 11:57 AM
Re: Data groups on xBrowse
Posted: Tue Mar 06, 2012 01:23 AM

Adutheil...

I Could try to import the data to an array, it could be a solution...
But I think I'll need to use the same approach to a number of reports, so It'll be nice to have an option on xBrowse, something like.

oBrw:bSetGroup:={|| oQry:ID }
oBrw:cGroupTitle:={|| "Another Group " + STR(oQry:ID) }
oBrw:lGroupTotals:=.T.

...looks pretty easy.. ja ja, but I know there'll be a lot of code associated to that possibility.

Aduthiel, Gonna try to use an ARRAY, at this point this will be the only solution to my problem.

Thanks.
From Chile
Adolfo

;-) Ji,ji,ji... buena la cosa... "all you need is code"

http://www.xdata.cl - Desarrollo Inteligente
----------
Asus TUF F15, 32GB Ram, 2 * 1 TB NVME M.2, GTX 1650
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM
Re: Data groups on xBrowse
Posted: Thu Mar 08, 2012 08:53 PM
Please try \fwh\samples\testmerg.prg for a similar example.

Regards



G. N. Rao.

Hyderabad, India

Continue the discussion