|
| Re: Keep a group together |
 |
Sat, 12 Jan 2008 09:19:32 -080 |
Kurt Tanner wrote:
> Hi
> There is an example in the Reports Book of Ken Mayer, page 221. His
> example is based on a Parent/Child report. As I reach the same with a
> report with only one table? GroupBy = "Konto_Nr".
> dBASE PLUS 2.5.
> Greetings from Switzerland.
You can certainly group a single table using the same techniques ...
Ken
--
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/
*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase/dBASEBooks.htm
|
| Post Reply
|
| Keep a group together |
 |
Sat, 12 Jan 2008 10:20:10 +010 |
Hi
There is an example in the Reports Book of Ken Mayer, page 221. His
example is based on a Parent/Child report. As I reach the same with a
report with only one table? GroupBy = "Konto_Nr".
dBASE PLUS 2.5.
Greetings from Switzerland.
|
| Post Reply
|
| Re: Keep a group together |
 |
Sat, 12 Jan 2008 11:06:30 -080 |
Kurt Tanner wrote:
> Ken Mayer [dBVIPS] schrieb:
>
>> You can certainly group a single table using the same techniques ...
> ----------------------------
> I tried it but I failed with the attempt to count the lines in the
> following group.
You're using AGCount() right?
It should work. You'll unfortunately need to tell more details ...
Ken
--
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/
*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase/dBASEBooks.htm
|
| Post Reply
|
| Re: Keep a group together |
 |
Sat, 12 Jan 2008 18:42:48 +010 |
Ken Mayer [dBVIPS] schrieb:
> You can certainly group a single table using the same techniques ...
----------------------------
I tried it but I failed with the attempt to count the lines in the
following group.
|
| Post Reply
|
| Re: Keep a group together |
 |
Sun, 13 Jan 2008 07:10:50 -080 |
Kurt Tanner wrote:
> Ken Mayer [dBVIPS] schrieb:
> You'll unfortunately need to tell more details ...
> ------------------------
> Hi
> I tried it as follows:
>
> function FOOTERBAND_onRender
> local nZahl
> nZahl = this.parent.agCount ({||this.parent.rowset.fields
> [“Konto_Nr”] .value})
> msgbox (“number of data records: ” + nZahl)
> return
>
> That counts the lines of the group just printed out. I need however the
> number of the lines in the following group.
>
> When the function footerband_onRender ist executed, the row-Pointer is
> on the latest row of the group just streamed out. If I move the Pointer
> with "this.parent.parent.parent.buchung071.rowset.next()" to the
next
> row, that is the first row of the next group, the result is the same:
> the rows of the previous group are counted.
I am not sure you can do what you want, without writing special code to
do it. The way group aggregate calculations work is to deal with the
group that was just processed not looking forward to the next group.
Ken
--
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/
*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase/dBASEBooks.htm
|
| Post Reply
|
|
|
|
|
|
|
|
|
|