Unable to resolve report page break issue. (1 Viewer)

soap

Registered User.
Local time
Today, 11:33
Joined
Nov 4, 2018
Messages
25
Good day team,
Please i need help on how to resolve an issue on my report. The report querry is coming from a querry generated from main and subform. The report page fails to break in to another page whenever the data value generated from the subform is more than 10, it rather start numbering 11 and 12 from the top. I have but no solution.
I need a possible VBA script that can create a page break whenever the value is more than 10.
Find below a screen shot of the result that i am getting.

https://snag.gy/tquoWJ.jpg .

Thanks in advance for your assistance.
 

isladogs

MVP / VIP
Local time
Today, 18:33
Joined
Jan 14, 2017
Messages
18,186
The sort order for your Item No field makes no sense

If your Item No field is in fact a text field it should go in order 1,11,12,2,3 ...rather than numerical order

Yours does neither of those. Is there something 'special' that you've done?
 

soap

Registered User.
Local time
Today, 11:33
Joined
Nov 4, 2018
Messages
25
The numbering should be sequential after the 10th value. The report page is expected to break to another page instead of recycling the value to the the top.
this is the design view https://snag.gy/etYKMO.jpg
 

isladogs

MVP / VIP
Local time
Today, 18:33
Joined
Jan 14, 2017
Messages
18,186
Sorry the design view gives no clues.
Is it text or number?

You'll need to check the record source, report grouping and any relevant code
 

soap

Registered User.
Local time
Today, 11:33
Joined
Nov 4, 2018
Messages
25
Sorry the design view gives no clues.
Is it text or number?

You'll need to check the record source, report grouping and any relevant code

It is a number.
 

Cronk

Registered User.
Local time
Tomorrow, 05:33
Joined
Jul 4, 2013
Messages
2,770
The order that data appears on a report is not determined by the query sort. It's necessary to set the order in the report.


You need to go to the bottom of the screen when the report is in design view and add a sort.
 

soap

Registered User.
Local time
Today, 11:33
Joined
Nov 4, 2018
Messages
25
I just discovered that the disorder is coming from my subform value which users enter manually. After the 10th value the the next values starts from the top as seen in the image shared before. How can get this sorted please?
https://snag.gy/wLhOCM.jpg
 

Gasman

Enthusiastic Amateur
Local time
Today, 18:33
Joined
Sep 21, 2011
Messages
14,046
Make [Item No] a numeric field and not text?
 

isladogs

MVP / VIP
Local time
Today, 18:33
Joined
Jan 14, 2017
Messages
18,186
If you look back to my first reply, the values are being sorted 'alphabetically' as text. You need to identify why & sort as numbers
 

soap

Registered User.
Local time
Today, 11:33
Joined
Nov 4, 2018
Messages
25
I have fixed the issue, it was coming from the subform value which was not a number but a text not properly sorted. Thanks everyone
 

Users who are viewing this thread

Top Bottom