|
Since the subreport is in the group footer, what needs to happen is that the main report has to have an entry for the attorney, even it all the fields are blank.
What you could do is have all the display fields in the detail section be blank. In the Section Expert for the detail section check 'Suppress if blank'.
Everything should work as desired.
Going to need a LEFT JOIN somewhere to get attorneys without the detail section. Of course, then you have to deal with attorneys with no detail and no subreport.
If you can add criteria to the stored proc or the where clause that checks if the attorney has a subreport or not, that would be helpful.
HTH
|