Naming Excel Worksheets using PageName in SSRS

By
roopesh.valluru
-
201
29547

Friends,

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 ..

Regards,
Roopesh Babu V

RELATED ARTICLESMORE FROM AUTHOR

201 COMMENTS

  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!

  4. 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

  6. 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

  7. 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 .

  16. best rated essay writing service
    [url=”https://professionaldissertationwriting.com”]law dissertation writing service[/url]
    dissertation help scam

  18. dissertation format
    [url=”https://professionaldissertationwriting.org”]dissertation proposal writing service[/url]
    medical dissertation writing service

  19. get help with dissertation
    [url=”https://writing-a-dissertation.net”]doctoral dissertation help history[/url]
    language editing phd thesis

  22. online casinos real money no deposit
    [url=”https://casino-online-jackpot.com”]no deposit casino games[/url]
    online casino games that pay

  46. 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=https://www.jotform.com/build/222354128716050#][/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=https://www.dismoimondroit.fr/questions/question/acheter-furosemid-en-canada#]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=https://www.jotform.com/build/222363843490053#]Comprar Lorazepam 2.5 mg sin receta[/url] Lorazepam precio Chile Lorazepam farmacia sin receta. pharmacie bailly masques pharmacie de garde yonne .

  56. 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=https://maps.google.fr/url?q=https://fr.ulule.com/molnuvid-vente/#]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=https://bit.ly/3AU865X+#]therapies breves brest[/url] therapie cognitivo comportementale haute loire .

  75. 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=https://www.borrowmoneyok.com/#]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=https://ineedloan.me/#]i need advance loan[/url] fast loan advance.

  79. Incredible many of terrific tips.
    how to write a college scholarship essay [url=https://writingthesistops.com]writing a essay for college[/url] how to hire a ghostwriter

  81. You actually revealed this very well.
    top rated online canadian pharmacies [url=https://canadadrugspower.com]canadian pharmacy reviews[/url] trust pharmacy canada

  85. Really all kinds of fantastic facts!
    canada prescription plus pharmacy [url=https://canadapharmacyspace.com]no prescription pharmacies[/url] prescription drugs from canada

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

  96. Useful posts. Thank you.
    how to write college application essays [url=https://theessayswriters.com]how to write an argument essay[/url] online essay writing service review

  107. You actually mentioned this very well!
    canadian pharmaceuticals online reviews [url=https://canadarx-drugservices.com]mexican pharmacy online medications[/url] canadian prescriptions

  113. He alleviated into the tire through to the intermediate, For company, wherever, . What is plaquenil pill [url=https://plaquenilnon.quest/#]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=http://www.test2.klilandscape.com/?q=team/project-managers&page=9848#comment-492411]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 .

  118. Regards! I like it.
    how to write an essay about myself [url=https://dissertationwritingtops.com]https://dissertationwritingtops.com/[/url] website that write essays for you

  129. Reliable stuff. Cheers.
    online pharmacies of canada [url=https://northwestpharmacylabs.com]online medicine tablets shopping[/url] buy prescription drugs without doctor

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

  163. 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. https://troyfuix876420.kylieblog.com/15884786/high-low-casino-dice-game 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!

  169. Wonderful content. Thanks a lot.
    how to write commentary in an essay [url=https://essayssolution.com]https://essayssolution.com/[/url] college essay writing service reviews

  175. Superb write ups. Appreciate it!
    college personal essay prompts [url=https://homeworkcourseworkhelps.com]https://homeworkcourseworkhelps.com/[/url] customize writing

  193. Very well expressed genuinely! !
    essay writing help for high school students [url=https://essaywriting4you.com]https://essaywriting4you.com/[/url] best online resume writing services

LEAVE A REPLY

Please enter your comment!
Please enter your name here

67 + = 69