Skip to Content
0
Former Member
Jul 06, 2010 at 12:19 PM

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

9 Views

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