locked
Reporting for Sharepoint RRS feed

  • Question

  • Hello,

    I am very new to sharepoint.

    My working environment is Sharepoint 2007 with Sql Server 2005 and Visual Studio 2008.

    I must create some simple reports and i've been suggested to do them using reporting services.

    I have googled and i have read some articles that use bids to create reports and deploy them to sharepoint. I don't have bids installed with my sql server and i haven't got the installation cd. I work in a VM. I tried to add the feature but it asks for the cd.

    In this case, what can i do? Can i use visual studio to create rdlc reports? Can you please suggest me a tutorial that work with sharepoint?

    Thanks in advance.

    Tuesday, September 4, 2012 2:58 PM

All replies

  • A way around this then might be to install a Performance Point demo, which'll install BIDS or graft it onto your VS installation.

    PerformancePoint is also a way to look at reporting and KPI metrics in SharePoint 2007.  It's a seperate product for this version of SharePoint which you may already be entitled too depending on your licensing.


    Steven Andrews | SharePoint Professional | http://www.twitter.com/backpackerd00d | https://baron72.wordpress.com/

    Wednesday, September 5, 2012 10:05 AM
    Answerer
  • Thanks a lot for the reply!! I shall try it!

    This means that i can't create a rdlc report with visual studio 2008 report in a project like reports application and integrate afterwards this rdlc in sharepoint?


    • Edited by NetC0der Wednesday, September 5, 2012 11:48 AM
    Wednesday, September 5, 2012 11:47 AM
  • BIDS is the creation tool, which is where things like OLAP cubes, connections and all the drill downs are defined.  When you publish this into SharePoint, it's an interactive report that allows users to interact with the END report, not the BIDS project that generated it.

    Beyond that, I'd be speaking outside the limits of my experience, so I couldn't really say.


    Steven Andrews | SharePoint Professional | http://www.twitter.com/backpackerd00d | https://baron72.wordpress.com/

    Wednesday, September 5, 2012 12:11 PM
    Answerer
  • Hi, thanks for the reply!

    I have tried installing Performance Point but it requires vs 2005 and i have vs 2008 so it didn't work. Now i am trying to get the kit to install workstation components (bids) for my installed instance of Sql Server 2005.

    Thanks again for the help.

    Sunday, September 9, 2012 7:31 PM