List Data Region Containing Multiple Tablix's
Hi, Generally, if embed a Tablix in a List control, it requires both the Tablix and the List refer to the same dataset. In your case, there are 2 possible workarounds to achieve: · Try to merge DataSet1, DataSet2 and DataSet3 to a single dataset. Then, we can embed Tablix in the List with referring to the same dataset. · Create 2 new reports with parameter, one based on DataSet2 and the other based on DataSet3. Then, add these 2 reports as Subreport to the List control instead of table, also set their parameters. For more information about How to Add a Subreport and Parameters, please refer to: http://msdn.microsoft.com/en-us/library/ms160348.aspx Thanks, Tony Chain Tony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.
February 18th, 2011 11:54pm
I have a List data region. What I would like to do is to display free-form information at the top of it (based on 'dataset1') and then embed two Tablix regions (based on 'dataset2' and 'dataset3'. However, in order to get this to work the way I want, the datasets the two tables are based on would need to be refreshed for each new row in the List and would need access to a value in dataset1 so the underlying queries dataset2 and dataset3 are based on retrieve the correct data. Can this be done. If so, how? Thanks!Randy Minder
February 19th, 2011 12:28am