hi all, i'm using Dynamic Nav 5.0 Sp1, i want to show my total page in my report, anybody have idea how to calculate total page in report? thanks for help me ^^
You should add a new footer section: select report DataItem, View -> Sections, press F3 and select "Footer" section type.
Create a textbox with the the field you want to totalize and add the same field in the "TotalFields" property of the DataItem.
there is no easy way to show "page n of m" in classic reports. But this is a topic that gets asked a lot and there have been workarounds posted before, so i suggest you use the search.
Try like this:
Eg there is a customer table first count the total no of records
make a variable totalrecrds:= Customer.Count
then chech how many records are getting printed on a page
like there are total 60 records and on one page total records printing at a time are 10
then divide the total no of records by 10
if (totalrcrds mod 10 =0) then
qut:= totlrcrds div 10
else
qut:=(totalrcrds div 10) + 1
and write like this
page currreport.pageno of qut
so it will print like this page 1 of 6, page 2 of 6 etc.
Comments
Create a textbox with the the field you want to totalize and add the same field in the "TotalFields" property of the DataItem.
Eg there is a customer table first count the total no of records
make a variable totalrecrds:= Customer.Count
then chech how many records are getting printed on a page
like there are total 60 records and on one page total records printing at a time are 10
then divide the total no of records by 10
if (totalrcrds mod 10 =0) then
qut:= totlrcrds div 10
else
qut:=(totalrcrds div 10) + 1
and write like this
page currreport.pageno of qut
so it will print like this page 1 of 6, page 2 of 6 etc.
hope it will help you....