Subreports within reports

[mattpearcey]

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

 

[dawnd3]

If you are doing a subreport you would not have the records in the same query, instead you would have 2 queries, and then the subreport linked up via the report design. If you keep it in the same query and it works without repeating data, it sounds like you may just have fields in the wrong grouping sections in the report. So maybe you need to group by a feild in table a and then by a feild in table b, and then the detail section would have your data from table c. Since I am not looking at it, it is hard to say if I am giving you correct information. If you want to send it, I will be happy to look at it for you. dawn@calliopeconsulting.net

Dawn

http://www.calliopeconsulting.net