If I want to create a Group that is Group by page,Is that feasible?

[Former Member]

Hi, Expert

I want to limit record number(50 records) per page,

and it will have a total column which is amount Salary,

so now I had set some formulas into report

First(in report Details)

-

---

WhilePrintingRecords;

Global numbervar DataCount := DataCount + 1;

ps.This variable counts record number and limits record within 50 records per page

when record passover 50, it will re-set variable to 0(this formulas set in Group Footer)

-

---

second(in Group Footer)

-

---

WhilePrintingRecords;

Global numbervar DataCount := 0;

ps.for re-set variable

-

---

third(New Page After)

-

---

Truncate ({@DataCount}/50)*50={@DataCount} and OnLastRecord=false

ps.For Next page

-

---

Fourth

-

---

WhilePrintingRecords;

Global numbervar pagetol;

salarytol:=salarytol +{table;1.amount}

-

---

Fifth

-

---

Global numbervar pagetol;

if (Truncate ({@DataCount}/50)*50)={@DataCount} then

pagetol:=0;

-

---

If I want to create a Group that is Group by page(50 records per page), because I want

to grand total of salary per page,Is that feasible?

How to achieve this goal??

Thanks & Regards

[Former Member · Accepted solution]

You could use a Variable to sum salary, display in page footer and reset in page header.

This requires 3 formula

For details

@eval

Whileprintingrecords;

global numbervar salary:= salary+ SalaryField

Pageheader

@reset

Whileprintingrecords;

global numbervar salary:= 0;

Pagefooter

@display

Whileprintingrecords;

global numbervar salary;

Ian

[Former Member · Accepted solution]

Thanks lanWaterMan

Actually, my care is Report View,

my report will have Three Summary columns,

one is for 50 records,

second is for data type,

another is for all of records.

I will put the First Summary column behind(below) the last records

So it will look like "Grand total"(for 50 records 1 total).

And the Second Summary column will lay on Group footer(sum data group by data type).

And the last Summary column will lay on every page's bottom(sum all of data).

If I put first summary column in page footer, It will lay on bottom of page, not behind the last records(per fiftieth record).

So I think if I create group1 for 50 records(put in first Summary column on group1 footer) and group2 for data type(put in second Summary column on group2 footer),

then put the last summary column into page footer. Maybe, it will look like what i want.

Thanks & Regards

[Former Member · Accepted solution]

Really Thanks your time...

In the end, I went to group data in DB, Added a Column to separate each data, and use this column to Sum and count.

I thought this is more easy and more efficient way to solve my problem..

Really appreciate

Thanks and Best Regards