Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Layout problem page 1 and page 2

Status
Not open for further replies.

antmoe3

Programmer
Feb 24, 2006
32
US
Version 9. I have a report that currently has 4 columns on an 8.5 x 14 paper. I need to add 2 more columns to this report making a total of 6 columns. I then need to make 3 columns on page 1 of an 8.5 x 14 paper and then the 3 remaining columns on page 2 of an 8.5 x 14 paper. Does anyone know the best way to do this??


CURRENT LATOUT:
Page 1 (8.5 x 14)
col-A col-B col-C col-D

Page 2 (8.5 x 14)
col-A col-B col-C col-D

Page 3 (8.5 x 14)
col-A col-B col-C col-D
================================
NEW LAYOUT:
Page 1 (8.5 x 14)
col-A col-B col-C

Page 2 (8.5 x 14)
col-D col-E col-F

Page 3 (8.5 x 14)
col-A col-B col-C
 
If you mean that you'll have multiple rows per column one way would be to alter the data accordingly, which would mean posting your database type and using advanced SQL operations in a SQl Expression.

If you post that, and example data and expected output it will be simpler to assist you.

-k
 
When you refer to column, do you just mean fields? Or have you formatted one or more fields to display in multiple columns? Or are you using a crosstab? Please also provide a sample of your data.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top