Moving the next record in 4 different places

[Former Member]

Hi gurus,

I have been using this report for a while, printing in multiple columns, basically I divided the page in 4 quadrants record 1 top left, record 2 top right, record 3 bottom left, record 4 bottom right on page 2 the same, record 5 top left and so on, but now I got a request to change the way the records are shown, let say the data base has 100 records they want to see record 1 on top left, record 26 on right left, 51 on bottom left and record 76 on bottom right, basically I need to have 4 different pointers to the data base and move them at the same time, I would really appreciate If anyone have an idea how to achieve this.

Thanks

[Former Member · Accepted solution]

Are you only wanting to show the 4 records mentioned, or do you need to show all 100

[Former Member · Accepted solution]

Yes, I want to show the 100 records, just 1 correction, page 1 will shows records 1, 25, 50 and 75 and page 2 will shows records 2, 26, 51, 76 and so on, in total 25 pages will be print, basically I need to split the file in 4 exact or almost exact pieces, at the end in production they cut the prints in 4 pieces and have them in sequential order when they pile them up, this is just a small sample the real job could be several thousands of pages.

Thanks

[Former Member · Accepted solution]

Well, if you just have a 100 records, you can group by formula.

if {Sheet1_.Record} in [ 1 , 25 , 50 , 75 ] then 1 else

if {Sheet1_.Record} in [ 2 , 26 , 51 , 76 ] then 2 else

if {Sheet1_.Record} in [ 3 , 27 , 52 , 77 ] then 3 else

if {Sheet1_.Record} in [ 4 , 28 , 53 , 78 ] then 4 else

if {Sheet1_.Record} in [ 5 , 29 , 54 , 79 ] then 5 else

if {Sheet1_.Record} in [ 6 , 30 , 55 , 80 ] then 6 else

if {Sheet1_.Record} in [ 7 , 31 , 56 , 81 ] then 7 else

if {Sheet1_.Record} in [ 8 , 32 , 57 , 82 ] then 8 else

if {Sheet1_.Record} in [ 9 , 33 , 58 , 83 ] then 9 else

if {Sheet1_.Record} in [ 10 , 34 , 59 , 84 ] then 10 else

if {Sheet1_.Record} in [ 11 , 35 , 60 , 85 ] then 11 else

if {Sheet1_.Record} in [ 12 , 36 , 61 , 86 ] then 12 else

if {Sheet1_.Record} in [ 13 , 37 , 62 , 87 ] then 13 else

if {Sheet1_.Record} in [ 14 , 38 , 63 , 88 ] then 14 else

if {Sheet1_.Record} in [ 15 , 39 , 64 , 89 ] then 15 else

if {Sheet1_.Record} in [ 16 , 40 , 65 , 90 ] then 16 else

if {Sheet1_.Record} in [ 17 , 41 , 66 , 91 ] then 17 else

if {Sheet1_.Record} in [ 18 , 42 , 67 , 92 ] then 18 else

if {Sheet1_.Record} in [ 19 , 43 , 68 , 93 ] then 19 else

if {Sheet1_.Record} in [ 20 , 44 , 69 , 94 ] then 20 else

if {Sheet1_.Record} in [ 21 , 45 , 70 , 95 ] then 21 else

if {Sheet1_.Record} in [ 22 , 46 , 71 , 96 ] then 22 else

if {Sheet1_.Record} in [ 23 , 47 , 72 , 97 ] then 23 else

if {Sheet1_.Record} in [ 24 , 48 , 73 , 98 ] then 24 else

{Sheet1_.Record}

Add the group, supress, then format your details section, multiple groups, 4 inches wide by however tall, you will end up with

kind of what you are looking for. Of course if you have too many records, you may want to look into using an array to build this. my Sheet1_Record was just a field with the record number in it (primary key field for example)

I know this is not elegant, but... It does work.

[Former Member · Accepted solution]

HI, sorry for my late answer, exactly where in the detail section should I place this code.

Thanks

[Former Member · Accepted solution]

the code is just a formula, you can then group by that formula,

The detail section, will need to be setup for multiple columns.

in CR XI, you right click the details, select section expert, near the bottom, you should see

Format with multiple columns, when you check that, you will see a new tab appear at the top.

(Tab name is Layout) you can select the width, and height, etc... be sure to select format groups

with multiple columns, and select a printing direction of across then down.

Hopefully that will come close to what you need.