Need help on column layout down then across. (1 Viewer)

[Annali]

Please help me out. My report would be like this

1row 6row 11row 16row <--- 1st page

2row 7row 12row 17row <--- 2nd page

3row 8row 13row 18row <--- 3rd page

4row 9row 14row <--- 4th page

5row 10row 15row <--- 5th page

Above these will be 4 columns but row will distribute according to database. Above example upto 18 rows will print. So it needs 5 pages to print. If I print 22 rows then I need 6 pages. Here column layout is down then across. How can I do this.

 

[G37Sam]

add a dummy field call it (RowOrder) and order your records however way you want them displayed

 

[arnelgp]

see this demo.

 

[Annali]

Thanks for the demo. After adding more data all fields are rearranging and sorting

 

[Annali]

see this demo.

Hi, need help again. wrong results are coming after inserting more rows. My database might have 10,000 or more rows. I am unable to set order option.

 

[arnelgp]

upload your db. how will you set an Order on your current report setup?

 

[Uncle Gizmo]

I blogged about "weaving records" on a report here:-

Reports Weaving Records - Nifty Access

Report Tips In this video I demonstrate how you can set up a two column report and have the records Weave to and fro across the Report. Open the report in "print preview" then select "page setup", "columbs", then select the column layout you prefer. Multi Column Report - Weaving Records Multi...

www.niftyaccess.com

 

[Annali]

upload your db. how will you set an Order on your current report setup?

Hi, please find the attached. Here I modified little on the report. Each page carry 5 rows. In report Sl no TAC0000001, TAC0000002, TAC0000003, TAC0000004, TAC0000005 on first page. But my requirement is Sl no TAC0000001 on 1st row at 1st page, Sl no. TAC0000002 1st row at 2nd page, Sl no. TAC0000003 1st row at 3rd page... After calculating total rows Sl no.??(dont know which Sl no will come) 2nd rows at 1st page will put. And so on.

Here number of rows will divided by five and distribute accordingly. My target is to reduce paper waste.

 

[arnelgp]

i am attaching an excel file and see if this is correct.
if not add another "sheet" and show the result you want.

 

[Annali]

i am attaching an excel file and see if this is correct.
if not add another "sheet" and show the result you want.

Hi, Thanks for your quick response. This is exactly I wanted.
Total number of rows is not fixed. But number of rows per page is fixed to 5. Again thanks for your effort.

 

[arnelgp]

here i made a tOut table and 3 other related queries.
also add a module2.

see report3.