Total Page Number reset at Lvl Break

[jdeking1]

hii ,
I have a requirement wherein i have to have the total page # reset at lvl break , i.e if there are 3 orders in a report with 2 ,3 and 5 pages.,
the page numbers should display as 1 of 2 , 2of 2 for Ist order and for second order it should be 1 of 3 ,2 of 3 and 3 of 3 .. , and for 3rd order it should be 1 of 5 ,2 of 5 , 3 of 5, 4 of 5 , 5 of 5.

I tried referring post # 111084 , but what i get is 1 of 5 , 2 of 5 for the Ist order and 1 of 5 , 2of 5 , 3of 5 for the second order and 1 of 5, 2 of 5 ,3 of 5 , 4 of 5 ,5 of 5 with the last order . This is the same case with the set report page number bsfn , i used the logic like this :

in page header
Do section
if var X = 1
call BSFN to reset page number to 1 .
Var X 0
ENDIF

In intialize section for driver section
VAR X = 1.

In End lvl break footer event forlvl break footer section

VAR x =1 .

It simply doesnt work.

appreciate any efforts to help.

thanks,
raj,
[email protected]
E8.12, 8.97 tools release.UNIX.


111084

 

[Rayxue]

Raj,

I guess it's difficult to know total pages for each order if there are more than one orders in the job. But normally these report will print by tool like Formscape / Crate!Form, so you can solve the issue by the tool instead of JDE self.

 

[sviardot]

i wrote this bsfn with XE API.
don't test with 8.12 but thinks it could be adapted from original bsfn (98...).

 

[jdeking1]

thank you Rayxue , but i was looking for a soluton within JDEdwards.

 

[jitender]

Hi Jdeking1

Don't take runtime page number in the report .create your own.

Take counter variables to count the no of records each time.

we have three orders
1)with 5 records
2)with 3 records

3)with seven records.

in the level break header nullify the counter variable ,
in the do section increment the counter variable
in the level break footer clear again this counter variable.


I think it will solve your problem.

Regards
Jitender