how to print multiple pages for period report

[jameslx]

I need to print several pages for period report broken into weeks. There is not enough room on one page to do this. The following is a basic layout of what the report would look like.

department |week1|week2|week3|week4|period1|week5|week6|week7|week8|period2
----------------------------------------------------------------
dept 1
dept 2
dept 3
dept 4
total
dept 5
dept 6
total
etc. etc.etc. to full page
next page would have to contain weeks 9 - 16 and period 3 & 4

and etc.

Presently they are using spread sheets, but need to have the report run weekly and distributed.
Each Department would be a record with 52 weeks of data.
I'm fairly new to Crystal, but there has to be a way to do this.
My last resort would be to use a stored proceedure and extract all the information that nedds to be put on a page and produce 7 records, but I'd rather not do that. Knowing how to print multiple pages for period reports would be invaluable.
Thanks ahead of time
Jameslx

 

[Ngolem]

Why does it have to be orientated that way???


you could have it like this:


Dept 1 Dept 2 ......
week 1
week 2
week 3
week 4 _____ ______
period 1

week 5
week 6
week 7
week 8 _____ ______
period 2

or are there too many deparments? You should be able to pile them into landscape legal if you had too. doing it the way you first showed would require

52 weeks + 13 periods = 65 columns

do you have significatly less the otherway..

other alternatives would be to run the report twice
Orientated this way you could run an acceptable number of dept's (governed by a user input) OR you could group your dept's and then run multiple reports based on the groups

you would group on the department number but sort "as specified " and then create department groupings in say groups of 4 as you seem to do in the example above

it is a different orientation but makes it printable and usable too in that you could give out data for a common group of depts and not the other if the data is sensitive

just thoughts






Jim
JimBroadbent@Hotmail.com

 

[jameslx]

Ngolem:
Unfortuantly there are, including heading and footer 48 lines of department information broken into specifics of service responsibilities. This fills a page up 81/2 by 11 landscape to print 8 weeks and two periods per page. In the past on a different report we used a stored proc that gave us data in one record that filled a page of information and broke to a new page per each record, even doing the totals in a separate record. I'd like to avoid this if possible.
Weeks must fall across the top and department info on the left column. Accounting Departments rarely concede to IS.
I was hoping that Crystal would print an extra page for information beyond the right Margin, but You can't even place information beyond that point.
Any other sugestions are welcome, and I am constantly experimenting with records and print methods as well.

Thanks
Jameslx