knowledge-database (beta)

Current group: dbase.reports

Record count total

Record count total  
Rick Beers
 Re: Record count total  
Rick Beers
From:Rick Beers
Subject:Record count total
Date:Mon, 29 Nov 2004 15:48:23 -0600
I've got a report with an sql statement something like:

select * from table order by x, y

In the report, nothing appears in the detailband. I've got two groups on the
report with totals in the second group. Totals for numeric fields aren't the
problem.

The problem: I need a total record count for each x, y iteration.

Any suggestions?

Thanks,

Rick
From:Rick Beers
Subject:Re: Record count total
Date:Tue, 30 Nov 2004 10:56:47 -0600
> The problem: I need a total record count for each x, y iteration.
>
> Any suggestions?

Yea, dummy. Try reading the OLH for agcount, such as:

this.parent.parent.agcount({||this.parent.rowset.fields["your_field"].value})


Sincerely,

Yourself
   

Copyright © 2006 knowledge-database   -   All rights reserved