OraFAQ Forum: Forms » GROUP BY BLOCK ON FORM

Home » Developer & Programmer » Forms » GROUP BY BLOCK ON FORM

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

GROUP BY BLOCK ON FORM [message #324915]

Wed, 04 June 2008 08:43

irfan.ocp
Messages: 29
Registered: February 2008
Location: Karachi, Pakistan

Junior Member

Dear Friends.

I have 2 blocks on form. first is fetching record from cursor. and second i want to use to get sum amount by group. let me explain you in detail.

BLOCK 1

ITEM	AMOUNT
----	------ 
A1	200
A2	200
A3	200
A4	200
A1	250
A1	250
A2	200
A3	200

ITS DISPLAYING ON BLOCK FIELDS

NOW ON SECOND BLOCK GET SUM OF AMOUNT GROUPING BY ITEM.

ITEM	AMOUNT
----	------ 
A1	700
A2	400
A3	400
A4	200

BUT ONE THING. I DON'T WANT TO REUSE ABOVE CURSOR. CAN I DO BY THE HELP OF FOR-LOOP ON FORM.

THANKS.

Report message to a moderator

Re: GROUP BY BLOCK ON FORM [message #335386 is a reply to message #324915]

Tue, 22 July 2008 01:00

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Have you solved your problem?

Look at 'calculation' attributes.

David

Report message to a moderator

Previous Topic:	search form
Next Topic:	WHERE CURRENT OF

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 12 01:53:39 CDT 2025