Naming Excel Worksheets using PageName in SSRS

78
31153

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

78 COMMENTS

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  20. Wow a lot of excellent tips.
    [url=https://helpwithdissertationwriting.com/]dissertation writing services[/url] dissertation writers [url=https://dissertationwritingtops.com/]dissertation abstracts[/url] dissertation writing

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

  22. You actually mentioned that wonderfully!
    [url=https://service-essay.com/]buy a paper[/url] paper writer services [url=https://custompaperwritingservices.com/]pay for research paper[/url] best paper writing services

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

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

  25. Useful postings. Kudos.
    [url=https://theessayswriters.com/]do my essay[/url] do my essay for me [url=https://bestcheapessaywriters.com/]essay writers online[/url] essay writter

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

  27. Wonderful data. With thanks!
    [url=https://service-essay.com/]paper writing services[/url] college paper writing service [url=https://custompaperwritingservices.com/]buy a paper[/url] custom paper

  28. Wonderful data. Thanks.
    [url=https://researchproposalforphd.com/]research paper writers[/url] write my term paper [url=https://writingresearchtermpaperservice.com/]proposal introduction[/url] proposal writer

  29. Seriously plenty of helpful advice!
    [url=https://payforanessaysonline.com/]buy essays online[/url] buy essays [url=https://buycheapessaysonline.com/]buy essays cheap[/url] buy essays online

  30. Beneficial content. Appreciate it!
    [url=https://customthesiswritingservice.com/]research thesis[/url] thesis help [url=https://writingthesistops.com/]how to write thesis[/url] thesis help

  31. Incredible tons of helpful tips.
    [url=https://payforanessaysonline.com/]essays for sale[/url] pay for essay [url=https://buycheapessaysonline.com/]essay for sale[/url] order essay

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

  33. Nicely put. Thank you!
    [url=https://argumentativethesis.com/]college thesis[/url] thesis statements [url=https://bestmasterthesiswritingservice.com/]thesis topic[/url] thesis template

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

  35. Thank you. I like this!
    [url=https://researchproposalforphd.com/]research paper services[/url] research paper writer services [url=https://writingresearchtermpaperservice.com/]research paper services[/url] research paper help

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

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

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

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

  40. Amazing loads of very good data.
    [url=https://essaytyperhelp.com/]essay typer[/url] writing help [url=https://helptowriteanessay.com/]free writing assistant[/url] help writing essay

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

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

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

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

  45. Nicely put. Many thanks!
    [url=https://argumentativethesis.com/]good thesis statement[/url] thesis statment [url=https://bestmasterthesiswritingservice.com/]thesis sentence[/url] thesis statements

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

LEAVE A REPLY

Please enter your comment!
Please enter your name here

30 − = 22