3 groups and master detail printing in group footer
Hi there
I have 2 pipe lines, a master and a detail which I have set up the
master detail relationship on.
Master has columns A, B, C, D, E and the detail has 1, 2, 3, 4, 5.
The relationship between the 2 is A = 1, B = 2, C = 3.
In the report I have grouped by Columns A, B and C and in the Footer for
C I want to print any detail records that my exist. I have put a
sub-report in the footer for C and attached it to the detail pipe line.
The problem is that the report only prints the master records for
which details exist.
If I remove the master detail relationship from the pipe lines then the
detail prints each time the footer is printed.
How can I make it so that all master records are printed and then the
details are printed as necessary?
Cheers
Carl
I have 2 pipe lines, a master and a detail which I have set up the
master detail relationship on.
Master has columns A, B, C, D, E and the detail has 1, 2, 3, 4, 5.
The relationship between the 2 is A = 1, B = 2, C = 3.
In the report I have grouped by Columns A, B and C and in the Footer for
C I want to print any detail records that my exist. I have put a
sub-report in the footer for C and attached it to the detail pipe line.
The problem is that the report only prints the master records for
which details exist.
If I remove the master detail relationship from the pipe lines then the
detail prints each time the footer is printed.
How can I make it so that all master records are printed and then the
details are printed as necessary?
Cheers
Carl
This discussion has been closed.
Comments