report help 1

[kkson]

I need to make a report that has names across the top and book #'s down the side.

There will be no data under the columns it is made to print off and then will be filled out by hand when the person reads the book.

I have a table that lists the books and will go down the left. and if there are more books than the page can hold i already know how to continue that. I can't get the names across the top to continue to the next page when the space runs out, like i can on the column. Using the across and down option on the page setup will not do it correctly. I have tried putting the names in a subreport and can't get it to go.

here is what i am trying to do:

|joe|ed|sam|tom|... (if this fills across, new page)
book# | | | |
456 | | | |
5ty | | | |
...

thanks,

 

[THWatson]

kkson
If you put the names in the Page Header section, they will show on every page.

Tom

 

[kkson]

didnt think of that. will they start a new page when the header is filled across? (don't want to repeat the names unless the left side with the books is filled up and another page is needed.)

 

[kkson]

also the names will change based on what department that you work in. the book #'s will change also.

 

[dhookom]

Do you have a strategy for how you display the different names? Are you using code or a subreport or what to display the names?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[THWatson]

kkson
Duane's question is the important issue to resolve. From your original post, it appeared that the names were consistent.

Tom

 

[kkson]

yes, the top row is in a subreport. (one table has the names associated to departments and the other table has the book# with the departments associated to them. they link on departments.)The names across the top will change depending on the department pick. Of course some departments will have more than others, and will take more room than the paper will fit.

the main report has the book #'s going down the left and the subreport has the names going across. I know how to handle the book#'s when there are more listed that will fit on the page. Its the subreports names when they have to be continued across, should start a new page with the same book#'s going down the side.

A side issue to this, is between the names going across the top will be lines to form a grid. the lines need to be all the way across the top even if the names don't go that far.
I have the subform with one field for the name and line. Right now if i have 6 names in the top there is no issue. It will show the 6 names. However there will be a department that has 30 names and those will not all fit across the top.

Thanks for the help guys!!!!!!!!

 

[dhookom]

There is a crosstab report sample at

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

The Crosstab.mdb has a strategy for filling your first six then next six then next six across group headers.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[kkson]

I tryed the crosstab. but will try again.

thanks

 

[dhookom]

I don't understand what you mean by "I tryed the crosstab". Did you try the method that create an "alias" table that would provide A-F letters for each employee in a department and possibly a level if the number is greater than 6?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[kkson]

I tried the example you gave. but I can't have the columns wrap around and be placed under the previous columns. I need it to make a new page when the columns get filled across the top.

Thanks for all the help.

 

[dhookom]

kkson,
All you should have to do is set a page break in the "level" header.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[kkson]

dhookom,
still couldn't get it to work correctly. Must be me. below is what i am shooting for. the tm down the side and the persons name across the top. like i said the name may fill up the column headings. All the data below will be written in. I tryed using a running sum for the name and it works but the first set has no tech manuals listed. It only will show on the last page.

Thanks,

 

[dhookom]

I don't know how you expected to use "a running sum". My crosstab report sample would break your department's employees into groups/levels. Each level could be set to start on a new page.

I think you need to be able to divide larger departments into groups with a maximum number per group. That is exactly how the crosstab.mdb example works.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[kkson]

okay will try that.
Thanks