Custom Paging in SSRS

• rexyrexin

  Mr or Mrs. 500

  Points: 562

  More actions

  February 3, 2011 at 5:22 am

  #233723

  Hi,

  Is it possible to have Paging in the Database level instead of the

  application level.

  for example if we have 1000 records my sp will give me first 100 records and

  if i click the next page in SSRS 2005 is it possible to hit the DB again to get next 100 set of records.I am using Report Viewer to view the reports.

• durai nagarajan

  SSCoach

  Points: 15778

  More actions

  February 11, 2011 at 11:20 am

  #1285839

  Hi,

  Hope this is not possible at DB level.

  if it hits DB every time how the number pages can be decided at the first go.

  still this is good doubt let me find another option if possible.

  Regards
  Durai Nagarajan