Create a Table of Contents in Reporting Services

Hi,
I need to be able to create a Table of Contents for a Price List
Catalog in Reporting Services. Using the AdventureWorks example report
(Product Catalog.rdl), I need to be able to create something similar to
the following:
Table of Contents
Accessories
Bike Racks 2
Bike Stands 2
Bottles and Cages 3
Cleaners 4
Fenders 4
Helmets 5
Hydration Packs 5
Lights 6
Locks 7
Panniers 7
Pumps 8
Tires and Tubes 8
Bikes
Mountain Bikes 13
Road Bikes 15
Touring Bikes 19
Clothing
Bib-Shorts 22
Gloves 23
Jerseys 24
Shorts 25
etc.
It seems that Reporting Services would have something built into it to
do this since it is similar to the Document Mapping feature, but I have
not been able to locate it. Has anyone out there done this? Or have
any suggestions?
Thanks in advance,
Amy BoldenDoes these values all come from a data set? Then you could give you the
names of the items if you create a table against that dataset, and just show
the categories and subcategories. I'm not sure how you could do the page
numbers, though. In first case, I find that page numbers sometimes get
really mixed up when you save a report to PDF, because it behaves
differently in the browser than in the exported document. Also, I'm not sure
if you can pick up the page numbers that the report renders. You might be
able to do some tricks by counting items in each subcategory and dividing
them by a given number of rows, which would approximately give you the right
page numbers.
Do you have to have the page numbers? If not, you can use Jump to navigation
to jump from the table of contents to any of the items in your report /
catalogue.
Kaisa M. Lindahl Lervik
"Amy" <abolden@.lexington.com> wrote in message
news:1164643397.216130.159050@.j72g2000cwa.googlegroups.com...
> Hi,
> I need to be able to create a Table of Contents for a Price List
> Catalog in Reporting Services. Using the AdventureWorks example report
> (Product Catalog.rdl), I need to be able to create something similar to
> the following:
> Table of Contents
> Accessories
> Bike Racks 2
> Bike Stands 2
> Bottles and Cages 3
> Cleaners 4
> Fenders 4
> Helmets 5
> Hydration Packs 5
> Lights 6
> Locks 7
> Panniers 7
> Pumps 8
> Tires and Tubes 8
> Bikes
> Mountain Bikes 13
> Road Bikes 15
> Touring Bikes 19
> Clothing
> Bib-Shorts 22
> Gloves 23
> Jerseys 24
> Shorts 25
> etc.
> It seems that Reporting Services would have something built into it to
> do this since it is similar to the Document Mapping feature, but I have
> not been able to locate it. Has anyone out there done this? Or have
> any suggestions?
> Thanks in advance,
> Amy Bolden
>