Hi
I am currently doing reports for my place of work and need to be able to embed one report into the other, which I have done and have linked the child field and master fields properties.
But what my problem is, is that now that my report is embedded into the main report, that because it has to be placed in the detail section of my main report, it is now not keeping each row in the recordset together in the “detail section” of the main report, as the subreport is now also in the detail section and breaking up my record set to one row, then displaying the subreport, then under that I get the second row of my recordset from the main report and then displays the subreport again under that. Hence is breaking up my recordset in the detail section of my main report. (mind u, that the subreport is displaying correctly and correlating to the correct fields from my main report as I have linked the child and master fields as previously said, so this is not a problem, just keeping all my rows from the recordset in the detail section together)
Is there a way to keep the each row in the recordset together, once the subreport is placed in the detail section (the subreport holds another header and detail section also)? OR is there a way a adding another ‘header and detail’ section under the ‘detail section’ in the main report without having to add a subreport?
I have tried setting the property box to “keep together” to yes which is the default setting anyway and this doesn’t seem to help.
Does anyone have any advice to overcome this problem?
thanks