U2U Blog

for developers and other creative minds

Creating a Table Of Content in Reporting Services 2008

In Reporting Services 2005 we have document maps which creates an interactive table of content (TOC): every entry is a hyperlink. Nice for interactive use, but nearly useless when you render your report for printing. In print, we want page numbers, which is very, very hard to get in SSRS2005.

In Reporting Services 2008, it is still very hard to get a TOC with page numbers... unless you render to Word!

So, go ahead, deploy the Adventureworks Sample reports, open up the Product Catalog report and verify it has a document map in it. Next, export this to a Word file (it uses Word 2000, which can easily be used by Office 2002, 2003 and 2007 as well). Open up the Word file. There is no TOC in there, but we can create one explicitly. Only, do not be to hasty! If you create a regular TOC, it will use the Heading styles to place them in the TOC, and the Word export does not have Heading styled elements. So we have to create the TOC. In Word 2007, go to the References ribbon, click the Table Of Content button, and select Insert table of content. Next, click the Options... button, and in there, deselect Styles and select Table entry fields. Next, click twice the OK button and enjoy your TOC!

image

Comments (80) -

  • tents

    6/10/2015 8:57:07 AM | Reply

    your intelligence on just posting videos to your site when you

  • www.boletineselectricos.es

    6/10/2015 1:18:48 PM | Reply

    I truly appreciate this article.Thanks Again. Much obliged.

  • unique antiques

    6/13/2015 11:31:58 AM | Reply

    I think this is a real great post.Really looking forward to read more. Cool.

  • Recycled Cement for Driveways

    6/14/2015 9:05:28 AM | Reply

    Very neat blog post. Great.

  • resin driveways direct

    6/14/2015 2:27:25 PM | Reply

    Thank you for your blog post. Fantastic.

  • rental mobil di manado

    6/14/2015 3:37:50 PM | Reply

    Im thankful for the article post.Really looking forward to read more. Much obliged.

  • fett weg faktor download

    6/15/2015 11:33:56 AM | Reply

    Im obliged for the blog post.Thanks Again. Great.

  • miracolo per acufeni

    6/15/2015 1:02:01 PM | Reply

    Great article.Really thank you! Awesome.

  • miracolo per acufeni download gratis

    6/15/2015 6:14:44 PM | Reply

    Great, thanks for sharing this blog article.Really thank you! Cool.

  • libera dalla cellulite joey atlas opinioni

    6/15/2015 11:33:11 PM | Reply

    Hey, thanks for the blog post.Really looking forward to read more.

  • Best Buy iPhone Samsung Charger Cables

    6/16/2015 3:03:44 AM | Reply

    Hey, thanks for the blog.Thanks Again. Cool.

  • electricistas madridejos

    6/16/2015 7:27:25 AM | Reply

    You need to participate in a contest for top-of-the-line blogs on the web. I will suggest this web site!

  • Link Today

    6/16/2015 8:19:26 AM | Reply

    Thank you for your blog.Really looking forward to read more. Great.

  • Rand Spear The Accident Lawyer

    6/16/2015 8:47:41 AM | Reply

    Very good article. I am experiencing many of these issues as well..

  • niespizarniowym

    6/16/2015 10:44:58 AM | Reply

    It’s laborious to find knowledgeable individuals on this topic, however you sound like you already know what you’re talking about! Thanks

  • cerrajeros coche valencia

    6/17/2015 11:31:47 AM | Reply

    Wonderful article! We will be linking to this great article on our website. Keep up the good writing.

  • Travel Choice 2015

    6/17/2015 1:58:08 PM | Reply

    I think this is a real great post.Much thanks again. Fantastic.

  • Travel Choice

    6/17/2015 7:13:21 PM | Reply

    A round of applause for your article post. Really Cool.

  • backlinks generator

    6/18/2015 2:08:52 PM | Reply

    Simply amazing! I know you have actually put a great deal of initiative right into this and I wanted to inform you exactly how thankful I am! Hope you put out even much more incredible stuff in the near future as well as I will certainly come back and also review it!

  • ENVIRONMENTAL CHEMISTRY SERVICES

    6/18/2015 3:45:12 PM | Reply

    What? Happening i am new to this, I stumbled upon this I ave found It positively helpful and it has aided me out loads. I hope to contribute & help other users like its aided me. Great job.

  • backlinks seo

    6/19/2015 12:40:08 AM | Reply

    Merely remarkable! I understand you have placed a great deal of initiative into this and I really wanted to inform you just how thankful I am! Hope you placed out also more amazing things in the close to future and also I will certainly come back as well as read it!

  • cerrajeros burjassot valencia

    6/19/2015 1:28:12 PM | Reply

    I value the blog post.Really looking forward to read more.

  • custom formulations

    6/22/2015 1:35:58 PM | Reply

    Major thankies for the blog article.Much thanks again. Really Cool.

  • Data in June 2015

    6/23/2015 11:16:16 AM | Reply

    Looking forward to reading more. Great post.Thanks Again. Cool.

  • Data in June

    6/23/2015 4:35:38 PM | Reply

    Appreciate you sharing, great post.Really thank you! Cool.

  • old granny fucking

    6/24/2015 3:28:29 AM | Reply

    Fantastic blog post. Really Great.

  • cory everson

    6/24/2015 8:37:30 AM | Reply

    Very neat post.Really thank you! Keep writing.

  • wykrawaczem

    6/24/2015 1:21:47 PM | Reply

    Thanks for sharing your ideas on this blog. Also, a fairy tale regarding the financial institutions intentions when talking about foreclosures is that the traditional bank will not getreceive my payments. There is a degree of time that this bank will need payments occasionally. If you are as well deep in the hole, they may commonly call that you pay the particular payment in whole. However, that doesn't mean that they will not take any sort of repayments at all. In the event you and the bank can be capable to work something out, the foreclosure process may cease. However, when you continue to miss payments in the new plan, the foreclosures process can pick up from where it left off.

  • the coconut oil secret book

    6/25/2015 12:51:51 PM | Reply

    This blog is  without a doubt awesome and besides diverting. I have picked up helluva  useful tips out of this source. I ad love to visit it every once in a while. Cheers!

  • guilt free desserts pdf

    6/25/2015 1:10:26 PM | Reply

    new to the blog world but I am trying to get started and create my own. Do you need any html coding expertise to make your own blog?

  • hack

    6/25/2015 1:24:54 PM | Reply

    I'а†ve read numerous excellent stuff here. Unquestionably worth bookmarking for revisiting. I surprise how lots attempt you set to create this sort of good informative website.

  • the coconut oil secret review

    6/25/2015 1:44:35 PM | Reply

    If you are free to watch humorous videos on the web then I suggest you to pay a visit this website, it consists of really thus funny not only videos but also extra information.

  • guilt free desserts pdf

    6/25/2015 2:02:19 PM | Reply

    Thanks again for the article.Much thanks again. Will read on

  • Protect Your Bubble Reviews

    6/25/2015 2:18:56 PM | Reply

    Wow, incredible blog format! How lengthy have you been blogging for? you made running a blog look easy. The total glance of your site is fantastic, as well as the content material!

  • Toys R us Coupons 2015

    6/25/2015 2:35:21 PM | Reply

    Very good article! We are linking to this particularly great content on our website. Keep up the good writing.

  • Download Driver Printer For Canon Epson Hp Brother Panasonic

    6/25/2015 2:51:17 PM | Reply

    Post writing is also a fun, if you be acquainted with then you

  • Marin Architect

    6/25/2015 3:05:54 PM | Reply

    My partner would like the quantity typically the rs gold excellent to acquire a thing that weighs more than people anticipation.

  • Last Minute Deals Cruises

    6/25/2015 3:36:02 PM | Reply

    You completed a few fine points there. I did a search on the matter and found mainly people will have the same opinion with your blog.

  • ceas winner

    6/25/2015 3:59:10 PM | Reply

    very few internet sites that happen to become comprehensive below, from our point of view are undoubtedly very well worth checking out

  • link building seo

    6/26/2015 2:33:37 AM | Reply

    Not simply quality, but likewise useful information. And also that is rare to come by these days! I have to say that I am really impressed and also will surely come back once more if you maintain up the high quality and also worth of the content at this level, or even get it on the following degree.

  • backlinks 2015

    6/26/2015 4:59:44 AM | Reply

    Legendary! This is merely remarkable! Not just reputable, however additionally valuable information. And that is uncommon to come by nowadays! I need to claim that I am truly pleased and will definitely return once again if you keep up the reputable and value of the material at this degree, or maybe get it on the next level. All the best, from all-time low of my heart, thanks for your time! God bless!

  • sex public

    6/26/2015 6:52:24 AM | Reply

    Looking forward to reading more. Great blog post.Thanks Again. Cool.

  • Mobiltelefoninformation

    6/26/2015 3:07:00 PM | Reply

    I cannot thank you enough for the article post.Thanks Again. Fantastic.

  • Mobil telefonbog

    6/26/2015 8:06:52 PM | Reply

    Thanks a lot for the blog article.Thanks Again.

  • vfstreaminggratuit.net

    6/28/2015 11:43:05 PM | Reply

    Thanks for sharing, this is a fantastic blog.Really thank you! Really Cool.

  • annuaire telephone

    6/29/2015 5:07:11 AM | Reply

    Im grateful for the article post.Really looking forward to read more. Keep writing.

  • June Post 2015

    6/29/2015 7:20:01 AM | Reply

    Hey, thanks for the blog post.Really thank you! Fantastic.

  • sharp solar panels for sale

    6/29/2015 12:56:43 PM | Reply

    I am so grateful for your blog post.Much thanks again. Really Great.

  • My Camp

    6/30/2015 3:06:32 AM | Reply

    A big thank you for your article post.Thanks Again.

  • does

    7/1/2015 12:48:43 AM | Reply

    Fantastic blog.Really thank you! Awesome.

  • www ergohestiaolsztyn pl

    7/3/2015 4:14:13 PM | Reply

    Keep working ,splendid job!

  • tanie-ubezpieczenie.eu

    7/3/2015 5:02:54 PM | Reply

    Hola! I've been following your website for a long time now and finally got the courage to go ahead and give you a shout out from  Dallas Tx! Just wanted to tell you keep up the good job!

  • ubezpieczenia holms.eu

    7/3/2015 5:05:15 PM | Reply

    Fantastic blog! Do you have any recommendations for aspiring writers? I'm hoping to start my own blog soon but I'm a little lost on everything. Would you suggest starting with a free platform like Wordpress or go for a paid option? There are so many options out there that I'm totally confused .. Any tips? Cheers!

  • bibliografia praca licencjacka

    7/3/2015 5:05:24 PM | Reply

    I like the valuable information you provide in your articles. I will bookmark your blog and check again here regularly. I am quite certain I’ll learn lots of new stuff right here! Best of luck for the next!

  • www ergohestiaolsztyn pl

    7/6/2015 1:29:03 AM | Reply

    I wish to point out my passion for your kindness in support of people who absolutely need assistance with your area of interest. Your very own commitment to passing the solution across appeared to be remarkably useful and has usually enabled ladies much like me to realize their dreams. This warm and helpful tips and hints indicates so much to me and still more to my colleagues. Many thanks; from each one of us.

  • korekta prac dyplomowych

    7/6/2015 1:29:04 AM | Reply

    Very efficiently written post. It will be useful to everyone who usess it, including me. Keep up the good work - i will definitely read more posts.

  • backlinks for my website

    7/6/2015 4:40:14 AM | Reply

    Remarkable! Just all the wonderful words apply to this content! Thank you from the bottom of my heart as well as heart as well as I will certainly come visit once again if you maintain up the excellent job!

  • www tanie ubezpieczenia eu

    7/6/2015 5:07:14 AM | Reply

    Thanks for your blog post. I would also love to say a health insurance brokerage also works best for the benefit of the particular coordinators of the group insurance coverage. The health agent is given a directory of benefits looked for by individuals or a group coordinator. What a broker will is seek out individuals or coordinators which often best fit those desires. Then he presents his recommendations and if the two of you agree, the particular broker formulates an agreement between the 2 parties.

  • ubezpieczenia holms.eu

    7/6/2015 5:07:17 AM | Reply

    Superb blog! Do you have any tips for aspiring writers? I'm planning to start my own blog soon but I'm a little lost on everything. Would you propose starting with a free platform like Wordpress or go for a paid option? There are so many choices out there that I'm totally confused .. Any recommendations? Thanks!

  • link building packages

    7/6/2015 8:53:10 AM | Reply

    Famous! This is merely remarkable! Not merely reputable, but also important info. Which is unusual ahead by these days! I have to claim that I am really amazed and also will definitely return once again if you keep up the quality as well as worth of the content at this level, or maybe obtain it on the next degree. Best regards, from all-time low of my heart, thank you for your time! God bless!

  • tanie_ubezpieczenie.eu/

    7/7/2015 5:14:09 PM | Reply

    I am no longer positive the place you're getting your information, however good topic. I must spend some time studying much more or working out more. Thank you for great information I used to be in search of this info for my mission.

  • http://www.hestiaolsztyn.pl/

    7/7/2015 5:14:12 PM | Reply

    Wow! Thank you! I permanently needed to write on my blog something like that. Can I implement a part of your post to my website?

  • www.ubezpieczenia.holms.eu

    7/10/2015 3:23:36 AM | Reply

    Thanks for the helpful content. It is also my belief that mesothelioma cancer has an particularly long latency phase, which means that symptoms of the disease may well not emerge until eventually 30 to 50 years after the 1st exposure to asbestos.  Pleural mesothelioma, that is certainly the most common form and impacts the area around the lungs, could cause shortness of breath, chest pains, including a persistent cough, which may lead to coughing up body.

  • http www hestiaolsztyn pl

    7/10/2015 8:14:52 AM | Reply

    Excellent post. I was checking continuously this blog and I am impressed! Very helpful information specially the last part Smile I care for such info a lot. I was seeking this certain info for a long time. Thank you and good luck.

  • tanie.ubezpieczenia.eu

    7/10/2015 8:14:58 AM | Reply

    Please let me know if you're looking for a article author for your weblog. You have some really great articles and I believe I would be a good asset. If you ever want to take some of the load off, I'd absolutely love to write some content for your blog in exchange for a link back to mine. Please shoot me an email if interested. Kudos!

  • pop over to this website

    7/20/2015 2:00:53 AM | Reply

    I simply want to mention I'm all new to weblog and absolutely enjoyed this web page. More than likely I’m want to bookmark your website . You certainly have fantastic articles and reviews. Many thanks for revealing your web-site.

  • fiverr eebest8

    7/21/2015 1:06:49 AM | Reply

    Your method of describing the whole thing in this paragraph is really nice, all be able to effortlessly be aware of it, Thanks a lot.

  • Bonuses

    8/12/2015 7:07:07 PM | Reply

    I just want to tell you that I'm all new to weblog and honestly loved your blog site. Probably I’m want to bookmark your site . You absolutely come with incredible articles and reviews. Many thanks for sharing your blog site.

  • Hal Eisinger

    8/15/2015 5:22:01 AM | Reply

    I found your blog site on google and check just a few of your early posts. Proceed to maintain up the very good operate. I just additional up your RSS feed to my MSN Information Reader. In search of ahead to reading more from you afterward!…

  • old pussy exam

    8/15/2015 5:56:31 PM | Reply

    I value the blog post. Will read on...

  • what is copywriting

    10/1/2015 3:06:11 AM | Reply

    Simply amazing! I know you have put a lot of initiative into this as well as I desired to tell you exactly how happy I am! Hope you placed out also much more spectacular stuff in the near future and I will come back and review it!

  • read more

    10/9/2015 1:01:30 PM | Reply

    I just want to mention I am all new to weblog and truly liked your blog. Most likely I’m want to bookmark your blog . You definitely have remarkable writings. Thank you for revealing your website.

  • Babbu maan

    10/21/2015 3:12:26 PM | Reply

    I've just checked your posts and i must say that this is one of the simplest and accurate posts blog..great job

  • try here

    11/1/2015 3:14:53 AM | Reply

    I simply want to tell you that I'm very new to blogs and really enjoyed your web blog. Very likely I’m going to bookmark your website . You definitely come with wonderful articles and reviews. Cheers for sharing your web page.

  • pop over to this website

    11/17/2015 1:25:38 AM | Reply

    I just want to tell you that I am just beginner to blogs and absolutely enjoyed this blog site. Almost certainly I’m planning to bookmark your blog . You surely have impressive article content. Regards for revealing your webpage.

  • Ok

    11/29/2015 11:41:50 AM | Reply

    Very interesting  information!Perfect just what I was  searching  for! "If you bungle raising your children, I don't think whatever else you do matters." by Jacqueline Lee Bouvier Kennedy Onassis.

  • Claudette

    11/29/2015 11:44:47 AM | Reply

    Some really great content on this website, regards for contribution. "The key to everything is patience. You get the chicken by hatching the egg, not by smashing it." by Arnold Glasgow.

  • here

    12/3/2015 11:45:52 PM | Reply

    I just want to say I am just new to blogs and certainly savored your page. Likely I’m going to bookmark your site . You amazingly come with very good article content. Regards for sharing your blog site.

  • official statement

    1/25/2016 2:00:57 PM | Reply

    I just want to say I am all new to weblog and certainly loved your web blog. Likely I’m planning to bookmark your website . You amazingly have outstanding articles. Thanks a bunch for sharing with us your web page.

Loading