Hi
I am struggling to think of a way of getting a report to look decent, and wonder if anyone has any ideas.
I have a list of patients, and some demographics - thats no problem. Then I have a subform with details of any operations they have had.
The problem is that some of them have not had any, some have had a few, and when you set this bit up as a sub-report, its an unpredictable empty space.
I guess I will need to keep it as a sub-report, as there are a variable number of operations associated with patients.
Any ideas how i can do this???
Paul

Could you make the sub report control small and set the can grow property to true?

The problem with that is where you place it. If you put it on top of the demographics, it will leave an empty space, it you put it below, and the demographics are particularly long, they overlap onto the subform....

Create a Temporary Table with one record with the same structure of the table or query that is linked to the sub-report. If it has a text field that displays some text like name or remark field that appears on the report, then put a comment in that something like Nothing to Report.

On the On_Load() Event procedure of the sub-report write a routine to check the no-data condition, if so, change the Record Source of the sub-report to the temporary table.

This may not work in a multi-page report.