Whole Page Per Item Not Per Order - Microsoft Access Expert 9


	Back to Access Expert 9 Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Whole Page Per Item Not Per Order

Roger Palmer

11 months ago

I don't know if I missed a step or what, I have gone back over this a few times, and when I build the outer report with the customer info in the details section, I am getting one page per item in the order, and every page is identical, with the header as well as the inner report.

	Sami Shamma @Reply 11 months ago
In the form property, make sure the format is continuous, not single form.

	Roger Palmer OP @Reply 11 months ago
Sami I dont see an option for "single form" or "continuous form" on the report's properties

	Sami Shamma @Reply 11 months ago
My bad. I assumed that this was a form not a report. Can you please show the report in design view?

	Roger Palmer OP @Reply 11 months ago

	Roger Palmer OP @Reply 11 months ago
I had to rebuild the report as I messed up the first version trying to fix things, and it is doing the same thing. Note that there are 19 parts in the order, and there are 19 identical pages in the report.

	Sami Shamma @Reply 11 months ago
Please show it in design view.

	Roger Palmer OP @Reply 11 months ago

	Sami Shamma @Reply 11 months ago
In the same design form, click one time on the subform, and please show me the data tab.

	Roger Palmer OP @Reply 11 months ago

	Kevin Robertson @Reply 11 months ago
I would add a Grouping Leve (QuoteID) and put all the data relating to the quote as a whole in that section. Then your line items can go in the Detail section of the Report. There should be no need for a Subreport in this instance. Grouping

	Roger Palmer OP @Reply 11 months ago
Kevin just fyi, this is just the first step, the final goal is to have 8 subreports total (ill post an image). Ill check out the grouping link you sent and see if i can make that work instead. thank you

	Roger Palmer OP @Reply 11 months ago

	Kevin Robertson @Reply 11 months ago
OK. Now I understand. The screenshot below if a Report from one of my databases which contains 3 subreports (numbered). Notice how I set this up. I have a grouping level (ProjectID) for details about the project. All 3 subreports are also in this section.

	Kevin Robertson @Reply 11 months ago

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Expert 9.

Next Unseen

New Feature: Comment Live View