locked
Can I use the main report's DataSet in a subreport? RRS feed

  • Question

  • My dataset is not a shared dataset but, can I use it for a subreport?

    Thursday, December 26, 2013 6:40 PM

Answers

  • Hi Nine_Iron,

    In Reporting Services, there are two types’ dataset which are shared dataset and embedded dataset.

    A shared dataset is published on a report server and can be used by multiple reports and must be based on a shared data source. Shared datasets can be cached and scheduled by creating a cache refresh plan. Embedded datasets are defined in and used by a single report.

    If you want to use the same dataset to the main report in the subreport, you can make the dataset as a shared dataset. In addition, you can create a dataset in the subreport when the data source is same between main report and subreport.

    If you only want to use the field of the main report in the subreport, you can create parameters, and make the parameters get values from a query. And then pass the parameter to the subreport.

    Reference: Embedded and Shared Datasets (Report Builder and SSRS)

    Regards,
    Heidi Duan

    Heidi Duan
    TechNet Community Support

    • Proposed as answer by Praveen Rayan D'sa Friday, December 27, 2013 6:42 AM
    • Marked as answer by Heidi-Duan Monday, December 30, 2013 2:12 AM
    Friday, December 27, 2013 6:39 AM

All replies

  • No, You would have to make it a shared dataset.

    Hope this helps........


    Ione

    Thursday, December 26, 2013 7:21 PM
  • Hi Nine_Iron,

    In Reporting Services, there are two types’ dataset which are shared dataset and embedded dataset.

    A shared dataset is published on a report server and can be used by multiple reports and must be based on a shared data source. Shared datasets can be cached and scheduled by creating a cache refresh plan. Embedded datasets are defined in and used by a single report.

    If you want to use the same dataset to the main report in the subreport, you can make the dataset as a shared dataset. In addition, you can create a dataset in the subreport when the data source is same between main report and subreport.

    If you only want to use the field of the main report in the subreport, you can create parameters, and make the parameters get values from a query. And then pass the parameter to the subreport.

    Reference: Embedded and Shared Datasets (Report Builder and SSRS)

    Regards,
    Heidi Duan

    Heidi Duan
    TechNet Community Support

    • Proposed as answer by Praveen Rayan D'sa Friday, December 27, 2013 6:42 AM
    • Marked as answer by Heidi-Duan Monday, December 30, 2013 2:12 AM
    Friday, December 27, 2013 6:39 AM