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?

Report message to a moderator

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: 21765
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?

Report message to a moderator

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....

Report message to a moderator

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.

Report message to a moderator

Re: number of record [message #623783 is a reply to message #623769] Sun, 14 September 2014 13:25 Go to previous message
Littlefoot
Messages: 21765
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
So reset it at desired (master) group.

Report message to a moderator

Previous Topic: do not show details of detail Query
Next Topic: set format trigger=return(false) for a parent frame
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue May 30 18:53:21 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.