locked
Linking Parent & Child Datasets RRS feed

  • Question

  • I had hoped to create a report with a Listbox grouped on the Parent Dataset - then text boxes at Parent Dataset level and a table at the Child Dataset level.    I cannot link the table with the Child Dataset correctly.  I have tried the Filter facility and the filtering does not synchronise with the List Box or Text boxes at the parent level.

    The only way I have found to do this is a Sub Report with a query parameter.   Can this be done with  table or is that not possible???
    PG
    Monday, February 15, 2010 1:13 PM

Answers

  • Hi Patrick,

    As it stands, SSRS doesn't support joining datasets at report level. Your options are:

    1. Merge the two datasets into a single dataset that has both parent and child records.
    2. Use a subreport.
    Prologika (Teo Lachev's Weblog)
    Teo Lachev, Prologika LLC
    http://www.prologika.com
    • Marked as answer by Patrick Grant Monday, February 15, 2010 10:49 PM
    Monday, February 15, 2010 2:15 PM