Data groups on xBrowse

Data groups on xBrowse

Postby Adolfo » Mon Mar 05, 2012 7: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
User avatar
Adolfo
 
Posts: 860
Joined: Tue Oct 11, 2005 11:57 am
Location: Chile

Re: Data groups on xBrowse

Postby Antonio Linares » Mon Mar 05, 2012 9:18 pm

Adolfo,

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

Image
regards, saludos

Antonio Linares
www.fivetechsoft.com
User avatar
Antonio Linares
Site Admin
 
Posts: 42087
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain

Re: Data groups on xBrowse

Postby Adolfo » 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
User avatar
Adolfo
 
Posts: 860
Joined: Tue Oct 11, 2005 11:57 am
Location: Chile

Re: Data groups on xBrowse

Postby ADutheil » Tue Mar 06, 2012 1: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
ADutheil
 
Posts: 368
Joined: Sun May 31, 2009 6:25 pm
Location: Salvador - Bahia - Brazil

Re: Data groups on xBrowse

Postby ADutheil » Tue Mar 06, 2012 1: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
ADutheil
 
Posts: 368
Joined: Sun May 31, 2009 6:25 pm
Location: Salvador - Bahia - Brazil

Re: Data groups on xBrowse

Postby Adolfo » Tue Mar 06, 2012 1: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
User avatar
Adolfo
 
Posts: 860
Joined: Tue Oct 11, 2005 11:57 am
Location: Chile

Re: Data groups on xBrowse

Postby nageswaragunupudi » Thu Mar 08, 2012 8:53 pm

Please try \fwh\samples\testmerg.prg for a similar example.

Image
Regards

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
 
Posts: 10632
Joined: Sun Nov 19, 2006 5:22 am
Location: India


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: No registered users and 78 guests