Reporting Services no SQL Server 2008 R2 – Adicionar Mapas ao Map Gallery

Fala galera, quando utilizamos o Reporting Services do SQL Server 2008 R2 temos a possibilidade de trabalhar nativamente com mapas. Para tal realização, é possivel utilizar os mapas de três formas diferentes: Map Gallery (utiliza os mapas pré-instalados no computador local) / ESRI Shapefiles (são os mapas baseados em arquivos que possuem todos os pontos geográficos compilados em um arquivo com extensão .shp) / Spatial Query (possibilita a realização de consultas no SQL Server 2008 R2 e retornamos os dados do tipo Geometry). Bom, depois de passar uma breve idéia de quais são as possibilidades de se trabalhar com mapas, e a idéia deste post é apresentar como se adicionar novos mapas ao Map Gallery, vamos começar.

imageimageQuando se criam relatórios, um dos ítens da ToolBox é o item “Map” (figura da esquerda). Arrastando este ítem para o relatório um wizard será chamado, é neste wizard que as três opções de mapas são apresentadas. Por padrão, a primeira opção selecionada é a Map Gallery e somente os mapas dos EUA estão disponíveis para utilizar (figura da direita), porém, é possível adicionar novos mapas, mas temos que fazer essa atividade manualmente.

Estes mapas disponíveis são relatórios individuais que estão organizados em uma estrutura de diretórios. Eles ficam armazenados no caminho “Program Files\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\MapGallery”. Pronto, agora que você já sabe o que são esses mapas e como estão armazenados, chegou a hora de montar os relatórios de acordo com suas necessidades e colocar nesta estrutura. Simples assim 🙂

Eu montei dois relatórios do Brasil, um só com o contorno do país e outro separado pelos estados. Ainda vou montar todos os 27 estados separados por relatório, como no exemplo dos EUA que vem junto ao BIDS (Business Intelligence Developement Studio). Assim que montar estes mapas, disponibilizo todos para baixar em algum lugar. Provavelmente no meu SkyDrive.


Com os novos relatórios de mapas dentro da estrutura de diretórios, é possível utilizá-los nos próximos relatórios que forem utilizar o Map Gallery. Veja na figura acima a estrutura de diretórios com os mapas do Brasil (reparem na extensão .rld, que é a extensão dos relatórios que criamos normalmente no BIDS) e na figura abaixo a sessão Map Gallery do Reporting Services já constando os mapas do Brasil.


É isso ai pessoal, mais uma informação para ajudá-los com o Reporting Services dentro do SQL Server 2008 R2. Estou com vários tópicos no Task list, mas se quiser ver algum assunto em específico, pode sugerir. Veja meus contatos.

Compartilhe o post:
Follow by Email



