Tuesday, March 1, 2011

Create SSRS Report with SharePoint 2010 Integrated Mode

With SharePoint 2010, lots people would like to use SSRS Integrated mode. The advantage is that you can deploy data sources, reports, etc. to the SharePoint document library instead of the Report Manager web application. In addition, you could also use the new version of Report Builder that came with SQL Server 2008 R2 and deploy the reports to SharePoint.  Derek Sanderson posted a blog entry: How to Switch from SSRS Native Mode to SharePoint Integrated Mode with detailed graphic information to show step by step how to do it. Once you completed all the installation steps, you may want to create the SSRS reports on it. The following steps show you how to do it.

Create SSRS Report Document Library

In order to deploy or create SSRS artifacts, you need to add a document library with the appropriate content types.

  • Create a new document library called SSRS Report

image

  • Go to the Library tab and click on the Library Settings menu to configure the content type

image

  • In the General settings section, click on the Advanced settings link

image

  • Change the Allow management of content types? to “Yes” and click the OK button to apply the change

image 

  • In the Content Types section, click on the Add from existing site content types link

image

  • Select the Report Builder Model, Report Builder Report, and Report data source content types from the Available Site Content Types list to be added, then click the OK button to apply the change.

image

  • If you want to change the default or the visible order of the content types, you could click on the Change new button order and default content type link and modify accordingly.

image

image

  • Return back to the SSRS Report Document library, and click on the New Document from the Documents tab. Now you should be able to see the Report Builder menus that have been created.

image

  • To launch the Report Builder, click the Report Builder Report menu.  You can now use it to create the SSRS reports and save them to the SharePoint document library.

image

Deploy SSRS Report from Visual Studio to SharePoint
  • To deploy the SSRS report using Visual studio 2008, you will need to point to the SharePoint Server site, not the Report Manager site. Using the example we created, you will need to set the TargetServerURL to be the http://localhost/, and set the TargetReportFolder to be http://Localhost/SSRS Report

image

  • Make sure you don’t append the “/” at end of the TargetReportFolder such as http://Localhost/SSRS Report/, otherwise you will get the following deployment error:

    Error rsItemNotFound : The item 'http://Localhost/SSRS Report//Demo SSRS.rdl' cannot be found.
    Deploy complete -- 1 errors, 1 warnings

image

Manage SSRS Data Sources, Parameters, and Permissions
  • Go to the right side of the report and click the drop down to open the Context Menu. You could set the data source, configure the parameters, or manage the permissions for the report by clicking on the corresponding context menu.

image

View SSRS Report
  • You could now view the report from SharePoint Site by clicking on the report itself.

image

  • Or view the report from the Report Server Site by navigating to the report directory.

image

