Row count per page with increment and total row count

• iBar

  SSCertifiable

  Points: 5872

  More actions

  November 4, 2010 at 4:44 pm

  #240905

  Hello Guys,

  I have a report of 300 page

  each page contains 25/26 rows depending on data

  in footer, i need how many rows are there and total row count

  result should as following

  Page 1 : 25 records out of 7600

  Page 2 : 50 records out of 7600

  Page 3 : 76 records out of 7600

  Page 4 : 100 records out of 7600

  .

  .

  .

  Paqe N : 7600 records out of 7600

  Any idea about this please.

  Cheers

• iBar

  SSCertifiable

  Points: 5872

  More actions

  November 9, 2010 at 5:56 am

  #1248179

  Got it.

  Added two hidden column in the table

  Textbox1 =RowNumber("DataSet1")

  TestBox2 =1

  Now in report footer Added following 3 TextBoxes with expressions

  TextBox3 = =MIN(ReportItems!textbox1.Value) -- For first record number

  TextBox4 = =MAX(ReportItems!textbox1.Value) -- For last record number

  TextBox5 = =SUM(ReportItems!textbox2.Value) -- For number of records on that page

  TextBox6 = can get using =countRows() -- For total number of records in that report. But you can only use this in detailed section.

  Thanks everyone for viewing this.

  Cheers.