376 thoughts on “Reporting Services no SQL Server 2008 R2 – Adicionar Mapas ao Map Gallery

  1. Thanks. Just to add something. The path for MapGallery may also be:

    C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\MapGallery\USA

    (SQL Server 2008 R2)

  2. Hi,this solution works perfectly when we want to create map via BIDS but how can we add a map to SSRS map gallery?any idea?

  3. Hi Roxana, you could create (or download, as well) the Map. Then, follow the instructions to move to right path, create your folder and put your map there. If you want to download some maps, visit and check some maps around world.

  4. The interface is colorful, has more flair, and some cool features like аАа’аАТ‚аЂТ˜Mixview a that let you quickly see related albums, songs, or other users related to what you are listening to.

  5. Im no professional, but I feel you just crafted an excellent point. You clearly know what youre talking about, and I can seriously get behind that. Thanks for being so upfront and so truthful.

  6. Nice post. I used to be checking continuously this blog and I am impressed! Extremely helpful info specially the closing section 🙂 I maintain such info much. I used to be looking for this particular information for a long time. Thank you and best of luck.

  7. Yes, you are correct friend, on a regular basis updating website is in fact needed in support of SEO. Fastidious argument keeps it up.

  8. Usually I don at read post on blogs, but I would like to say that this write-up very forced me to try and do it! Your writing style has been surprised me. Thanks, quite nice article.

  9. Wow! This can be one particular of the most helpful blogs We ave ever arrive across on this subject. Basically Great. I am also a specialist in this topic so I can understand your hard work.

  10. Wow, amazing weblog format! How long have you ever been blogging for? you made blogging glance easy. The overall look of your site is fantastic, as well as the content material!

  11. I truly appreciate this post. Ia??a?аАа’аАТ‚аЂ ve been looking everywhere for this! Thank goodness I found it on Bing. You ave made my day! Thanks again

  12. This blog is really educating additionally amusing. I have discovered many handy tips out of this amazing blog. I ad love to come back again and again. Cheers!

  13. Spot on with this write-up, I honestly believe this amazing site needs much more attention. I all probably be returning to see more, thanks for the information!

  14. Wow, superb blog layout! How long have you been blogging for? you made blogging look easy. The overall look of your web site is magnificent, as well as the content!

  15. Simply want to say your article is as astounding. The clearness in your post
    is simply cool and i could assume you’re an expert on this subject.
    Well with your permission allow me to grab your RSS feed
    to keep up to date with forthcoming post. Thanks a million and please carry on the enjoyable work.

  16. Hi there I am so happy I found your site, I really found you
    by accident, while I was researching on Digg for something else, Anyhow
    I am here now and would just like to say thanks a lot for
    a fantastic post and a all round enjoyable blog (I also love the theme/design), I
    don’t have time to read it all at the moment but I have
    bookmarked it and also included your RSS feeds, so when I have time I will
    be back to read more, Please do keep up the excellent jo.

  17. That is a really good tip particularly to those fresh to the blogosphere. Brief but very precise information Thank you for sharing this one. A must read article!

  18. Whats up! I just wish to give an enormous thumbs up for the good data you have right here on this post. I will likely be coming back to your blog for extra soon.

  19. I like what you guys tend to be up too. This sort of clever work and coverage!
    Keep up the fantastic works guys I’ve included you guys to our blogroll.

  20. Im no pro, but I imagine you just crafted the best point. You definitely know what youre talking about, and I can really get behind that. Thanks for staying so upfront and so sincere.

  21. Wanted to drop a remark and let you know your Feed isnt working today. I tried including it to my Google reader account but got nothing.

  22. Wohh exactly what I was searching for, regards for putting up. Be nice to everyone on your way to the top because you pass them all on the way down. by Fred Hufnagel, Sr..

  23. Hey! Do you know if they make any plugins to safeguard against
    hackers? I’m kinda paranoid about losing everything I’ve worked hard on. Any suggestions?

  24. Howdy! I just want to give you a big thumbs up for the excellent info you
    have here on this post. I’ll be returning to your site for more soon.

  25. Hello there, You have done a great job. I’ll certainly digg
    it and personally suggest to my friends. I am sure they will be benefited from this website.

  26. Your current positions always have got many of really up to date info. Where do you come up with this? Just declaring you are very resourceful. Thanks again

  27. I’m really enjoying the theme/design of your site.
    Do you ever run into any web browser compatibility
    issues? A small number of my blog visitors have complained about my site not working correctly in Explorer but
    looks great in Safari. Do you have any tips to help fix this problem?

  28. I am actually delighted to glance at this web site posts which consists of tons of useful facts, thanks
    for providing such data.

  29. When I initially commented I clicked the “Notify me when new comments are added” checkbox and now each time a comment
    is added I get several e-mails with the same comment.
    Is there any way you can remove me from that service?

    Many thanks!

  30. I like the valuable information you provide in your articles.
    I’ll bookmark your blog and check again here regularly.

    I’m quite sure I’ll learn many new stuff right here!
    Good luck for the next!

  31. Wow, fantastic movie porn child weblog structure! How long have you ever been running a blog for? you make blogging glance easy. The entire glance of your website is great, as well as the content!

  32. This awesome blog is really awesome and informative. I have chosen a lot of handy advices out of this amazing blog. I ad love to go back again and again. Thanks!

  33. magnificent issues altogether, you just gained a emblem new reader. What may you recommend about your publish that you made some days ago? Any certain?

  34. Hmm it seems like your website ate my first comment (it
    was extremely long) so I guess I’ll just sum it up what I submitted
    and say, I’m thoroughly enjoying your blog. I as well am an aspiring blog blogger but I’m still new to everything.
    Do you have any suggestions for newbie blog writers?
    I’d definitely appreciate it.

  35. Thank you, I ave recently been searching for information about this topic for ages and yours is the best I have discovered till now. But, what about the bottom line? Are you sure about the source?

  36. Keep up the superb piece of work, I read few articles on this site and I believe that your website is very interesting and has lots of good information.

  37. Do you mind if I quote a couple of your posts as long as I provide credit and sources back to your website? My blog is in the exact same niche as yours and my visitors would certainly benefit from a lot of the information you present here. Please let me know if this alright with you. Thank you!|

  38. You could certainly see your enthusiasm in the work
    you write. The sector hopes for more passionate writers
    like you who are not afraid to say how they believe. At all times go after your heart.

  39. Actually no matter if someone doesn’t understand afterward its up to other viewers that they will
    help, so here it happens.

  40. Have you ever thought about adding a little bit more than just your
    articles? I mean, what you say is important and everything.
    But just imagine if you added some great graphics or video clips
    to give your posts more, “pop”! Your content is
    excellent but with pics and clips, this site could
    definitely be one of the very best in its niche.
    Awesome blog!

  41. Hello! This is kind of off topic but I need some guidance from an established blog.
    Is it difficult to set up your own blog? I’m not very techincal but
    I can figure things out pretty fast. I’m thinking about making my own but I’m not sure where to start.
    Do you have any points or suggestions? Many thanks

  42. just beneath, are numerous absolutely not associated web sites to ours, on the other hand, they may be surely really worth going over

  43. excellent submit, very informative. I’m wondering why the opposite experts of this sector do not notice this. You should proceed your writing. I am sure, you have a huge readers’ base already!|

  44. magnificent points altogether, you simply received a brand new reader. What could you suggest about your put up that you just made some days ago? Any positive?|

  45. It’s a pity you don’t have a donate button! I’d definitely donate to this outstanding blog!

    I guess for now i’ll settle for bookmarking and adding your
    RSS feed to my Google account. I look forward to new updates
    and will talk about this site with my Facebook group.

    Talk soon!

  46. whoah this blog is fantastic i love reading your articles. Keep up the good work! You know, many people are looking around for this information, you could help them greatly.

  47. Usually I don at read post on blogs, but I wish to say that this write-up very forced me to try and do so! Your writing style has been amazed me. Thanks, very nice article.

  48. This unique blog is obviously interesting as well as informative. I have chosen a lot of helpful things out of this source. I ad love to go back every once in a while. Thanks a bunch!

  49. Fantastic goods from you, man. I’ve understand your stuff previous to and you are just extremely excellent. I actually like what you’ve acquired here, really like what you’re saying and the way in which you say it. You make it enjoyable and you still take care of to keep it wise. I cant wait to read much more from you. This is really a great website.|

  50. Write more, thats all I have to say. Literally, it seems as though you relied on the video to make your point. You clearly know what youre talking about, why waste your intelligence on just posting videos to your site when you could be giving us something enlightening to read?|

  51. IaаАа’б‚Т€ТšаЂаŒаАа’б‚Т€ТžаБТžm a extended time watcher and I just believed IaаАа’б‚Т€ТšаЂаŒаАа’б‚Т€ТžаБТžd drop by and say hi there there for your extremely initially time.

  52. whoah this blog is wonderful i love reading your articles. Keep up the great work! You know, many people are searching around for this info, you can aid them greatly.

  53. Buy cheap pills online, generic next day delivery uk and cheap sale in england, canada over the counter except where can i get pills in south africa. How to get without insurance also price of generic, price generic and retail price despite price in canada.

  54. I think other web site proprietors should take this website as an model, very clean and magnificent user friendly style and design, as well as the content. You are an expert in this topic!

  55. Very nice post. I just stumbled upon your blog and wanted to say that I have really enjoyed browsing your weblog posts. After all I will be subscribing for your feed and I’m hoping you write once more soon!|

  56. This particular blog is without a doubt educating additionally diverting. I have picked a bunch of interesting advices out of this amazing blog. I ad love to visit it again soon. Thanks!

  57. This is very interesting, You are a very skilled blogger. I have joined your rss feed and look forward to seeking more of your excellent post. Also, I have shared your site in my social networks!

  58. I simply want to mention I’m beginner to blogging and actually loved you’re page. More than likely I’m planning to bookmark your website . You really have beneficial stories. Thanks for revealing your website page.

  59. Hi there, There’s no question that your world-wide-web may perhaps be taking website browser compatibility factors. Every time I choose a appear at your web site in just Safari, it appears to be fantastic Sadly, if opening in just I.E., it consists of some overlapping things to consider. I simply just wished-for in direction of give on your own with a uncomplicated heads up! Other than that, Great web site!

  60. Hi there everyone, it’s my first pay a quick visit at this web site, and paragraph is really fruitful in support of me, keep up posting such content.|

  61. It’s actually a nice and helpful piece of info. I’m satisfied that you just shared this helpful information with us. Please stay us up to date like this. Thank you for sharing.|

  62. I think that is one of the most significant information for me. And i am happy reading your article. But want to observation on few general things, The website taste is great, the articles is actually great : D. Just right job, cheers|

  63. Where can I buy over the counter in canada, buy online doctor and average price of in canada, buy online for cheap except order online south africa. Cheap canada also tablet generic name, average cost prescription and generic price in usa despite generic medication.

  64. Online canada overnight, overnight delivery australia and cheap pills usa, generic for sale in canada except generic for sale online. Over the counter australia also buy in australia, where can you get and over the counter alternative to despite where can i get a prescription for.

  65. This unique blog is really cool and also diverting. I have found helluva useful advices out of this amazing blog. I ad love to visit it every once in a while. Cheers!

  66. Order pills online, to buy in london and pills for cheap, cost of without insurance except cost of in usa. Uk online also can you buy over the counter in new zealand, buy from canada and tablets buy online despite cost canada.

  67. Order generic usa, online order usa and uk generic, buy online australia except online price comparison. Australia chemist warehouse also getting australia, how much does cost in the uk and uk despite price without insurance.

  68. For sale canada, overnight delivery usa and buy usa online, cheapest online canada except pills cost. Tablets uk also over the counter medicine like, online new zealand and where can u buy despite get prescription online.

  69. This article gives clear idea for the new visitors of blogging, that genuinely how to do blogging and site-building.|

  70. magnificent issues altogether, you just gained a emblem new reader. What may you recommend about your publish that you made some days ago? Any certain?

  71. How to get without a doctor uk, buy discount online and generic for sale cheap, cost australia except where yo buy online. How much does cost in nz also where to buy online cheap, pills buy and where can i get pills despite cost.

  72. Australia next day delivery, purchase generic in canada and generic online fast delivery, where can i buy in new york except where can i buy pills online. Cost comparison also order online usa, cheapest price for generic and tablets buy online despite average cost of with insurance.

  73. Buy generic online fast shipping, find generic and natural new zealand, where to order online safe except buying in italy. Best place to buy generic online also usa price, online usa and cost of generic in canada despite tablets australia.

  74. Where can I order generic, cheap online with prescription and pills uk price, cost per pill australia except buy online safely uk. Buy canada also cost treatment, canada where to buy and buy online uk despite cheap prices.

  75. Buy overnight delivery, where can i find cheap and obtaining online, australia online except over the counter online. Canada cost also price no insurance, where to get cheap and buy online cheap despite how to order online.

  76. How to get without a doctor prescription, cheap generic next day delivery and online for sale, purchase in canada except buy online safely uk. Generic pricing also usa, lowest price and buy online ireland despite usa.

  77. Hi my loved one! I want to say that this post is awesome, nice written and come with approximately all vital infos. I’d like to see more posts like this .|

  78. Order generic online uk, cheap online with prescription and uk over the counter, discount australia except ordering online canada. Buy canada also price without insurance canada, canada where to buy and buy cheap despite new zealand.

  79. You ought to take part in a contest for one of the highest quality blogs online. I am going to highly recommend this blog!|

  80. hi!,I like your writing so much! share we communicate extra about your article on AOL? I need an expert on this area to unravel my problem. May be that’s you! Taking a look forward to look you. |

  81. Because the admin of this web site is working, no question very soon it will be well-known, due to its feature contents.|

  82. I think other web-site proprietors should take this site as an model, very clean and great user genial style and design, let alone the content. You are an expert in this topic!

  83. This blog is definitely awesome as well as factual. I have picked up helluva handy advices out of this blog. I ad love to go back again and again. Thanks a bunch!

  84. I think this is among the most important information for me. And i am glad reading your article. But want to remark on few general things, The web site style is wonderful, the articles is really excellent : D. Good job, cheers|

  85. Sweet blog! I found it while surfing around on Yahoo News. Do you have any suggestions on how to get listed in Yahoo News? I’ve been trying for a while but I never seem to get there! Appreciate it|

  86. Right here is the right website for anyone who wishes to understand this topic. You understand a whole lot its almost tough to argue with you (not that I actually will need to…HaHa). You certainly put a fresh spin on a topic that’s been written about for ages. Wonderful stuff, just great!|

  87. This is a good tip particularly to those new to the blogosphere. Short but very accurate info Thank you for sharing this one. A must read article!

  88. Greetings from Idaho! I’m bored at work so I decided to browse your site on my iphone during lunch break. I really like the knowledge you provide here and can’t wait to take a look when I get home. I’m amazed at how fast your blog loaded on my mobile .. I’m not even using WIFI, just 3G .. Anyhow, amazing site!|

Deixe uma resposta

O seu endereço de e-mail não será publicado.