Report Layout Problems

[CarlRostron]

I have embedded a sub report within a report.

I have produced a subreport with all the timesheets on a single invoice so they are grouped one under another. However, when I then embed this within my main Invoice Report I get a number of instances of this subreport.

I am finding this very hard to explain so please have a look at the images attached.

Simply, I want the list of timesheets (Bookkeeping and more bookeeping as a list as they are in the subreport). I dont want it to be listed several times in the main report.

I really hope this makes sense.

 

[vbaInet]

I really hope this makes sense.

Not completely but I guess what you're after is you should put the subreport in the Report Footer section of the main report and empty the Link Master/Child Fields properties.

 

[CarlRostron]

Ok I will try this and if it isn't what I want I will try to articulate the problem a little clearer. I found it hard to explain.

Thanks for the advice.

 

[CarlRostron]

Great advice works like a dream although I didn't clear any master / child properties. Nonetheless the footer solution worked and displays and prints now only once as required. Thanks.

 

[vbaInet]

Happy to hear Carl.