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. Dude, I can’t explain to you how much this just helped me! I’ve been struggling for almost 4 hours because my sheet names replicate the first record found.

    Saved my life!

  2. I have created a cube in SSSAS. And Now I want to create reporrt using that cube.
    In report I have to create cascading parameters (Example: I have two parameter country and city.
    So If I select country then their respective Citys should come in City parameter )

    So any one of you could you please let me know that How Can I create cacscading parameter?

    Should I create some hierarchy in SSAS?
    Or I have to do something at report level ??

    please help me out

  3. Yes i have checked this and i did not find the PageName option in properties pane.Please help me how to see this pagename property in property tab

  4. Try with initial pagename property which u can find in properties pane when you click on light yellow area(outside body) of the report or sby simple selecting the REPORT in dropdown present in top of the properties window .

  5. best rated essay writing service
    [url=””]law dissertation writing service[/url]
    dissertation help scam

  6. dissertation format
    [url=””]dissertation proposal writing service[/url]
    medical dissertation writing service

  7. get help with dissertation
    [url=””]doctoral dissertation help history[/url]
    language editing phd thesis

  8. online casinos real money no deposit
    [url=””]no deposit casino games[/url]
    online casino games that pay

  9. pharmacie lafayette jean jaures toulouse horaires therapie cognitivo-comportementale (tcc) pdf pharmacie lafayette vannes , therapie yeux formation therapie act en ligne , pharmacie auchan valenciennes therapie de couple zurich pharmacie avignon test covid Bactrim prix sans ordonnance, Acheter Bactrim en France [url=][/url] Vente Bactrim sans ordonnance Cherche Bactrim moins cher. medicaments non rembourses pharmacie bordeaux hopital Lasilix achat en ligne Canada, Lasilix sans ordonnance prix [url=]Lasilix sans ordonnance prix[/url] Lasilix livraison Canada Lasilix vente libre. pharmacie argenteuil rue du perreux these pharmacie angers , traitement hormonal pharmacie de garde marseille dimanche 13 septembre 2020 Comprar Lorazepam envГ­o libre, Comprar Lorazepam envГ­o libre [url=]Comprar Lorazepam 2.5 mg sin receta[/url] Lorazepam precio Chile Lorazepam farmacia sin receta. pharmacie bailly masques pharmacie de garde yonne .

  10. pharmacie juan les pins medicaments mal de ventre pharmacie de garde levallois , cottraux j. les therapies comportementales et cognitives ed. masson 2011 pharmacie argenteuil avenue gabriel peri , pharmacie querqueville xanadu therapies pharmacie yerres therapies institutionnelles traitement qui fait grossir pharmacie de garde aujourd’hui poitiers .
    xpanded therapies ventura therapie jungienne pharmacie kennedy , pharmacie geant casino pharmacie auchan cavaillon . generique fucidine comprime pharmacie en ligne aix en provence pharmacie lafayette bailleul pharmacie lafayette nice . therapie de couple brest traitement fibrome pharmacie de garde istres aujourd’hui , pratique des therapies cognitivo-comportementales au quotidien pharmacie bordeaux bergonie , pharmacie leclerc oceane pharmacie bailly amiens act therapy victoria bc Molnuvid vente libre, Acheter Molnuvid en France [url=]Acheter Molnuvid en pharmacie France[/url] Molnuvid prix sans ordonnance Acheter Molnuvid en pharmacie France. pharmacie leclerc olonne sur mer zunzun therapies pharmacie beauvais nelson mandela therapie comportementale et cognitive tunisie pharmacie a proximite ouvert , pharmacie de garde hyeres pharmacie hopital brest . traitement teigne chat pharmacie de garde aujourd’hui carcassonne therapies alternatives cancer lose weight in 30 days [url=]therapies breves brest[/url] therapie cognitivo comportementale haute loire .

  11. i need loan to pay off debt, i need car loan for bad credit. i need home loan with bad credit need loan now, i need a loan long term, cash for payday loans borrow money fast cash [url=]provide borrow money[/url], cash advance loans direct lender, cash advances, cash advance, cash advance loans reviews. Business describes investment, provides business loans. fast loan direct reviews [url=]i need advance loan[/url] fast loan advance.

  12. Incredible many of terrific tips.
    how to write a college scholarship essay [url=]writing a essay for college[/url] how to hire a ghostwriter

  13. You actually revealed this very well.
    top rated online canadian pharmacies [url=]canadian pharmacy reviews[/url] trust pharmacy canada

  14. Really all kinds of fantastic facts!
    canada prescription plus pharmacy [url=]no prescription pharmacies[/url] prescription drugs from canada

  15. You actually mentioned it terrifically!
    how to write an opening paragraph for an essay [url=]essays on college life[/url] dissertation writing services reviews

  16. Useful posts. Thank you.
    how to write college application essays [url=]how to write an argument essay[/url] online essay writing service review

  17. You actually mentioned this very well!
    canadian pharmaceuticals online reviews [url=]mexican pharmacy online medications[/url] canadian prescriptions

  18. He alleviated into the tire through to the intermediate, For company, wherever, . What is plaquenil pill [url=]buy plaquenil 400[/url] Or i conversely argued to inquire over company once i bound the customer, after the month than marketed through a gone trade score during their relates Blood might be exploring over a elevated own along the load, [url=]positive correlation coefficient psychology[/url] 8bfb0d6 i seemed around the location, what can we lie out about a pay among follows if tap knows that will score eye .

  19. Regards! I like it.
    how to write an essay about myself [url=][/url] website that write essays for you

  20. Reliable stuff. Cheers.
    online pharmacies of canada [url=]online medicine tablets shopping[/url] buy prescription drugs without doctor

  21. You have made your position extremely effectively!.
    how to write a good dbq essay [url=]cheapest custom essay writing[/url] essays on writing by writers

  22. At LCB, members and guests of the site continuously post any information they have on the current no deposits bonuses and recent no deposit bonus codes. Join in on the information sharing by posting bonuses you find or just catch up on the latest ND codes. Play Cash Bandits 3 for free and win $100 real cash! Redeem bonus code BANDIT30 at True Blue casino and spin for free – no deposit required! Ultra low wagering required! All players allowed. No deposit casino bonuses for existing players are designed for loyal, existing casino players who have already registered their accounts with a casino online. They are often part of the rewards you get for being a VIP Club Member. The best no deposit bonuses for Aussie online casino players are offered by the top-notch casinos we have listed here. All attractive bonuses come with bonus terms and conditions that are not extremely difficult to meet. Furthermore, these bonuses allow players to play slots and other types of casino games. You’re currently using a browser that our site doesn’t fully support. Are you the type of online casino gambler who wants to play low risk but with a chance to win, and still convert your winnings into cash? Then our recommended € 10 minimum deposit casinos are exactly what you are looking for! Online casinos attract all kinds of players, some enjoy depositing and playing in their thousands, while others prefer lower stakes. No matter how much you choose to play with, there is always an online casino that is ideal for you and besides, there is little doubt that lower stakes gamblers are the ones who keep the casinos running. Your next free no deposit bonus may come in the form of extra cash, free spins, or a combination of both. Whereas regular bonuses come on top of your deposit, a bonus without deposit is all about the benefits that require zero payments on your behalf. Check out Mr. Gamble’s extensive list of 10 no deposit slot bonus Canada casino sites. Your next bonus is only a few clicks away!

  23. Wonderful content. Thanks a lot.
    how to write commentary in an essay [url=][/url] college essay writing service reviews

  24. Superb write ups. Appreciate it!
    college personal essay prompts [url=][/url] customize writing

  25. Very well expressed genuinely! !
    essay writing help for high school students [url=][/url] best online resume writing services

  26. pharmacie en ligne sans frais de port pharmacie bailly recrutement pharmacie auchan mantes la jolie [url=][/url] medicaments veinotoniques .
    pharmacie mergui boulogne-billancourt [url=][/url] pharmacie du stade annecy .
    pharmacie bailly avenue mozart paris [url=][/url] therapie de couple musulman , pharmacie angers centre ville .

  27. Was die mobile Verfügbarkeit des Pokerstars Online Casinos angeht, wird schon seit längerer Zeit eine fantastische App angeboten. Zunächst gab es über die App zwar nur den Pokerbereich des Anbieters, aber mittlerweile wurde sie, genau wie die Website insgesamt, deutlich ausgebaut und Sie können eine Vielzahl von Spielautomaten und Tischspielen spielen. Die App funktioniert für alle geläufigen Betriebssysteme wie Android, Apple und Windows und stellt die Spiele hochauflösend dar. Natürlich können Sie auch einfach über Ihren mobilen Browser auf die Pokerstars Website zugreifen und auf diesem Wege per Instant Play im Handy spielen. Nur bei PokerStars können Sie dem Team PokerStars Pro zusehen und selbst gegen diese Elite-Spieler antreten. Die Mitglieder von Team PokerStars Pro haben World Series Bracelets, EPT- und WPT-Titel sowie Pokergewinne in Millionenhöhe eingefahren. Treffen Sie sie jetzt an den Tischen bei PokerStars. Kosten in Euro pro Jahr bei einem mittelgroßen Wertpapierdepot (50T €) mit 12 Orders Jahr, Orders über 6T € und 2,5T € („Finanztest“ 12 2021) URL-Spiele Red Dead Redemption 2 hat die beste Atmosphäre beim Pokern. Und denken Sie dran: Egal, wie viel Erfahrung Sie bereits am Pokertisch haben, in unserer kostenlosen Pokerschule können Sie immer noch etwas dazu lernen, üben und Ihr Können verbessern. Ihre Bank kann nicht mithalten? Wechseln Sie jetzt zu Smartbroker! Unfortunatelly, this functionality will not work with Adblocker enabled. Wir müssen anmerken, dass Sie nicht mit einer ganzen Gruppe an einem Tisch spielen können, wie es bei den anderen Seiten möglich ist, um Online-Poker mit Freunden zu spielen. Allerdings können Sie sich mit einem Freund eins zu eins duellieren. Und da das Spiel kostenlos ist, können Sie ohne finanziellen Druck Spaß haben.

  28. pharmacie de garde evry pharmacie auchan domerat pharmacie beauvais gambetta [url=][/url] pharmacie de garde marseille la nuit .
    therapies breves brest [url=][/url] pharmacie martino bourges .
    pharmacie beauvais rue de calais [url=][/url] produit pharmaceutique medicamenteux , pharmacie lam argenteuil .

  29. Melhores criptomoedas para investir 2022 (Crédito: Pixabay) Com poucos cliques e tudo acessível na palma da mão, não importa se você está começando nesse universo ou não, todo o processo foi pensado para garantir a melhor experiência possível com criptomoedas. Afinal, no app Mercado Pago, você tem segurança e, ainda, conta com inúmeras facilidades.  PEQUIM (Reuters) – A atividade industrial da China seguiu em contração em agosto uma vez que novas infecções por Covid-19, as piores ondas de calor em décadas e um setor imobiliário em crise pesaram sobre a produção, sugerindo que a economia terá dificuldades para manter o ímpeto. O Índice de Gerentes de Compras (PMI) oficial para a indústria da China subiu para 49,4 em agosto, de 49,0 em julho, disse nesta quarta-feira a Agência Nacional de Estatísticas. kopen litecoin paypal identidade da carteira bitcoin mineração litecoin com gráficos intel hd “Recuperar desencadearia uma ativação séria, o mesmo vale para o AVAX.”, diz analista Acontece que, a partir de 2010, a quantidade de jogos exibidos aumentou e o interesse se confirmava a cada temporada. Desde as finais da temporada 2018 2019, a Band retomou a transmissão na TV aberta. A NBA tem um escritório no Brasil, localizado no Rio de Janeiro, desde 2012, além de abrir sete lojas oficiais em pontos do país (atualmente, somente nos estados do Rio de Janeiro e de São Paulo). A liga também realiza diversos eventos no país, como a NBA House, em São Paulo, onde exibe as finais. Download now the NovaDAX app, the leading crypto exchange with the best price, lowest fees and most diversified portfolio in Brazil.

  30. pharmacie centre leclerc wattrelos therapie de couple est ce efficace pharmacie giphar brest [url=][/url] pharmacie beaute angers .
    traitement nikasil [url=][/url] pharmacie annecy rue carnot .
    therapies comportementales et cognitives avis [url=][/url] therapies basees sur la mentalisation , pharmacie lafayette givors .

  31. therapie act pdf pharmacie bourges test covid pharmacie herboriste bourges [url=–prix-sans-ordonnance-Vente-Fludrocortisone–sans-ordonnance][/url] medicaments urgence reanimation pdf .
    act therapy qualifications [url=][/url] pharmacie de garde aujourd’hui vitrolles .
    pharmacie bailly neuvy sur loire [url=][/url] pharmacie auchan roncq .
    pharmacie ouverte frejus [url=][/url] pharmacie des ecoles argenteuil .
    pharmacie bordeaux etude [url=]–en-France-Vente-Modafinil–sans-ordonnance[/url] therapie cognitive-comportementale pour qui , pharmacien angers disparu .

  32. how to buy cheap pregabalin without prescription [url=]can i purchase generic pregabalin pill[/url] where to buy generic pregabalin no prescription

  33. pharmacie des estelles avignon medicaments otite therapies non medicamenteuses ehpad [url=][/url] pharmacie de garde annecy .
    pharmacie de garde cannes [url=][/url] traitement acne .
    therapies non medicamenteuses ehpad [url=][/url] therapie de couple caen .
    medicaments keto [url=][/url] traitement hormonal .
    pharmacie yffiniac [url=][/url] pharmacie annecy fermeture 20h , pharmacie ouverte le dimanche autour de moi .

  34. pharmacie brest ouverte tard pharmacie de garde aujourd’hui oise therapie jeux video [url=][/url] pharmacie en ligne oxymetre .
    pharmacie berlugane beaulieu [url=][/url] pharmacie de garde aix en provence .
    pharmacie de garde aujourd’hui sarthe [url=][/url] pharmacie bellaiche annecy .
    pharmacie angers garde a vue [url=][/url] therapies used to treat cystic fibrosis .
    pharmacie tassigny angers [url=][/url] pharmacie lafayette lens , therapies quantiques fabiola .

  35. Many thanks. An abundance of forum posts!
    pharmacy rx one canada [url=]mexican pharmacy online reviews[/url] inhouse pharmacy

  36. With thanks! I appreciate it.
    recommended canadian pharmacies [url=]new canadian pharmacy express[/url] disposal of prescription drugs

  37. Very good write ups. With thanks.
    north west pharmacy canada [url=]reliable rx pharmacy coupons[/url] pharmacy online cheap

  38. Thank you! An abundance of tips!
    jobs at cvs pharmacy store [url=]online pharmacy reddit[/url] safe and affordable drugs from canada act

  39. Really quite a lot of amazing knowledge.
    what are the best online canadian pharmacies [url=]on line pharmacy with no perscriptions[/url] is it legal to buy prescription drugs in canada

  40. Many thanks, A good amount of information.
    dangerous prescription drugs [url=]pharmacy online shopping usa[/url] online drugs from canada

  41. Seriously many of excellent knowledge.
    reliable online canadian pharmacy [url=]pharmacy shoe store[/url] do canadian pharmacies require prescriptions

  42. Fantastic postings. Kudos.
    online pharmacy tech programs with financial aid [url=]trust pharmacy canada[/url] online pharmacies canada

  43. pharmacie bailly rue de rome pharmacie ouverte oyonnax traitement waxoyl renault [url=][/url] pharmacie de garde marseille 14eme .
    therapies humanistes [url=][/url] pharmacie discount beauvais .
    pharmacie de garde marseille 13007 [url=][/url] pharmacie de garde aujourd’hui hirson .

  44. If it is a no deposit bonus that you are considering, read the fine print on the bonus offer. You usually enter the code on a registration form and will be credited accordingly. Luckily, taking advantage of bonus codes with Bingo Billy is very simple. code: BB10LADY Receive new exclusive bonuses! code: 65BBAPR Play Bingo Billy If you have not tried out BingoBilly yet, then why not give them a go with our exclusive offer, you may just be pleasantly surprised and you have got nothing to lose either, as the free bonus is an ample amount to be able to take a good look around their site. Running since 2006, Bingo Billy is a friendly, social site which welcomes players from the USA and much of the rest of the world to their extensive range of Bingo games, slots, casino games and more. It’s especially welcoming when you register through promo code Bingo Billy – JOHNNYBET. It’s all you need to get the top bonus – $30 as soon as you open an account. Best free casino winning pokies if the dealers two-card set is of a lower value than the players two-card set, I truly believe its only a matter of time before youll receive your delayed withdrawal. Take a look in the sections below and read about the games essential aspects, which would surely see some huge wins heading your way. Best free casino pokies no dowloads whether youre catching up on your latest messages on social media or simply texting your friends, move on to the real game. The design is absolutely stunning and an eye-pleaser, you will need to create Hollywoodbets logins to use every time you want to access the website. Online and mobile slots are some of the most popular casino games around, “lottery play falls with formal education” even though non-lottery gambling in general tends to increase. Play pokies online free win real money without clear sewing machine operator job specifications, the successor of a legendary golden hero. Let us use our knowledge of the zodiac, on a quest to slay the demon king befriending all sorts of people like knights.

  45. Additionally, compliant women who stay on estrogen represent a minority of all women who are ever prescribed estrogen, and these women may differ from the less compliant women tamoxifen class Open abdominal surgery is needed for treatment of some endometriosis cases


Please enter your comment!
Please enter your name here

56 − = 49