Print a Column Horizontally

[lszuma]

Is there a way to format a column with multiple rows containing names, to print the names horizontally rather than vertically on a report?

 

[Pat Hartman]

You can create a subreport with columns or you can use this technique:
http://support.microsoft.com/default.aspx?scid=kb;en-us;141624

 

[giovi2002]

There might be an easier way:
In the report editor use insert>microsoft office pivot table 11

Then you'll be having a real matrix!! All you need to do next is apply formatting to have the matrix look good at the report.

I've been using it in an adp file (access project) on a sql server database.
The object has a big range of properties you can set, you are even able to type a specific query within the matrix.
In this way when you're using multiple matrixes you will be able to use multiple datasets within one report.

 

[lszuma]

Both options sound interesting. However, a subreport seems the path of least resistence. So long as it does not affect the placement on the report. The student names are currently in the third details section of my report. I have a report and page header, a room header w/details, and a projects header w/details; the student header w/details is the last section of the report. This is my first round about with a subreport so this will be interesting to disect. Thanks.

Although, I have been wanting to explore the uses of a pivot table...!

 

[Keith Nichols]

How do I do this?

There might be an easier way:
In the report editor use insert>microsoft office pivot table 11

Then you'll be having a real matrix!!

Reviving an old thread here:

I would like to insert a pivot table, but I cannot see how/where to do it. Any pointers?

Edit,

A bit of background to clarify what I am attempting to do. I have a fairly simple table with fields for Personnel, Project & Section. I was able to view the table in Pivot Table view and format it to show all personnel assigned (detail) to each project (row) for each section (column).

Having messed around with Crosstab queries, I realize that they are for aggragating (agravating ) and cannot be used to get the result I want.

I attempted to create a single subreport to show the personnel for each section but I couldn't see how to filter the individual text boxes for the relevant section. This leaves me with the Pivot Table option.

I feel this should be relatively straight forward but I am currently stumped.

Edit of Edit :

I have attached the table and query in a smaple database along with a word document showing what I am attempting to do.

Many thnaks for any responses.

 

[Keith Nichols]

Bump

Any hints at all welcome

 

[Pat Hartman]

Pivot tables are aggregates also and would be not updatable.

Create a pivot table and drag it onto a form.

 

[Keith Nichols]

Thanks Pat,

I did create a form in pivot table view which I then inserted into the report. The data was correct but I was unable to control the formatting, remove the '+' and '-' expand/collapse buttons etc.

If I could somehow strip out the pivoted data and drop it into a subreport that I could format normally it would be great, but I suspect this is not possible.

I started another thread http://www.access-programmers.co.uk/forums/showthread.php?t=117650 to see if it was possible to populate my text boxes using SQL, but no response as yet.

In the meantime, I have reverted to using 4 subreports along with the associated queries. Whilst this works fine, the formatting is a little tricky due to the subreports being squashed down to the size of the textbox and it seems clumsy to me to be using 8 database items for something that looks as though it should be simple, although I am finding out it isn't.

Ho Hum.