Problem Creating Weekly List. PLEASE HELP.

[Nestor]

I have a list of 99 records, and they all have different Dates for the next 3 weeks. What i want to create is a report that will show me this week in 1 page, next week in another page, and the 3rd week in the last page. I have the following Fields.

Customer

Item Number

Qty

Print Date

I want to be able to create this report so i can see what customers are printing this week, and so on. This is driving me nuts.

Thanks in advance.

[comment]

First, you need a calculation field to return a common value for all records in the same week, for example, cWeek =

Print Date - DayOfWeek ( Print Date )

In your layout, create a sub-summary part when sorted by cWeek, and set it to start a new page.

[Nestor]

Thanks That did the trick... Do you know if i can have 2 subsummaries in the same page. So for example have the subsummary for Print Date, and then have another subsummary for customer. The result being 1 page with everything for that week for 2 or 3 customers but have the custumers spaced out so they're not next to each other.

Thanks

[comment]

Certainly. You can nest as many sub-summary parts as you need. You just need to put them in the correct order, and make sure your script matches that order when sorting the records. For example, your layout could have:

Header

Sub-summary by week (leading)

Sub-summary by customer (leading)

Body

Sub-summary by customer (trailing)

Sub-summary by week (trailing)

Footer

and the sort order would need to be: week, customer.

Note that for each group, you can have a leading and/or a trailing sub-summary.