Reporting Services: Interrogation de listes Sharepoint

Posted on by

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”

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

    Reply ↓

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

    Reply ↓

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

    Reply ↓

  11. Pingback: chBKerwe

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

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

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

  15. Pingback: nike

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

    Reply ↓

  18. Pingback: HERMES BIRKIN BAGS

  19. Pingback: Isabel Marant Sneakers Pas Cher

  20. Pingback: cheap mulberry bags

  21. Pingback: handbags chanel

  22. Pingback: air jordan?sneakers

  23. Pingback: ghd hair outlet

  24. Pingback: hermes birkin kelly

  25. Pingback: bandage dresses herve leger

  26. Pingback: BEATS BY DRE

  27. Pingback: HANDBAG HERMES

  28. Pingback: hermes belt

  29. Pingback: Kelly Bag Hermes

  30. Pingback: GHD HAIR STRAIGHTENER

  31. Pingback: AIR JORDAN SHOES

  32. Pingback: GHD OUTLET

  33. Pingback: Mbt Mens Shoes

  34. Pingback: Hermes Bags

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

    Reply ↓

  36. Pingback: EhRlrcYh

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

  38. Pingback: Hermes Kelly Purse

  39. Pingback: 群发

  40. Pingback: NIKE WOMEN FREE

  41. Pingback: RUN FREE NIKE

  42. Pingback: hermes bags birkin

  43. Pingback: Herve Leger Clothing

  44. Pingback: CHANEL OUTLET

  45. Pingback: Parfume Hermes

  46. Pingback: birkin hermes bag

  47. Pingback: Herve Leger Gowns

  48. Pingback: chanel bags

  49. Pingback: Herve Leger Outlet

  50. Pingback: birkin bags hermes

  51. Pingback: kelly hermes bag

  52. Pingback: HERVE LEGER BANDAGE DRESSES

  53. Pingback: Belt Hermes

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

  55. Pingback: キャリーバッグ

  56. Pingback: Diablo 3 Gold

  57. Pingback: ポーチ

  58. Pingback: diLoKERf

  59. Pingback: グッチ

  60. Pingback: yYifwcre

  62. Pingback: pig

  63. Pingback: nike tn

  64. Pingback: WEDDING DRESSES 2013

  65. Pingback: trx equipment

  67. Pingback: d3 gold

  68. Pingback: Ceinture Burberry pas cher

  70. Pingback: wow gold

  71. Pingback: ray ban sunglasses sale

  72. Pingback: Barcelona Jersey 2013

  73. Pingback: free run nike

  74. Pingback: wholesale soccer jerseys

  75. Pingback: nike free outlet

  76. Pingback: mbt sale

  77. Pingback: Inter Milan Jersey 2013

  78. Pingback: mbt clearance men

  79. Pingback: CHANEL HANDBAGS CHEAP

  80. Pingback: BOSE HEADSET

  81. Pingback: Chelsea Jersey 2013

  82. Pingback: Hermes Kelly

  83. Pingback: manchester city jersey

  84. Pingback: AIR JORDAN NIKE

  85. Pingback: discount ray ban sunglasses

  86. Pingback: NIKE RUN FREE

  87. Pingback: chanel wallet

  92. Pingback: JORDAN RETRO 11

  93. Pingback: MONSTER BEATS SOLO HD

  94. Pingback: birkin bag hermes

  95. Pingback: FULHAM JERSEY HOME

  96. Pingback: nigeria jersey away

  97. Pingback: hermes birkin

  98. Pingback: RALPH LAUREN UK

  99. Pingback: MANCHESTER UNITED JERSEY

  100. Pingback: beats by dre solo

  101. Pingback: psv eindhoven jersey

  102. Pingback: NIKE FREE WOMEN

  103. Pingback: Monaco Jersey Away

  104. Pingback: switzerland jersey

  105. Pingback: Paraguay Jersey

  106. Pingback: HERVE LEGER BANDAGE DRESS

  107. Pingback: PRADA WALLET SALE

  108. Pingback: nike run free

  109. Pingback: Gucci Outlet

  110. Pingback: ARGENTINA JERSEY 2013

  111. Pingback: spain jersey

  112. Pingback: Newcastle United Jersey

  113. Pingback: herve leger dress sale

  114. Pingback: free run nike

  115. Pingback: chanel handbag

  116. Pingback: gucci handbags cheap

  117. Pingback: Mbt Footwear

  118. Pingback: bags hermes

  119. Pingback: germany jersey away

  120. Pingback: Serbia Jersey Away

  121. Pingback: mbt clearance

  122. Pingback: Colombia Jersey

  123. Pingback: BEATS BY DRE OUTLET

  124. Pingback: Prada Shoes

  125. Pingback: Denmark Jersey

  126. Pingback: burberry wallet

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

  128. Pingback: bordeaux jersey away

  129. Pingback: Honduras Jersey Home

  130. Pingback: Hermes Handbags

  131. Pingback: AC MILAN JERSEY

  132. Pingback: liverpool jersey

  133. Pingback: real madrid jersey

  134. Pingback: Algeria Jersey 2014

  135. Pingback: Tottenham Hotspur Jersey

  136. Pingback: burberry coat

  137. Pingback: paris st germain jersey

  138. Pingback: louis vuitton bags

  139. Pingback: croatia jersey 2013

  140. Pingback: cameroon jersey away

  141. Pingback: Ray Ban Sunglasses Outlet

  142. Pingback: bayer leverkusen jersey home

  143. Pingback: Cheap Mac Cosmetics

  144. Pingback: Colombia Jersey

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