mattpearcey
Technical User
I think this is a basic one, but my head is spinning to solve it.
I have a report that is based on a query from 2 tables. One is a main table (a), and then attached to this is another table(b) for more records specific to that main record. Reports work fine for this, as one report.
However, i have just added a new table for processes within table (b) so i can have multiple process for one record. I have changed the query to add this table, and made them link as follows. Table a to table be - only if equal ID no.; then table b to table c, multiple records for each record in table b. The query result works fine for this. However, putting this into a report is hard. As, where i make a new report to include the new processes from table c - it puts these on a seperate page for each one, therefore duplicating all the report data to the amound of records for table c. Thus, a 4 page report turns into a messy 28 page report. How do i get the subreport to show all those related records on the one sheet, expanding down the page, as aposed to creating the report mulitple times?
Thank you for your help already.
Matt Pearcey
I have a report that is based on a query from 2 tables. One is a main table (a), and then attached to this is another table(b) for more records specific to that main record. Reports work fine for this, as one report.
However, i have just added a new table for processes within table (b) so i can have multiple process for one record. I have changed the query to add this table, and made them link as follows. Table a to table be - only if equal ID no.; then table b to table c, multiple records for each record in table b. The query result works fine for this. However, putting this into a report is hard. As, where i make a new report to include the new processes from table c - it puts these on a seperate page for each one, therefore duplicating all the report data to the amound of records for table c. Thus, a 4 page report turns into a messy 28 page report. How do i get the subreport to show all those related records on the one sheet, expanding down the page, as aposed to creating the report mulitple times?
Thank you for your help already.
Matt Pearcey