report with sub report

I have a master detail report that I'm having trouble
with, I have the report layed out and populating fields in
the master report with data, my report uses data from the
master report and passes it to the subreport, that is all
working well, the problem is I only get data for the last
record in the master dataset... It's not displaying a new
page for each records in the master dataset... None of my
fields use the First function... My grouping in my query
is setup correctly, is there any other place to setup
grouping in the report designer...? What am I doing
wrong...?You either need to add a table or a rectangle and then tie them to the
dataset. If you just put textboxes on the report it will only display the
last record. See the thread just after this one from Alien_251
"Dan@.Monaco" wrote:
> I have a master detail report that I'm having trouble
> with, I have the report layed out and populating fields in
> the master report with data, my report uses data from the
> master report and passes it to the subreport, that is all
> working well, the problem is I only get data for the last
> record in the master dataset... It's not displaying a new
> page for each records in the master dataset... None of my
> fields use the First function... My grouping in my query
> is setup correctly, is there any other place to setup
> grouping in the report designer...? What am I doing
> wrong...?
>

Report with 2 or more tables and repeated rows.

Hello,

I'm encountering a problem. The following happens:
I make 2 tables in my report. Both tables have detail rows.
The 2 tables can have a different amount of (repeated)detail rows (e.g. The one table most to the top of the report has 3 detail rows an the other, below the topmost table, has 6)

The thing now is that every detailrow in the bottom table is repeated 3 times(so 3x6 is 18 rows...)
Does anyone know how to solve this problem?

Thanks,

Fedor BrouwerI don't think the 2 tables are affecting each other, unless one is nested inside the other. This will probably be down to the way the row groups have been set up but without more information about the report it's a bit difficult to say.