Naming Excel Worksheets using PageName in SSRS



In this post we are gonna discuss about how to export data from a report to multiple sheets WITH NAMES to sheets of an EXCEL. This is a real cool option we have in SSRS. To demonstrate the same I designed a report and the preview of the same is given below.

The above one is a MATRIX format report and if I export the same into EXCEL then all the records will be exported into the same SHEET of excel as shown below.

In the above pic, you can see that all the data is loaded into the same sheet. Now let us see how can we load data into different sheets of an excel. To do so firstly we need to identify how the data or when the data needs to be broke and pushed to next sheet. In this example I will push EACH COLOR information into one sheet. PFB the steps.

  • Right click on the GROUP color and select Group Properties as shown below.

  • Select the page “Page Breaks” and check the option “Between Each instance of the group” as shown below/

  • Now set the Page Name  property by selecting the group and clicking F4. Set the value to the Field COLOR as shown below.
  • Now preview the report and you can see the report is broken into pieces based on color.
  • Export the report and see the data in EXCEL. you can see each color data is pushed to different sheets as shown below.


This is it sirji .. Hope you understood the magic ..

Roopesh Babu V


  1. Thanks! Loads of information.
    [url=]dissertation writers[/url] dissertation research and writing [url=]dissertations services[/url] custom written dissertations

  2. This is nicely said. .
    [url=]do my homework for free[/url] can i just not do my homework [url=]do my math homework[/url] do my homework 123 reviews

  3. Very well voiced truly. .
    [url=]quick essay writer[/url] write my essays online [url=]hire someone to write an essay[/url] i don t know what to write in my essay

  4. You explained it very well.
    [url=]help with my essay[/url] essay write help [url=]help writing a college essay[/url] websites to help with writing essays

  5. You said it adequately..
    [url=]paper writers[/url] write my paper fast [url=]how to write a conclusion for a research paper[/url] how to write a science paper

  6. Seriously all kinds of beneficial material.
    [url=]assignment writing service[/url] linkedin writing service [url=]top essay writing services[/url] what is the best custom essay writing service

  7. Effectively spoken without a doubt! !
    [url=]essay writing help[/url] custom essay writing [url=]cheap essay writing service usa[/url] essay writing service australia

  8. You mentioned it terrifically!
    [url=]do my homework essay[/url] i don t know what to write in my essay [url=]where can i find someone to do my essay[/url] writing argumentative essays

  9. Awesome information. With thanks.
    [url=]best resume writing service 2020[/url] custom essay writing service reviews [url=]cost of essay writing service[/url] best essay writing service review

  10. You actually suggested it wonderfully.
    new vegas casino online [url=]free online casino games[/url] casino online malaysia

  11. Nicely put, Cheers.
    [url=]best online essay writing services reviews[/url] essay writer service [url=]best college paper writing service[/url] paper writing service reviews

  12. Cheers, I value this.
    [url=]a writer should revise an argumentative essay for ideas and[/url] essay writer website [url=]write my essay for money[/url] college essay writers

  13. Great facts. With thanks!
    [url=]help with essay writing[/url] i need help writing an essay [url=]assignment help[/url] cheap essay help

  14. Thanks. Very good stuff.
    [url=]best custom paper writing service[/url] custom research papers for sale [url=]paper writing service reddit[/url] best term paper writing service

  15. Regards, Very good stuff.
    [url=]coursework help[/url] pay someone to do my math homework [url=]do my homework for me cheap[/url] do my finance homework

  16. Many thanks. Fantastic stuff!
    [url=]college admissions essay writing service[/url] unique essay writing service [url=]paper writing services legitimate[/url] essay writers service

  17. Thank you, Fantastic stuff.
    [url=]essay writing[/url] cheap essay writing services [url=]research paper writing service[/url] grad school essay writing service

  18. Thanks a lot. Quite a lot of content!
    [url=]good essay writing service[/url] paper writing service reviews [url=]writing an essay[/url] professional cv writing service

  19. Incredible tons of good info.
    [url=]buy essay online review[/url] buy cheap essay online [url=]pay for essay online[/url] buy essays cheap

  20. Wow a lot of excellent tips.
    [url=]dissertation writing services[/url] dissertation writers [url=]dissertation abstracts[/url] dissertation writing

  21. Appreciate it. Loads of forum posts!
    [url=]thesis writer[/url] writing a thesis statement [url=]doctoral thesis[/url] example thesis

  22. You actually mentioned that wonderfully!
    [url=]buy a paper[/url] paper writer services [url=]pay for research paper[/url] best paper writing services

  23. Wow loads of very good knowledge.
    [url=]persuasive essay writer[/url] how to write a scientific paper [url=]essay writer[/url] how to write an apa paper

  24. With thanks! A good amount of info.
    [url=]order essay[/url] order essay [url=]essay for sale[/url] pay for essay reviews

  25. Useful postings. Kudos.
    [url=]do my essay[/url] do my essay for me [url=]essay writers online[/url] essay writter

  26. Regards! Numerous write ups!
    [url=]pay for essay[/url] pay for essay reviews [url=]pay for essay online[/url] pay someone to write my college essay

  27. Wonderful data. With thanks!
    [url=]paper writing services[/url] college paper writing service [url=]buy a paper[/url] custom paper

  28. Wonderful data. Thanks.
    [url=]research paper writers[/url] write my term paper [url=]proposal introduction[/url] proposal writer

  29. Seriously plenty of helpful advice!
    [url=]buy essays online[/url] buy essays [url=]buy essays cheap[/url] buy essays online

  30. Beneficial content. Appreciate it!
    [url=]research thesis[/url] thesis help [url=]how to write thesis[/url] thesis help

  31. Incredible tons of helpful tips.
    [url=]essays for sale[/url] pay for essay [url=]essay for sale[/url] order essay

  32. Many thanks, Loads of information!
    [url=]professional essay writing service[/url] essay paper writing service [url=]writing an argumentative essay[/url] professional essay writers

  33. Nicely put. Thank you!
    [url=]college thesis[/url] thesis statements [url=]thesis topic[/url] thesis template

  34. You have made the point.
    [url=]paper writing services legitimate[/url] best paper writing services [url=]best online essay writing services[/url] professional essay writing service

  35. Thank you. I like this!
    [url=]research paper services[/url] research paper writer services [url=]research paper services[/url] research paper help

  36. Lovely write ups. Thank you.
    [url=]coursework[/url] coursework [url=]homework help[/url] hire someone to do my homework

  37. Nicely put. Thank you.
    [url=]professional cv writing service[/url] writing an argumentative essay [url=]best essay writing website[/url] best essays writing service

  38. Good forum posts. Cheers!
    [url=]custom research paper writing services[/url] term paper help [url=]research paper writer[/url] buy research paper

  39. Thank you. A lot of write ups.
    [url=]writing an essay[/url] application essay writing service [url=]paper writing services[/url] cheapest essay writing service

  40. Amazing loads of very good data.
    [url=]essay typer[/url] writing help [url=]free writing assistant[/url] help writing essay

  41. Nicely put, Cheers.
    [url=]write my paper for me[/url] write my essay for me free [url=]write my essays online[/url] professional essay writers

  42. Wonderful tips. Thanks a lot.
    [url=]best online essay writing service[/url] legit essay writing services [url=]college essays writing[/url] essay writing service cheap

  43. You actually said that very well.
    [url=]write my research paper for me[/url] ai essay writer [url=]automatic essay writer[/url] write an essay for me

  44. Very good write ups. Thanks a lot.
    [url=]essay writing help service[/url] professional cv writing service [url=]custom dissertation writing service[/url] writing a personal essay

  45. Nicely put. Many thanks!
    [url=]good thesis statement[/url] thesis statment [url=]thesis sentence[/url] thesis statements

  46. Seriously plenty of useful material.
    [url=]writing a college application essay[/url] executive resume writing service [url=]best research paper writing service[/url] essay writing in english

  47. Wonderful posts. Kudos!
    [url=]what is a phd[/url] dissertation writing services reviews [url=]dissertation meaning[/url] dissertation assistance

  48. Truly loads of helpful info!
    [url=]a good thesis statement[/url] good thesis statement [url=]phd thesis database[/url] how to write thesis

  49. Thank you. Lots of info.
    [url=]thesis proposal example[/url] phd thesis database [url=]working thesis[/url] thesis creator

  50. Perfectly spoken genuinely! .
    [url=]cheap essay writing[/url] cheap essay service [url=]writing a reflective essay[/url] top essay writing service

  51. Seriously lots of amazing info.
    [url=]linkedin profile writing service[/url] case study writing service [url=]custom writing service[/url] essay writers service

  52. Regards. I enjoy it.
    [url=]buy an essay online[/url] essays for sale [url=]buy essays online[/url] pay for college papers

  53. You’ve made your position very nicely!.
    best essay writing service [url=]your essay writer[/url] craigslist essay writer [url=]someone to write my essay[/url] anonymous essay writer wikipedia writing service [url=]essay writing examples[/url] gta resume writing service [url=]college papers writing service[/url] quality essay writing services

  54. Well voiced really. .
    service essay [url=]msc dissertation writing service[/url] dissertation spss help [url=]writing a phd dissertation[/url] phd thesis writing services india seo article writing service [url=]buy narrative essays[/url] pay for writing essay [url=]college essays for sale[/url] best place to buy essays online

  55. Thanks a lot, I like it.
    college essays writing [url=]dissertation writing services cost[/url] dissertation sections [url=]writing phd proposal[/url] need help with my dissertation top essay writing [url=]google can you do my homework[/url] someone who can do my homework [url=]do my homework for me[/url] i don t want to do my homework anymore

  56. You reported this perfectly.
    paper writing services [url=]college essay writers[/url] write an argumentative essay for me [url=]help i can t write my essay[/url] write my essay com best cheap essay writing service [url=]write my essay for me free[/url] online essay writer uk [url=]best essay writers online[/url] can someone write my dissertation for me

  57. Really tons of good information!
    spanish essay writing service [url=]write a paper[/url] write a research paper [url=]write my economics paper[/url] website that will write a paper for you custom paper writing service [url=]dissertation express[/url] phd propsal [url=]dissertation editing services reviews[/url] dissertation help online free

  58. You actually reported it very well.
    cheap will writing service uk [url=]order essay online[/url] custom essay for sale [url=]buy cheap essay[/url] buy academic essays cv writing service ireland [url=]cheap paper writers[/url] someone write my paper for me [url=]write my english paper[/url] paper writing

  59. You stated this wonderfully.
    [url=]buy college essays[/url] pay for research paper [url=]pay for papers[/url] order essay

  60. Wow plenty of excellent facts.
    essay writing meme [url=]extended essay writer[/url] essay writers [url=]write my essays online[/url] write for me free essay writing service fast [url=]tentative thesis statement[/url] phd thesis writing service [url=]thesis writer[/url] writing a research thesis

  61. Excellent advice. Thanks a lot!
    [url=]order custom paper[/url] professional paper writing service [url=]custom papers[/url] paper writing service

  62. Well expressed truly! .
    aviation resume writing service [url=]student paper writing service towson[/url] best online research paper writing service [url=]pay someone to write your paper[/url] professional online term paper writing service best essay writing service reddit [url=]dissertations online[/url] dissertation service uk [url=]dissertation writing[/url] phd.proposal

  63. Regards, Quite a lot of info.
    hsbc premier will writing service [url=]english essay help[/url] help writing college admission essay [url=]writing helper[/url] expository essay help political science essay writing service [url=]will writing service manchester[/url] legit essay writing service reddit [url=]fast writing service[/url] assignment writing service us

  64. You stated this very well.
    [url=]dissertation writer[/url] dissertation uk [url=]dissertation meaning[/url] dissertation writing services

  65. You actually suggested it effectively.
    student essay writing [url=]need help with writing a research paper[/url] buy a research paper [url=]write my term paper[/url] writing phd proposal ladders resume writing service [url=]essay writing service[/url] help with writing an argumentative essay [url=]help with writing a paper[/url] i need help writing an essay

  66. Whoa all kinds of terrific advice.
    [url=]writing paper[/url] writing paper [url=]writing paper[/url] essay writers

  67. Wonderful facts. Cheers!
    should i use an essay writing service [url=]i forgot to do my math homework[/url] my child doesn t want to do homework [url=]reddit do my homework[/url] best website to do my homework will writing service southampton [url=]pay for essay writing[/url] pay to write essay [url=]where can i pay someone to write my essay[/url] pay to write research paper

  68. You made the point!
    professional resume writing service chattanooga tn [url=]essay help uk[/url] essay on helping poor people [url=]help on essay[/url] admission essay writing help legal essay writing service [url=]tok essay help[/url] i need help to write an essay [url=]cheap essay help[/url] essay write help

  69. Thanks. I like this.
    [url=]proposal writer[/url] research proposal apa [url=]buy a research paper[/url] write my research paper

  70. Very good stuff. Thanks.
    essay writing service reviews forum [url=]write my essay for money[/url] write for me an essay [url=]write a essay for me[/url] write my admission essay is monster resume writing service worth it [url=]write my dissertation proposal[/url] dissertation discussion help [url=]online dissertation[/url] master dissertation writing services

  71. Regards! Good information!
    [url=]what should i write my college essay about[/url] essay writer free trial [url=]essay writer free trial[/url] essay writer

  72. You have made your position very effectively..
    [url=]essays for sale[/url] pay for research paper [url=]pay for essay online[/url] pay to write my essay

  73. Thank you. A lot of write ups!
    [url=]top ten essay writing services[/url] paper writing services legitimate [url=]academic essay writing service[/url] are essay writing services safe

  74. In Dominoes, each player takes turns placing one of their domino tiles adjacent to an already placed tile. The numbers on the adjacent sides of the tiles must match. For example, if a tile has a 3 on one side and a 5 on the other, you can only place it next to another tile with a 3 or a 5. The game comes from China and there are different versions all over the planet. The game of Dominoes has become a well-known classic in countries right throughout the world. Who first set up a row of domino tiles and then gave one a push? We don’t know, but the practice, known as “toppling,” probably dates from the tiles’ early years. The Netherlands hosted an annual domino toppling exhibition called Domino Day from 1986 to 2009, culminating in an event where a team toppled 4.5 million dominoes. Do-it-yourself topplers are nearly as skilled, too, as is proven by the many amazing amateur toppling videos on the Internet.
    For Nintendo fans, check out our fantastic selection of games for Nintendo Switch to add to your collection. Perhaps you’re shopping for a friend or family member? Either way, you’re in the right place for all the brand’s iconic characters, brought to life in the bright colours and vivid styles you’d expect from Nintendo.  According to the movie’s official synopsis, “When a magical meteor crash lands in Adventure City, it gives the PAW Patrol pups superpowers, transforming them into The MIGHTY PUPS! For Skye, the smallest member of the team, her new powers are a dream come true.” Paw Patrol Mighty Pups: Save Adventure Bay does nothing to save itself from being mediocre and a weak attempt to take advantage of an easily exciting franchise. To me, the game was almost offensive, with its generic take and the developer’s hope that name recognition carries it – which it almost did. Like I said earlier, I am not the demographic for the game. Being six, my son liked the game, but I could tell he sees the faults in it.

  75. Thanks a lot. I like it.
    [url=]pay to do my homework[/url] my homework [url=]should i do my homework[/url] do my homework for money

  76. You said it very well.!
    [url=]writing a good essay[/url] writing essays [url=]write my essay for free[/url] essay writter

  77. You made your position pretty effectively.!
    [url=]paper writer online[/url] automatic essay writer [url=]cheap paper writers[/url] professional paper writers

  78. You actually expressed it really well.
    [url=]homework help[/url] i don t want to do my homework [url=]homework help[/url] cpm homework help

  79. Many thanks! I like this!
    [url=]dissertation service[/url] dissertation abstracts [url=]dissertation help services[/url] dissertation service

  80. Недавно мне срочно понадобилось 5 000 рублей на неотложные нужды. Друзья посоветовали мне поискать информацию в интернете. Набрав в Яндексе запрос, я наткнулся на Там было много информации о том, как брать [url=]онлайн займ[/url] , и список надежных МФО. Я узнал, что можно взять займ без процентов!

  81. В спешке и суете повседневной жизни иногда возникают неотложные финансовые потребности. В таких случаях на помощь приходит Yandex. Недавно, найдя сайт wikzaim, я быстро получил займ от проверенного МФО 2023 года, что стало настоящим спасением.

  82. zithromax without prescription [url=]azithromycin 500 mg buy online[/url] zithromax online pharmacy canada

  83. us pharmacy [url=]canadian online pharmacy no prescription[/url] mail order pharmacy india

  84. Online medicine home delivery [url=]online pharmacy India[/url] buy prescription drugs from india

  85. В поисках идеального казино для игры на деньги, я обратился к Яндексу, и на первом месте вышел сайт Там я обнаружил множество различных казино с игровыми автоматами, а также бонусы на депозит. К тому же, на сайте есть полезные статьи о том, как правильно играть, чтобы увеличить свои шансы на победу!

  86. Buy generic Levitra online [url=]Levitra online pharmacy[/url] Vardenafil online prescription

  87. Тиристорный однофазный стабилизатор напряжения переменного тока компенсационного типа с высокой точностью поддержания выходного напряжения (±1%)

    стабилизаторы напряжения

  88. generic sildenafil [url=]Viagra online price[/url] Viagra without a doctor prescription Canada

  89. online shopping pharmacy india: pharmacy website india – online shopping pharmacy india
    pharmacies in mexico that ship to usa [url=]buying prescription drugs in mexico[/url] medicine in mexico pharmacies

  90. buy doxycycline south africa [url=]Buy Doxycycline for acne[/url] buy doxycycline online canada

  91. where to buy amoxicillin over the counter [url=]purchase amoxicillin online[/url] amoxicillin 500 mg where to buy

  92. doxycycline over the counter australia [url=]buy doxycycline over the counter[/url] doxycycline otc drug

  93. canadian drug pharmacy [url=]international online pharmacy[/url] canadian online drugstore

  94. farmacie online affidabili [url=]farmacia online piu conveniente[/url] farmacia online miglior prezzo

  95. migliori farmacie online 2023 [url=]avanafil generico[/url] comprare farmaci online con ricetta

  96. farmacie on line spedizione gratuita [url=]farmacia online miglior prezzo[/url] farmaci senza ricetta elenco

  97. farmacia online [url=]Avanafil farmaco[/url] comprare farmaci online all’estero

  98. farmacia gibraltar online viagra [url=]viagra precio[/url] sildenafilo sandoz 100 mg precio

  99. comprar sildenafilo cinfa 100 mg espaГ±a [url=]viagra generico[/url] sildenafilo cinfa 100 mg precio farmacia

  100. viagra entrega inmediata [url=]viagra online cerca de zaragoza[/url] sildenafilo 100mg precio farmacia

  101. farmacias baratas online envГ­o gratis [url=]kamagra jelly[/url] farmacias baratas online envГ­o gratis

  102. Pharmacie en ligne pas cher [url=]kamagra livraison 24h[/url] Pharmacie en ligne livraison gratuite

  103. versandapotheke versandkostenfrei [url=]potenzmittel kaufen[/url] versandapotheke versandkostenfrei

  104. online apotheke gГјnstig [url=]kamagra jelly kaufen deutschland[/url] versandapotheke versandkostenfrei

  105. mexico drug stores pharmacies [url=]п»їbest mexican online pharmacies[/url] buying from online mexican pharmacy

  106. purple pharmacy mexico price list [url=]medicine in mexico pharmacies[/url] best online pharmacies in mexico

  107. men’s ed pills [url=]п»їerectile dysfunction medication[/url] best ed pill

  108. top 10 online pharmacy in india [url=]best online pharmacy india[/url] best online pharmacy india

  109. online shopping pharmacy india [url=]indian pharmacy paypal[/url] world pharmacy india

  110. canadian pharmacy prices [url=]ordering drugs from canada[/url] reputable canadian online pharmacy

  111. buy cytotec over the counter [url=]п»їcytotec pills online[/url] buy cytotec pills online cheap

  112. п»їlegitimate online pharmacies india [url=]п»їlegitimate online pharmacies india[/url] reputable indian online pharmacy