To implement paging for reports in report designer

• s.lekha

  Right there with Babe

  Points: 766

  More actions

  October 15, 2009 at 6:31 am

  #210966

  Hi all,

  Is there any option to add paging in reports built using report designer? I would like to display only say 20 records per page, is this possible in report designer?

  Any help appreciated.

  Thanks,

  Lekha

• becklery

  Hall of Fame

  Points: 3315

  More actions

  October 20, 2009 at 8:59 am

  #1068268

  Hi, s.lekha.

  RAQ Report can help users to do page break easily. For your problem, you only need to set the number of records on each page as shown below:

  

  Regards,

  becklery.

  RAQ Report: Web-based Excel-like Java reporting tool[/url]

• s.lekha

  Right there with Babe

  Points: 766

  More actions

  October 20, 2009 at 10:47 pm

  #1068666

  Hi,

  Thanks for the response. I have come across your posts regarding RAQ reports, but iam not familiar with this tool. Is this a reporting tool like SSRS? As Iam using SSRS for creating reports, will be helpful if there are any workarounds with this like RAQ.

  Regards,

  lekha

• nigel.

  SSChampion

  Points: 11636

  More actions

  October 21, 2009 at 7:21 am

  #1068845

  Yes, you can use grouping, and do a page break after each group.

  You'll need an additional grouping column in your dataset which you can produce something like this:

  select groupnumber = (ROW_NUMBER() OVER(ORDER BY somedata)-1)/3 -- Change this constant to set the group size,

  * from

  (

  select somedata = '1'

  union

  select '2'

  union

  select '3'

  union

  select '4'

  union

  select '5'

  union

  select '6'

  union

  select '7'

  union

  select '8'

  ) s1

  Where the subquery is your report data.

  Nigel
  How to post questions