Reporting Services: Interrogation de listes Sharepoint

Intégrer des rapports SSRS dans MOSS ou WSS, c’est facile… Interroger du contenu Sharepoint depuis un rapport SSRS, c’est une autre histoire. Etrange d’ailleurs que MS ne propose pas de connecteur permettant de le faire nativement.
Le truc consiste donc à interroger les webservices mis à disposition par Sharepoint pour arriver au résultat escompté.

Voici donc la marche à suivre:

    Dans la source de données, utiliser le connecteur XML en précisant l’URL d’accès au Webservice Lists.asmx de votre serveur Sharepoint.

Dans les informations d’identifications, seules les options utiliser l’authentification Windows et Ne pas demander les informations d’identification sont utilisables. Il convient donc de s’assurer que l’utilisateur qui exécute le rapport dispose des droits nécessaires pour interroger le contenu Sharepoint.

Voyons en premier lieu comment créer un dataset basé sur cette source de données qui interroge la méthode GetListCollection. Cette dernière permet de lister les bibliothèques de documents disponibles.
<Query> <Method Namespace=”http://schemas.microsoft.com/sharepoint/soap” Name=”GetListCollection” /></Query>

Pour obtenir le détail du contenu d’une de ces listes, c’est la méthode GetListItems qu’il faut interroger. Celle-ci prend en entrée les paramètres listName (guid ou nom d’une liste) et viewName (guid d’une vue, vue par défaut si null). <Query> <Method Namespace=”http://schemas.microsoft.com/sharepoint/soap/” Name=”GetListItems”/><SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction> <Parameters> <Parameter Name=”listName”> <DefaultValue>/</DefaultValue> </Parameter> <Parameter Name=”viewName”> <DefaultValue>/</DefaultValue> </Parameter> </Parameters></Query>Ne pas oublier de créer les deux paramètres correspondant dans le dataset. Si ceux-ci n’existent pas, la requête ne fonctionnera pas.

On peut maintenant tester l’exécution de la requête. On commence par renseigner les valeurs des paramètres.

Et voilà le résultat!

