Report Formatting

[ASherbuck]

So I have a question about the layout of reports.

I understand that a typical report runs horizontally, 1 row for each record. I suppose as such:

1111111111111111111111111111111
2222222222222222222222222222222
3333333333333333333333333333333
4444444444444444444444444444444
5555555555555555555555555555555


Each number would represent the record, with fields you designate.

Is it possible to set up the report to look something like this:
1234
5678
...

I've played around with grouping but haven't gotten the desire result. Basically the purpose of this is to bring up a report of items with their pictures above their information. It doesn't make sense to me to have a long long report of 1 picture with it's info being a line. I'd rather fit 3 or 4 per row.

 

[gemma-the-husky]

if you have narrow information, set the report to multiple columns in page properties

 

[ASherbuck]

Thanks gemmy you always know exactly what I'm looking for.

 

[ASherbuck]

This worked well for Print Preview mode, but is there anyway to carry this over the Report View?

It's odd to me that Access would do this, when I view in print preview the columns are there, though when I switch to report view it goes back to a single column. Bah!

 

[gemma-the-husky]

odd - preview and report should be the same

i'm not sure, thats definitely the way to get multiple printing columns.

 

[ASherbuck]

This is really driving me nuts.

Effectively I want to reverse the column and rows, relative to a standard access table.

Instead of the report being a table all fancied up where records run horizontally I want them to run vertically.

So instead of:

ItemID ItemName ItemDesc
1 ________Toy_________A Doll
2 ________Toy2________A Doll

it would be
ItemID __________1________ 2
ItemName _______Toy______Toy
ItemDesc _______A Doll_____A Doll


My goal is to use the report as a thumbnail viewer for the items in our inventory. I've got the design finished, pictures work, everything is pretty. It just lists everything in a single column in report view. 1 Long row going down the page, which is pointless. Gemma's advice got it to work in print preview but I need that to carry over to report view for the onclick events I plan to add.

If their is a simpler way of doing this I'm all ears but I'm losing hair on this one.

 

[gemma-the-husky]

are you sure the preview worked - multiple columns wouldnt do what you want - its just for things like phone lists or labels, which you can show 2 up or more, like newspaper columns.

 

[ASherbuck]

Yup, I can PM or post the DB if you want to take a peek.