SSRS:generate table of contents

• gdutt79-992333

  SSC Veteran

  Points: 205

  More actions

  October 18, 2011 at 10:25 pm

  #250303

  Hi,

  I need to generate user manual like dynamic report. Report is divided into 10 group and each group need to be in "Table of contents" with page number. Page number for each group is change for every report.

  Please help me.

  Table of Content:

  Group Page

  Grp 1 1

  Grp 2 10

  Grp 3 15

  Grp 4 21

  Grp 5 26

  Grp 6 30

  Grp 7 43

  Grp 8 52.

  .

  .

  .

  .

• okbangas

  SSChampion

  Points: 11773

  More actions

  October 19, 2011 at 5:07 am

  #1396546

  As far as I know, there is no way to do this. When SQL Server start processing the report, it retrieves all the data fro that report, then it renders the first page only. SQL Server does not know how many pages there will be in the report, and definitely not on what page a specific element will start. This is by design to improve the response time from the report server.

  ---

  
  Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter

  Concatenating Row Values in Transact-SQL[/url]

• onlygoodones

  SSC Eights!

  Points: 870

  More actions

  October 19, 2011 at 8:37 am

  #1396677

  This might help you partially: please go through the links below.

  http://stackoverflow.com/questions/2592300/filler-dots-for-table-of-contents-in-reporting-services

  http://www.bidn.com/blogs/Anil/ssas/1441/sql-server-reporting-services-generating-manual-table-of-content-toc-for-pdf-report-output

  I found this video too: http://www.youtube.com/watch?v=fWPrbOOBod4