Search results for query: *

Yes you are a genious thanks for your help. I also had to add an additional grouping level to the main report that grouped on GroupNum and forced a new page, this was in addition to the Link master/childs on groupnum. Thanks again, ;-) only took me 3 days. haha. iAmDmAn.

I see what you are getting at but my main report only has 1 record, ie. using your example, hypothetically: Main report: EmployeeID = 5 (returns 1 record) Sub report: All orders with employeeID = 5 (returns 25 records) Now, I can use your DCount technique to add a groupnum to the sub report...

I just realized, I don't think your idea would work. The sub-report is already part of a master child relationship, there is no ability to add another one. For example the sub-report is showing all invoice items for invoice id = 5. There are 20 invoice items associated with invoice id = 5...

Can you elaborate on how to add the group by 10 column to the sub report?

I will give that a shot, I am not optimistic.

bump

Is this by Microsofts' design? My sub-report contains: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Me.Parent.[PageBreak].Visible = RecCount Mod 10 = 0 End Sub I put a breakpoint above and the code is being executed but there is no affect in the parent form where...

Hello, I have a report which contains a sub report. The sub report displays items from an invoice and it is set to display "QTY|DESCRIPTION|AMOUNT QTY|DESCRIPTION|AMOUNT" across the top (as you can see the header is being repeated in column 2 by fixing the sub-report height to only have enough...