View Full Version : report layout


dgoulston
08-21-2002, 02:22 AM
ok i have a report, i have included a screen dump of it

basically the details layout is as below:

############################
page header
############################
______________________......._____________________ _
|...Time.........|......USERS......|......|...Time .........|......USERS......|
############################
Detail
############################
|...[time].......|......[users].....|......|...[time].......|......[users].....|
############################



as u can see in the dump.
i want it to display this way:
______________________......._____________________ _
|...Time.........|......USERS......|......|...Time .........|......USERS......|
|......1...........|..........12.........|......|. .....6...........|..........10........|
|......2...........|..........14.........|......|. .....7...........|..........21........|
|......3...........|..........13.........|......|. .....8...........|..........13........|
|......4...........|...........6..........|......| ......9...........|..........1..........|
|......5...........|..........22.........|......|. .....0...........|..........18........|


but when i tell page setup to go down then across, it jus makes it 1 long list rather than 2 halves.

how can i get the effect i want? and why does the second colomn of the details move to the right when in preview mode as in the dump.

if u need more info, or want me to send u the report i can do that.

im usin access 2000

thanks in advance
DAL

dgoulston
08-21-2002, 03:27 AM
ok sorted the above except for the last prob
the report is sorted by time and right now it goes:
__________________________......._________________ _________
|...Time.........|......USERS......|......|...Time .........|......USERS......|
|......1...........|..........12.........|......|. .....2...........|..........10........|
|......3...........|..........14.........|......|. .....4...........|..........21........|
|......5...........|..........13.........|......|. .....6...........|..........13........|
|......7...........|...........6..........|......| ......8...........|..........1..........|
|......9...........|..........22.........|......|. .....10.........|..........18........|


and i want it to go:

__________________________......._________________ _________
|...Time.........|......USERS......|......|...Time .........|......USERS......|
|......1...........|..........12.........|......|. .....6...........|..........10........|
|......2...........|..........14.........|......|. .....7...........|..........21........|
|......3...........|..........13.........|......|. .....8...........|..........13........|
|......4...........|...........6..........|......| ......9...........|..........1..........|
|......5...........|..........22.........|......|. ....10...........|..........18........|

in colum layout i can choose to go down then across, but then it jus adds to the first colum and does not split it in 2 e.g.
|...Time.........|......USERS......|......|...Time .........|......USERS......|
|......1...........|..........12.........|
|......2...........|..........14.........|
|......3...........|..........13.........|
|......4...........|..........6...........|
|......5...........|..........22.........|
|......6...........|..........10.........|
etc...

and the second colum is not used. but i want it to put for example times 1-3 in col 1, and 4-6 in col 2, splitin it in half, but goin downwards as it is much tidyier.

thanxs for any help

DAL

dgoulston
08-21-2002, 03:33 AM
forgot to attach the screen dump on how it looks at the mo:

dgoulston
08-21-2002, 08:17 AM
dont worry sorted it, i cant explain how, cause it is thing that will only work on mine but it did. anyone have this prob and need help email me.