Home » Developer & Programmer » Forms » Sum option in Report (Form6i)
Sum option in Report [message #610755] Mon, 24 March 2014 02:51 Go to next message
mehboob110233
Messages: 55
Registered: February 2014
Location: Pakistan
Member

Dear all,
I have group left report.
one column have sum at group level and report level.

now i want to do...
that when group have more the one record then the sum column at group level show else only record will disply.

how can i do that..

Re: Sum option in Report [message #610756 is a reply to message #610755] Mon, 24 March 2014 02:55 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
With a format trigger which would return TRUE if number of records > 1 (otherwise, it would return FALSE and summary item wouldn't be displayed).
Re: Sum option in Report [message #610757 is a reply to message #610756] Mon, 24 March 2014 02:57 Go to previous messageGo to next message
mehboob110233
Messages: 55
Registered: February 2014
Location: Pakistan
Member

how can i get number of record in this group i am new please guide me steps
Re: Sum option in Report [message #610758 is a reply to message #610757] Mon, 24 March 2014 02:58 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
The same way you created a summary column - it would use COUNT function instead of SUM.
Re: Sum option in Report [message #610759 is a reply to message #610758] Mon, 24 March 2014 03:08 Go to previous message
mehboob110233
Messages: 55
Registered: February 2014
Location: Pakistan
Member

Thanks Sir,
Thank you very Much....
Previous Topic: Issue in Fin Query screen
Next Topic: populating a multi-record block using cursors
Goto Forum:
  


Current Time: Thu Mar 28 17:26:52 CDT 2024