Home » Developer & Programmer » Forms » GROUP BY BLOCK ON FORM
GROUP BY BLOCK ON FORM [message #324915] Wed, 04 June 2008 08:43 Go to next message
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.
Re: GROUP BY BLOCK ON FORM [message #335386 is a reply to message #324915] Tue, 22 July 2008 01:00 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

Look at 'calculation' attributes.

David
Previous Topic: search form
Next Topic: WHERE CURRENT OF
Goto Forum:
  


Current Time: Fri Dec 09 08:12:17 CST 2016

Total time taken to generate the page: 0.06465 seconds