Reporting Data accross the page.

[Karl]

Hello,

I haven't had a lot of experience creating reports. However I have made a
few reports where I place the title for the column in the page header and
then the actual data field goes in the detail section. This works fine as it
creates nice lists with the data going accross the page from left to right
for each record. However I would like to change it so my titles are along the
left side of the page (rather than the top) and my for each record is shown
accroos the page from left to right. Sorry if this is confusing. Here is a an
example


This is what I have

Nest No. Species # Eggs Egg Color (these are in the page header)
1 Robin 3 Blue (this is in the
detail section)
2 Blue Jay 2 Yellow
3 Mallard 4 White

I want the report to look like this instead

Nest No 1 2 3
Species Robin Blue Jay Mallard
# Eggs 3 2 4
Color Blue Yellow White

Sorry about the confusing question.

Thanks in Advance.

 

[Duane Hookom]

Check out this KB article http://support.microsoft.com/kb/208491/en-us.
ACC2000: How to Show Only Labels in the First Column of a Report

 

[Karl]

Hello,
I tried the example in the article. it worked not bad. I don't really
understand the IF statement though. Do I have to use Me! for my database as
well or is that related to something in the NOrthwind database. Also how do I
get it so it doesn't keep repating the labels in each column. I would only
like them very first column. Is it possible to have the columns different
widths?

Thanks,
Karl

 

[Duane Hookom]

Without reading the KB article (I'm lazy) I believe the columns need to be
the same width and the "Me" is a label that identifies the current form or
report where the code is running. Therefore, don't remove the "Me".