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
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.
Teo Lachev, Prologika LLC http://www.prologika.com
Marked as answer byPatrick GrantMonday, February 15, 2010 10:49 PM