using a subreport

[dxqwest]

I developed a form with a subform with both having its own table and I am wanting to create a report that reflex information off the main form and subform by have a report with a subreport. The main report is based off one query and the subreport off another query. I have it working to the point that it is showing all the information I want but it creates a page for each record that is contained in the subform table. Is there any way that I can control the amount of pages I want the report to show?

[This message has been edited by dxqwest (edited 01-18-2002).]

 

[David R]

Just a thought...did you check to make sure there's no rogue "Force New Page" properties in your subreport? Bring up the Properties sheet for each Header, Footer, and Detail section (except the Page Header/Footer, obviously), and check the first entry under the Format tab, Force New Page. It should be set to None.

Also make sure your subreport is not wider than your printable page, it could be wrapping around to a new line.

HTH,
David R


[This message has been edited by David R (edited 01-18-2002).]

 

[dxqwest]

I check the subreport properties and it is set to 'None'. The problem is that when a person goes on the form they enter their
information that go on the main table only once but they can enter as many as 1 however many entries needed in the subform which goes to a 2nd table. I have the report set up to pring out to 2 pages(which then could be more to display the records) but because the 2nd table has however many records the report print out repeated pages of the same information.

Is there any way to fix this?

[This message has been edited by dxqwest (edited 01-18-2002).]

[This message has been edited by dxqwest (edited 01-18-2002).]