sql server reporting services: Two different detail tables for a master table's row -- sql server reporting services

You're in the

sql server reporting services

group:

Two different detail tables for a master table's row

Stefan Falk
12/31/2005 1:38:57 PM

sql server reporting services: Hello everybody,

I have a master data set returning rows about projects. For each project,
there are two kinds of detail data: The time periods used for work for the
project, and the travels to the customer. Both have, of course, different
numbers of rows for each project, and totally different columns (besides the
project id linking all this together).

I want to have a report listing every project, and for each project the
times and the travels. Online help says that in many cases data regions
could be used where we would have used subreports in the past (that is, in
Microsoft Access reports, I guess).

I tried to have a RS table with another table in a detail cell, but RS
(2000) does not allow me to nest tables. Do I need two subreports here or
ist there any magic trick I miss?

Thanks in advance, and have a great 2006,
Stefan Falk

Re: Two different detail tables for a master table's row

Bruce L-C [MVP]
12/31/2005 8:12:11 PM

Assuming you are going to show multiple master records and the detail
records for each, then you need to be using subreports. If you have a single
mater record and then the detail for that master you can use data regions.

Since you are going to list every project then you do need to use
subreports.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

To do master detail type reports you really need to have subreports
[quoted text, click to view]

Re: Two different detail tables for a master table's row

Stefan Falk
1/1/2006 11:11:06 AM

Hello Bruce,

thank you very much for your fast response. Have a great new year!

Stefan

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn