Spacing out multiple groups

[blarson0]

Hi! I am having a slight problem with my report. I want each product family to be on it's own page, and each week to have it's own column. So it will look like this:

Page 1
360 Family
Week 1 | Week 2 | Week 3
data | data | data
data | data |
| data

160 Family
Week 1 | Week 2 | Week 3
data | data | data
data | | data
data | |


I can get the families to come up on different pages, using the Force New Page property, but I can't get the weeks to come up on different columns. If I use the New Column property I get:

360 Family
Week 1 | Week 1 | Week 2
| data | data
| data |

and so on, with an empty first column.

I've tried the group together property, but not much success there.

Any suggestions? I would be eternally grateful.

Thanks!

-Brad

 

[scriverb]

I need more information. Describe the table structure that you are using and if your report is bound to a table or to a query. This is important in structuring data going across the page in columns.

Bob Scriver

 

[blarson0]

The report is bound to a table.
The table lists family, date and the info to put in the report. The table is not in any relationships, just a stand-alone table.

any ideas?

Thanks!

-Brad