145 thoughts on “Reporting Services: Interrogation de listes Sharepoint

  1. We stumbled over here from a different website and thought I should check things out. I like what I see so now i’m following you. Look forward to checking out your web page for a second time.

  2. I know this if off topic but I’m looking into starting my own weblog and was wondering what all is needed to get setup? I’m assuming having a blog like yours would cost a pretty penny? I’m not very web smart so I’m not 100% sure. Any suggestions or advice would be greatly appreciated. Cheers

  3. I was curious if you ever considered changing the page layout of your blog? Its very well written; I love what youve got to say. But maybe you could a little more in the way of content so people could connect with it better. Youve got an awful lot of text for only having 1 or 2 pictures. Maybe you could space it out better?

  4. Pingback: chBKerwe

  5. Pingback: ナイキ ランニングシューズ

  6. Pingback: ナイキスニーカー

  7. Pingback: ナイキスニーカー

  8. Pingback: nike

  9. Please let me know if you’re looking for a author for your weblog. You have some really great posts and I feel I would be a good asset. If you ever want to take some of the load off, I’d love to write some articles for your blog in exchange for a link back to mine. Please send me an email if interested. Regards!

  10. Pingback: HERMES BIRKIN BAGS

  11. Pingback: Isabel Marant Sneakers Pas Cher

  12. Pingback: cheap mulberry bags

  13. Pingback: handbags chanel

  14. Pingback: air jordan?sneakers

  15. Pingback: ghd hair outlet

  16. Pingback: hermes birkin kelly

  17. Pingback: bandage dresses herve leger

  18. Pingback: BEATS BY DRE

  19. Pingback: HANDBAG HERMES

  20. Pingback: hermes belt

  21. Pingback: Kelly Bag Hermes

  22. Pingback: GHD HAIR STRAIGHTENER

  23. Pingback: AIR JORDAN SHOES

  24. Pingback: GHD OUTLET

  25. Pingback: Mbt Mens Shoes

  26. Pingback: Hermes Bags

  27. Hello! This post couldn’t be written any better! Reading through this post reminds me of my old room mate! He always kept chatting about this. I will forward this page to him. Fairly certain he will have a good read. Many thanks for sharing!

  28. Pingback: EhRlrcYh

  29. Pingback: ルイヴィトン財布

  30. Pingback: Hermes Kelly Purse

  31. Pingback: 群发

  32. Pingback: NIKE WOMEN FREE

  33. Pingback: RUN FREE NIKE

  34. Pingback: hermes bags birkin

  35. Pingback: Herve Leger Clothing

  36. Pingback: CHANEL OUTLET

  37. Pingback: Parfume Hermes

  38. Pingback: birkin hermes bag

  39. Pingback: Herve Leger Gowns

  40. Pingback: chanel bags

  41. Pingback: Herve Leger Outlet

  42. Pingback: birkin bags hermes

  43. Pingback: kelly hermes bag

  44. Pingback: HERVE LEGER BANDAGE DRESSES

  45. Pingback: Belt Hermes

  46. Pingback: トリーバーチ バッグ

  47. Pingback: キャリーバッグ

  48. Pingback: Diablo 3 Gold

  49. Pingback: ポーチ

  50. Pingback: diLoKERf

  51. Pingback: グッチ

  52. Pingback: yYifwcre

  53. Pingback: pig

  54. Pingback: nike tn

  55. Pingback: WEDDING DRESSES 2013

  56. Pingback: trx equipment

  57. Pingback: d3 gold

  58. Pingback: Ceinture Burberry pas cher

  59. Pingback: wow gold

  60. Pingback: ray ban sunglasses sale

  61. Pingback: Barcelona Jersey 2013

  62. Pingback: free run nike

  63. Pingback: wholesale soccer jerseys

  64. Pingback: nike free outlet

  65. Pingback: mbt sale

  66. Pingback: Inter Milan Jersey 2013

  67. Pingback: mbt clearance men

  68. Pingback: CHANEL HANDBAGS CHEAP

  69. Pingback: BOSE HEADSET

  70. Pingback: Chelsea Jersey 2013

  71. Pingback: Hermes Kelly

  72. Pingback: manchester city jersey

  73. Pingback: AIR JORDAN NIKE

  74. Pingback: discount ray ban sunglasses

  75. Pingback: NIKE RUN FREE

  76. Pingback: chanel wallet

  77. Pingback: JORDAN RETRO 11

  78. Pingback: MONSTER BEATS SOLO HD

  79. Pingback: birkin bag hermes

  80. Pingback: FULHAM JERSEY HOME

  81. Pingback: nigeria jersey away

  82. Pingback: hermes birkin

  83. Pingback: RALPH LAUREN UK

  84. Pingback: MANCHESTER UNITED JERSEY

  85. Pingback: beats by dre solo

  86. Pingback: psv eindhoven jersey

  87. Pingback: NIKE FREE WOMEN

  88. Pingback: Monaco Jersey Away

  89. Pingback: switzerland jersey

  90. Pingback: Paraguay Jersey

  91. Pingback: HERVE LEGER BANDAGE DRESS

  92. Pingback: PRADA WALLET SALE

  93. Pingback: nike run free

  94. Pingback: Gucci Outlet

  95. Pingback: ARGENTINA JERSEY 2013

  96. Pingback: spain jersey

  97. Pingback: Newcastle United Jersey

  98. Pingback: herve leger dress sale

  99. Pingback: free run nike

  100. Pingback: chanel handbag

  101. Pingback: gucci handbags cheap

  102. Pingback: Mbt Footwear

  103. Pingback: bags hermes

  104. Pingback: germany jersey away

  105. Pingback: Serbia Jersey Away

  106. Pingback: mbt clearance

  107. Pingback: Colombia Jersey

  108. Pingback: BEATS BY DRE OUTLET

  109. Pingback: Prada Shoes

  110. Pingback: Denmark Jersey

  111. Pingback: burberry wallet

  112. Pingback: レイバン サングラス

  113. Pingback: bordeaux jersey away

  114. Pingback: Honduras Jersey Home

  115. Pingback: Hermes Handbags

  116. Pingback: AC MILAN JERSEY

  117. Pingback: liverpool jersey

  118. Pingback: real madrid jersey

  119. Pingback: Algeria Jersey 2014

  120. Pingback: Tottenham Hotspur Jersey

  121. Pingback: burberry coat

  122. Pingback: paris st germain jersey

  123. Pingback: louis vuitton bags

  124. Pingback: croatia jersey 2013

  125. Pingback: cameroon jersey away

  126. Pingback: Ray Ban Sunglasses Outlet

  127. Pingback: bayer leverkusen jersey home

  128. Pingback: Cheap Mac Cosmetics

  129. Pingback: Colombia Jersey

  130. Pingback: Arsenal Jersey

Leave a Reply

Your email address will not be published. Required fields are marked *


× one = 3

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>