Hi,
My main report look like this
page1

PH - Animal# test Oper#
Detials 12 test1 1
         13 test2 1
         14 test3 1

PF - Oper#: 1 = User1, 2 = User2


page2

PH - Animal# test Oper#
Detials 1 test1 1
         2 test1 1
         3 test1 2

PF - Oper#: 1 = User1, 2 = User2

My question here is, in page 1 u have only Oper# 1 so in report, near page footer it should show only
Oper#: 1 = User1

I am getting this info aboutt the operator through a sub report.

Thanks,
Kavitha.

Declare a global variable and assign the values in that variable and display in the footer.

i could figure it out from some help in other forums.
this is the solution.

In your main report, create two formulas:

//{@reset} to be placed in the page header:
whileprintingrecords;
shared stringvar x := "";

//{@accum} to be placed in the detail section:
whileprintingrecords;
shared stringvar x;
if instr(x,totext({table.OperNo},"000") = 0 then
x := x + totext({table.OperNo},"000") + ", "; //add as many zeros as digits in the highest operator number

Then in the subreport, place the Operator Number and the Operator Name field. Do not link the subreport to the main report. Instead go to the section expert in the subreport->details->suppress->x+2 and enter:

whileprintingrecords;
shared stringvar x;
instr(x,totext({table.OperNo},"000")) = 0

Make sure the page footer is tall enough to accommodate the maximum number of results per page.