Home » Developer & Programmer » Reports & Discoverer » number of record
number of record [message #623746] Sat, 13 September 2014 23:45 Go to next message
hahaie
Messages: 194
Registered: May 2014
Senior Member
Is there any way of knowing the number of records returned from a query?
Re: number of record [message #623748 is a reply to message #623746] Sun, 14 September 2014 00:40 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Sure.
select count(*)
from (your query goes here);

Or, in PL/SQL, you could use SQL%ROWCOUNT.

Or, in Reports, create a summary column based on the COUNT function.

Or, in Forms, use COUNT_HITS.

Is that enough?
Re: number of record [message #623752 is a reply to message #623748] Sun, 14 September 2014 01:44 Go to previous messageGo to next message
hahaie
Messages: 194
Registered: May 2014
Senior Member
Why do I think?!!!
In my mind was a SRW functions....
Re: number of record [message #623769 is a reply to message #623752] Sun, 14 September 2014 06:05 Go to previous messageGo to next message
hahaie
Messages: 194
Registered: May 2014
Senior Member
In this case::""Or, in Reports, create a summary column based on the COUNT function.""
"Reset As" property,What is equal?report or page?
i think no report and no page.Because this function must be calculated for every master.
Re: number of record [message #623783 is a reply to message #623769] Sun, 14 September 2014 13:25 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
So reset it at desired (master) group.
Previous Topic: do not show details of detail Query
Next Topic: set format trigger=return(false) for a parent frame
Goto Forum:
  


Current Time: Thu Mar 28 06:20:03 CDT 2024