53 comments:

  1. Thanks for the article.
    I got login prompt when i click the Report Builder Report and it keeps on asking even if put the correct info.

    Could you please help me to fix?

    SP2010 with SQL 2008 R2 ( SP integration Mode)

    Thanks
    Murali

    ReplyDelete
  2. This is an awesome post Fendy! There will be no one to stop me this time.

    ReplyDelete
  3. Hi Fendym this is Sarat, please give the steps how to create SSRS report using SSAS Cubes.

    ReplyDelete
  4. Murli,
    Did you ever figure out why it keeps prompting you for correct info? I am having the same issue.

    ReplyDelete
  5. Murli, gold2k, Fendy, has there been any update on the login prompt issue? Any fixes provided? I'm experiencing the same thing. Any help would be amazing, thanks.

    ReplyDelete
  6. Awesome .........
    It Is very useful for me right now............

    ReplyDelete
  7. Would like to recommend HarePoint Analytics for SharePoint: the essential web-analytics solution for SharePoint-based sites and portals. More 70 reports, wide customization,

    great features.
    Homepage: http://www.harepoint.com/Products/HarePointAnalyticsForSharePoint/Default.aspx

    ReplyDelete
  8. Very useful post for share point guys

    ReplyDelete
  9. I'm also having the login prompt that Murli, gold2k, and GoodieJRAug had. Were you able to solve this?

    ReplyDelete
  10. Thanks, helped me a bunch today! :)

    ReplyDelete
  11. Thanks for the Article. Let me ask you this, We have around 500 reports that i have deployed using the above procedure, Now in order for the report to work, I have to connect all the reports to the shared data source that was also deployed on the SharePoint site too, Going into each report and connecting them to data source is too much of work. May i know how you would do that? Is there any easy way to do like a powershells cript?

    ReplyDelete
  12. Thanks for the article to help me out of the stuck.

    Oscar

    ReplyDelete
  13. This is a great post and thank you for sharing this nice experience,and hope you can give another posts as soon as possible.
    Computer Cases

    ReplyDelete
  14. Is this Reporting Content Types are available for SharePoint List also?

    ReplyDelete
  15. Hi
    i am able to get Report content Type but when i tried to launch the Report builder i am getting exception like "could not down load the application The application is missing reqired files contact vender assistance " can any one tell what mistake i have done

    ReplyDelete
  16. hallo miss, i'am newbie in Bussiness Intellegent, i want to know more about this BI. can you help me for creating dashboard in SSRS to Sharepoint 2010 ?
    i wish you read this comment :)
    thanks a lot :)

    ReplyDelete
  17. Very Nice Collection of Off-Page SEO Resources.. Such a information very very helpful for SEO Expert in Submission.

    Thanks for sharing...

    Local Business Listing Site

    ReplyDelete
  18. Hi Fendy Huang,

    I have successfully configured one environment, but in another environment I am having below issue.

    Reporting Services Error

    Report Server has encountered a SharePoint error. (rsSharePointError)
    The system cannot find the path specified. (Exception from HRESULT: 0x80070003)

    I have googled it a lot can you please help me in this issue.

    ReplyDelete
  19. http://camaragenbandarq.blogspot.com/2017/05/membahas-macam-macam-judi-di-indonesia.html
    http://agenbandarqcamarqq.blogspot.com/2017/05/mengetahui-4-tempat-judi-termewah-di.html
    http://agendomino99camarqq.blogspot.com/2017/06/trik-curang-main-bandarq.html
    http://agendominocamar.blogspot.com/2017/06/mengetahui-warnet-di-jepang-yang.html
    http://agendominocamarqq.blogspot.com/2017/06/cara-mendaftar-di-shioqq-situs-agen.html
    http://www.jakartatercinta.com/2017/05/mengenal-situs-shioqq-agen-bandarq.html
    http://www.jakartatercinta.com/2017/05/shioqqnet-agen-bandarq-yang-memberi.html

    ReplyDelete
  20. >>> agen poker <<<
    ************************************************
    >>> agen domino <<<
    ************************************************
    >>> bandar poker <<<
    ************************************************
    >>> bandar domino <<<
    ************************************************
    >>> bendera poker <<<
    ************************************************

    Benderapoker BANDAR POKER ONLINE DAN AGEN DOMINO QIU QIU TERPERCAYA DI INDONESIA
    Pin BBM : D1FB4EC6
    Tel/ WA : +855.962.071.913
    Livechat : www.benderapoker.com

    Raih kemenangan judi online anda bersama kami sekarang juga, dan rasakan sensasi permainan Player Vs Player 100% dan dapatkan jackpot yang sangat mudah hanya di Benderapoker .. :)



    ReplyDelete
  21. It's really good post because it helpful for learners. check it once through MSBI Online Training Hyderabad

    ReplyDelete
  22. I do believe all of the concepts you’ve introduced in your post. They’re very convincing and will definitely work. The info you provided is very useful for any interested on SSRS. I wish I can get furthered information from you.I am very glad to say thanks for this useful content.
    SSRS Tutorial

    ReplyDelete
  23. Really this is an Good information about how to Create and deploy SSRS Report Document Library. I appreciate your work.

    Thanks
    Katherine

    ReplyDelete
  24. As a result of this, all our tech support team team is generally ready to give you the required QuickBooks Enterprise Support. It is possible to dial our QuickBooks Support Phone Number anytime to get instant and reliable help.

    ReplyDelete
  25. I really liked this content As a matter of fact, I would be happy to fill out such knowledge to test myself in order to estimate how my knowledge is relevant as compared to the other blogs. I learn SQL Server technology from the industries leader "JanBask Training" and I believe your blog will help me to pass my certificate.

    ReplyDelete
  26. "It's very useful post and i had good experience with this salesforce training in bangalore who are offering good certification assistance. I would say salesforce training is a best way to get certified on crm.

    salesforce training in marathahalli
    salesforce training india
    "

    ReplyDelete
  27. I am reading your post from the beginning, it was so interesting to read & I feel thanks to you for posting such a good blog,i want to share some Information about splunk training and splunk tool tutorial . keep updates regularly..

    ReplyDelete
  28. Excellent information. The concept that explained is very useful and also ideas are awesome, I really love to read such wonderful article. Thankyou for the information.

    Azure Training in Bangalore

    Azure Training | microsoft azure certification | Azure Online Training Course

    Azure Online Training

    Azure Training in Hyderabad

    Azure Training in Pune

    Azure Training in Chennai

    ReplyDelete
  29. Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging.
    tally training in chennai

    hadoop training in chennai

    sap training in chennai

    oracle training in chennai

    angular js training in chennai

    ReplyDelete
  30. Thanks for providing a useful article containing valuable information. start learning the best online software courses.
    data science training in chennai

    ccna training in chennai

    iot training in chennai

    ethical hacking training in chennai

    cyber security training in chennai

    ReplyDelete
  31. This comment has been removed by the author.

    ReplyDelete