Report goes to 4 pages (3 Viewers)

[Libre]

I have the data formatted the way I want. But It goes to 4 pages although all the data is on Page 1 with the following pages repeating all or part of Page 1.
I'm using a List Box to display the lines of an invoice. The header information (Invoice Number, Customer name etc) is from another table.
It looks ok on page one but how can I limit it to just one page especially if there are only 4-5 lines in the detail section?
Thanks in advance.

 

[DHookom]

If the List Box displays the lines of your invoice, remove the invoice details from the report record source. I expect the record source would be only the Invoice level.

 

[Libre]

If the List Box displays the lines of your invoice, remove the invoice details from the report record source. I expect the record source would be only the Invoice level.

Excellent! Works perfectly. At first I was confused...remove the line details...eh? But of course because they are covered by the list box source, independent of the report source. And it works so thank you very much. Saved me much anxiety - couldn't find a thing about it by googling.

 

[DHookom]

This is a somewhat rare question. Usually the posting person has a subreport for the details rather than a list box which is new to me.

 

[Libre]

This is a somewhat rare question. Usually the posting person has a subreport for the details rather than a list box which is new to me.

I haven't done much with reports. I'm just trying to get the output to be correct and formatted properly. I usually prefer list boxes to sub forms (not sure about sub reports) because they are much tidier with less overhead, take up less space etc, but you can only address one field in a list box directly, so there's that. I did try a subform/subreport but it was only showing 1 line of data.

 

[Gasman]

I usually prefer list boxes to sub forms (not sure about sub reports) because they are much tidier with less overhead, take up less space etc, but you can only address one field in a list box directly,

Where did you get that idea?

 

[Libre]

Where did you get that idea?
View attachment 117067

I don't know what that graphic demonstrates, but I meant that a list box has only one bound column so when you click or doubleclick on a line in a list box you're only addressing that one column, while with a subform you can click on (directly address) any column so it's more useful in that regard. That's been my experience at any rate. One bound column in a list box - it doesn't have to be the first. Thanks again for the useful answer.

 

[Gasman]

It was showing multiple columns, but you are correct, only one field is bound.
However nothing to stop you concatenating the fields with a comma, and then split them by the same. Might not be the best method, but one that exists.
Personally I would use subreports, if 1 to many.

 

[Pat Hartman]

I haven't done much with reports. I'm just trying to get the output to be correct and formatted properly. I usually prefer list boxes to sub forms (not sure about sub reports) because they are much tidier with less overhead, take up less space etc, but you can only address one field in a list box directly, so there's that. I did try a subform/subreport but it was only showing 1 line of data.

listboxes and subforms/subreports are not interchangeable. They are used for very different things.

Check the report carefully to make sure that if the details extend to a second page, the listbox paginates correctly. You may need to revert to a dreaded subreport to get the report to print correctly.

You can format subforms/subreports to be as concise as a listbox pretty easily.