Source language: Translate to:

COUNT & SUM fuctions are working in Report Designer

Questions about our Advanced Database plug-in

Moderator: Neosoft Support

COUNT & SUM fuctions are working in Report Designer

Postby smartmedia » Fri May 16, 2008 3:32 am

Hi...

COUNT & SUM fuctions are working in Report Designer...???
I wonder since i have create some examples in 1.1d and seems that is not working...
I use this:
COUNT( [oximata] )
oximata is the table in database.
As return i get 0 insted of 2 wich are the records in database

Help say this:
Returns the number of records in a database table. If a query is active, the count will include only those records matching the query. It is not necessary to include the field name portion of the variable for this function. For example:

COUNT( [Orders] )


Any one has the same results...???
User avatar
smartmedia
 
Posts: 889
Joined: Fri Apr 01, 2005 6:50 am
Location: Hellas

Postby Neosoft Support » Fri May 16, 2008 11:46 am

The Count and Sum functions generally will only work when placed onto a Report Summary or Footer type Partition. Placing them elsewhere on a report will yield unpredictable results. This is documented in the help file for the Sum function, but not for the Count function. This will be corrected in the next update to the help file.
NeoSoft Support
Neosoft Support
NeoSoft Team
 
Posts: 5593
Joined: Thu Mar 31, 2005 10:48 pm
Location: Oregon, USA

Postby smartmedia » Sat May 17, 2008 11:44 pm

Hi...

Dave, in help dosen't say anything about this...
The Count and Sum functions generally will only work when placed onto a Report Summary or Footer type Partition. Placing them elsewhere on a report will yield unpredictable results.


Thanks.
User avatar
smartmedia
 
Posts: 889
Joined: Fri Apr 01, 2005 6:50 am
Location: Hellas

Postby Gaev » Sun May 18, 2008 6:20 am

smartmedia:

In the help file called ReportDesigner.chm (NOT NeoBookDBPro.chm) ...
The Formula object supports the following functions:

AVG Calculate the average value of a single field from each record in a database table. If a search query is active, only records matching the query will be included in the calculation. For example: AVG( [Orders.UnitPrice] )

COUNT Returns the number of records in a database table. If a query is active, the count will include only those records matching the query. It is not necessary to include the field name portion of the variable for this function. For example: COUNT( [Orders] )

SUM Calculate the sum of a single field from each record in a database table. If a search query is active, only records matching the query will be included in the calculation. For example: SUM( [Orders.TotalPrice] )

MIN Calculate the minimum value of a single field from each record in a database table. If a search query is active, only records matching the query will be included in the calculation. For example: MIN( [Students.Age] )

MAX Calculate the maximum value of a single field from each record in a database table. If a search query is active, only records matching the query will be included in the calculation. For example: MAX( Students.Age] )

... etc. etc. ...
... and at the bottom of the list ...
Note: Functions in red generally will only work when placed onto a Report Summary or Footer type Partition. Placing them elsewhere on a report will yield unpredictable results.


Currently, the word COUNT is shown in black ... the correction Dave is talking about is to show it in Red in the next update of the Help file.
User avatar
Gaev
 
Posts: 3718
Joined: Fri Apr 01, 2005 7:48 am
Location: Toronto, Canada


Return to NeoBookDBPro

Who is online

Users browsing this forum: No registered users and 1 guest