locked
Sub Reports and Datasource RRS feed

  • Question

  • Hi,
    I am creating a subreport. I was trying to create a sub report with a shared data source.However this would not display the data when i would run my report.
    I then tried this with an embedded datasource using a stored procedure.
    This displays my data.
    Can this be done using a shared datasource?if so how can i implement this.The master report will have 3 further sub reports.

    Thanks for your time

    J
    Saturday, January 21, 2012 9:47 PM

Answers

  • Hi ,

     

      Currently you cannot run the sub reports with shared datasets or data source from BIDS. However when you deploy the report, you need manually configure the datasource/datasets in the report manager and then test the report.

     

    HTH,

    Ram


    Ram
    • Proposed as answer by Sanjeewan Kumar Sunday, January 22, 2012 3:33 AM
    • Marked as answer by JTigger79 Monday, January 23, 2012 9:43 AM
    Sunday, January 22, 2012 3:25 AM

All replies

  • There's no way to do it in the sub Report

    http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/74e51434-1d14-4fb1-9b1c-1a394c187b2f

     

    You can submit a feedback at MS connect here : https://connect.microsoft.com/SQLServer/feedback/details/648560/subreport-with-shared-dataset-throws-error

    Sunday, January 22, 2012 12:29 AM
  • Hi ,

     

      Currently you cannot run the sub reports with shared datasets or data source from BIDS. However when you deploy the report, you need manually configure the datasource/datasets in the report manager and then test the report.

     

    HTH,

    Ram


    Ram
    • Proposed as answer by Sanjeewan Kumar Sunday, January 22, 2012 3:33 AM
    • Marked as answer by JTigger79 Monday, January 23, 2012 9:43 AM
    Sunday, January 22, 2012 3:25 AM