none
How do I get my custom Reporting Services reports added to my BI Center library RRS feed

  • Question

  • PS 2010 - We created some status reports using Reporting Services pulling information from the SharePoint lists as well as from PWA. These reports currenly reside within the Reporting Services environment. When I try to upload the documents, I can't get to them.

    How do I get these reports to show up in the BI Center library? Our report creating team thinks I should be able to upload them just like I did the Excel reports, but I can't. I copy the url from the properties when I browse on the upload document screen, but it stays blank.

    Can someone help get my Reporting Services reports into the BI Center?

    Monday, March 19, 2012 10:20 PM

Answers

  • Thank you both for your responses.

    Amit - I also checked out both links you sent. I will get with our BI Team and my Systems administrator to walk through the steps included in the blogs. Although I will mark this question as "Answered" I will let you know how it works.

    • Marked as answer by smokief Tuesday, March 20, 2012 4:56 PM
    Tuesday, March 20, 2012 4:56 PM

All replies

  • You can use Dashboard Designer to link your reports inside dashboard pages and publish the pages to BI Center.

    Abhijeet M. Mohite

    Tuesday, March 20, 2012 6:22 AM
  • Hi there--

    1. To add a new report in EPM Dashboards 
    - Create a Report in BIDS solution -- Hope you already done
    - Open the Solution file in Business Intelligence Development Studio 2008 (BIDS)  - Hope you already done
    - Add a new Report , add the datasource as Sharepoint list type & complete it - Hope you already done
    - Save the Solution
    - Exit the BIDS 2008

    2. Login to PWA> Site Actions> View All Site contents
    3. Click on Reports under Document library
    4. Click on Document Tab > Upload document
    5. Browse the Solution file & select the newly created report
    6. Click on the Small Icon on newly created report & Click on Manage Data Sources > 
    7. Click on Datasource or custom databsource >browse the databasource
    8. Select the Data source for the report
    9. Select the data source (which is SharePoint list type datasource) & Hit OK.
    10. Now, Run the report by clicking on it.

    There are lot of step by step articles availables:
    http://fendy-huang.blogspot.in/2011/02/create-ssrs-report-with-sharepoint-2010.html
    http://dinesql.blogspot.in/2010/06/configuring-reporting-services-2008-r2_07.html

    Hope that helps.


    Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    Tuesday, March 20, 2012 8:39 AM
  • Thank you both for your responses.

    Amit - I also checked out both links you sent. I will get with our BI Team and my Systems administrator to walk through the steps included in the blogs. Although I will mark this question as "Answered" I will let you know how it works.

    • Marked as answer by smokief Tuesday, March 20, 2012 4:56 PM
    Tuesday, March 20, 2012 4:56 PM