Hi,



I came across a problem with master detail regions:



I have two data sets in my report ( MasterDS and DetailDS)

The report layout items are within a free form list region and MasterDS is
the list's data source.



I also have a table region with the main list region. I defined DetailDS as
the table's data source. The problem is that even RS shows DetailDS as the
table's data source, it still consider MsterDS as table region's data
source.



Here is the general explanation of the problem:



In nested regions situation, RS always considers the data source of the
surrounding region as the data source of all child regions. Even you see the
desired data source within the child region's properties dialog box; still
RS considers the surrounding data source one. You can see that by dropping
some fields in the child region. The filed become First or SUM.



Is it a bug, or by design, or I am missing something?



Any help would be appreciated,

Alan

Hi Alan,

Is it possible for you to generate a sample solution based on
AdventureWorks for me? More detailed descriptions, I believe, will bring us
closer to the resolution.

I understand the information may be sensitive to you, my direct email
address is v-mingqc@microsoft.com, you may send the file to me directly and
I will keep secure.

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Hi Michael,

Before we go for sending the report, I think I found something.

This link cleared the issue for me:

http://msdn2.microsoft.com/en-us/library/ms156394

It says:

Repeating Data Regions

You can use nested data regions to display the same data region multiple
times in your report. For example, you can create a sales order data report
that repeats a single sales order table multiple times, once for each
employee. You do this by creating another data region, such as a list, and
setting the grouping on that data region to employee. You would then place
the table inside of the data region. Datasets for both data regions must be
the same. If you need to create a report that uses grouping like this (such
as in a master-detail page) but with different datasets, use a subreport.


That means I cannot have nesting regions with different data source. I have
to use sub report.
Am I correct or I am mission something?

Regards,
Alan




[quoted text, click to view]

Hi Alan,

Thanks for your effort.

Yes, if the data sources are not the same one, you will have to use
subreport.

You may also consider performing a JOIN in the dataset to avoid the
subreport. (If the data are not on the same server, create Linked Server.)


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.