SQL Server Performance

table of contents in sql server report 2008

Discussion in 'SQL Server 2008 Reporting Services' started by jassie, Mar 6, 2010.

  1. jassie New Member

    I have the following questions about creating sql server 2008 reports:
    I am creating a report that will contain the following:
    a. page header with the title of the report,
    b. page footers that contain the page numbers, and
    c. table of contents to tie about 27 subreports together,
    d. several of the tables in the subreport will appear on more than
    one page.
    Thus, I would like to know how to tie all of this together. I am
    planning on doing the following:
    1. Put the title of the report in a textbox control,
    2. Somehow have logic in the tables to know to wrap to the next page
    if a table exceeds the page limit.
    Thus, could you make suggestions on how to tie all of this together?
  2. satya Moderator

    I believe this can be achieve only from third party tools, its a tricky and complex from SSRS alone to build.
  3. jassie New Member

    What third party tool(s) would you use?

Share This Page