×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

How to create value/page break for distinct number of records

How to create value/page break for distinct number of records

How to create value/page break for distinct number of records

(OP)
Is there a way to create a sectional page break based on the results of a formula?
I would like to have a separate page each time the "batch" changes, but am not getting good results.
I have a running total formula that counts the distinct # of sales orders and then assigns a value which I am putting in a formula field called batch

@batch:

if {#Test} = 1 or {#Test} = 2 or {#Test} = 3 or {#Test} = 4 or {#Test} = 5 or {#Test} = 6 or {#Test} = 7 or {#Test} = 8 or {#Test} = 9 or {#Test} = 10 or {#Test} = 11 or {#Test} = 12 then 1
else
if {#Test} = 13 or {#Test} = 14 or {#Test} = 15 or {#Test} = 16 or {#Test} = 17 or {#Test} = 18 or {#Test} = 19 or {#Test} = 20 or {#Test} = 21 or {#Test} = 22 or {#Test} = 23 or {#Test} = 24 then 2
else
if {#Test} = 25 or {#Test} = 26 or {#Test} = 27 or {#Test} = 28 or {#Test} = 29 or {#Test} = 30 or {#Test} = 31 or {#Test} = 32 or {#Test} = 33 or {#Test} = .34 or {#Test} = 35 or {#Test} = 36 then 3
else
if {#Test} = 37 or {#Test} = 38 or {#Test} = 39 or {#Test} = 40 or {#Test} = 41 or {#Test} = 42 or {#Test} = 43 or {#Test} = 44 or {#Test} = 45 or {#Test} = 46 or {#Test} = 47 or {#Test} = 48 then 4
else
if {#Test} = 49 or {#Test} = 50 or {#Test} = 51 or {#Test} = 52 or {#Test} = 53 or {#Test} = 54 or {#Test} = 55 or {#Test} = 56 or {#Test} = 57 or {#Test} = 58 or {#Test} = 59 or {#Test} = 60 then 5
else
if {#Test} = 61 or {#Test} = 62 or {#Test} = 63 or {#Test} = 64 or {#Test} = 65 or {#Test} = 66 or {#Test} = 67 or {#Test} = 68 or {#Test} = 69 or {#Test} = 70 or {#Test} = 71 or {#Test} = 72 then 6
else
if {#Test} = 73 or {#Test} = 74 or {#Test} = 75 or {#Test} = 76 or {#Test} = 77 or {#Test} = 78 or {#Test} = 79 or {#Test} = 80 or {#Test} = 81 or {#Test} = 82 or {#Test} = 83 or {#Test} = 84 then 7
else
if {#Test} = 85 or {#Test} = 86 or {#Test} = 87 or {#Test} = 88 or {#Test} = 89 or {#Test} = 90 or {#Test} = 91 or {#Test} = 92 or {#Test} = 93 or {#Test} = 94 or {#Test} = 95 or {#Test} = 96 then 8
else
if {#Test} = 97 or {#Test} = 98 or {#Test} = 99 or {#Test} = 100 or {#Test} = 101 or {#Test} = 102 or {#Test} = 103 or {#Test} = 104 or {#Test} = 105 or {#Test} = 106 or {#Test} = 107 or {#Test} = 108 then 9
else
if {#Test} = 109 or {#Test} = 110 or {#Test} = 111 or {#Test} = 112 or {#Test} = 113 or {#Test} = 114 or {#Test} = 115 or {#Test} = 116 or {#Test} = 117 or {#Test} = 118 or {#Test} = 119 or {#Test} = 120 then 10
Else
if {#Test} >121 then 11





Any assistance would be greatly appreciated.



RE: How to create value/page break for distinct number of records

Insert a group on sales order ID (you don't have to display this group if you don't want to). Then place the following formula in the group footer:

whileprintingrecords;
numbervar cnt;
cnt := cnt + 1

Then go to the section expert->group footer->new page after->x+2 and enter:

whileprintingrecords;
numbervar cnt;
remainder(cnt,12)=0

-LB

RE: How to create value/page break for distinct number of records

(OP)
Hey LB,
Thanks so much, this got me pretty close but not quite there. I still see batch 2 and batch 3 on 1 page. I am trying to get it to page break by batch number. The orignal post was how to get it into the batches which I got figured out.
I have attached a snipet of the preview page and you can see batch 2 and 3 are still on same page.

Thanks in advance for any advice!

RE: How to create value/page break for distinct number of records

I can’t tell anything from your file about how you implemented my suggestion. All my suggestion does is insert a page break after every 12 unique sales order IDs. Isn’t that what you wanted it? I tested it and it worked here.

If that is what you wanted to do, then you should explain exactly how you implemented my suggestion.

-LB

RE: How to create value/page break for distinct number of records

(OP)
Sorry about that LB.

I will try to be more clear on what I am trying to do....

I created the batch formula that creates the " batch " of 12 unique sales orders and that value is placed in a formula called batch. The batch formula can hold up to 10 unique batch numbers and anything else is placed into an other of batch 11. That is the formula that is in the original post above.

Now what I am trying to get it to do is a page break for each new batch number.

as an example here is sample data for my columns on a single page:
What I am trying to get to is get a page break when the batch # formula changes from 1 to 2, from 2 to 3, etc.

ITEM Quantity Bin Sales Order# Pick # Batch#

1 1 01-l44b 2945 546 1
2 2 02-l44b 2946 546 1
3 1 03-l44b 2947 546 1
4 1 04-l44b 2948 546 1
5 1 05-l44b 2949 546 1
6 1 01-l44b 2950 546 1
7 1 01-l44b 2951 546 1
8 1 01-l44b 2952 546 1
9 1 01-l44b 2953 546 1
10 1 01-l44b 2954 546 1
11 1 01-l44b 2955 546 1
12 1 01-l44b 2956 546 1
13 1 01-l44b 2999 546 2
14 2 02-l44b 2918 546 2
15 1 01-l44b 2911 546 2

RE: How to create value/page break for distinct number of records

I think you are overcomplicating this. You are essentially “batching” every 12 sales order #, which is what my suggestion did. Why not try it instead of your approach?

-LB

RE: How to create value/page break for distinct number of records

(OP)
LOL I do tend to over think things sometimes
I will give that a try

Thanks

RE: How to create value/page break for distinct number of records

(OP)
Is there a way to do this as a distinct count? The sales order's may appear multiple times within a batch, so when I try this it is counting each individual sales order instead of distinct sales order numbers

whileprintingrecords;
numbervar cnt;
cnt := cnt + 1

RE: How to create value/page break for distinct number of records

If you insert a group on sales order ID and then place the formula in the group footer, it will only count once per ID.

-LB

RE: How to create value/page break for distinct number of records

(OP)
worked like a charm, thanks so much!!!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close