Reports with huge number of columns (each day of the month)

[Moses76]

I have a report which contains names of various staff which needs to be in rows and then the number of hours for each day of the month they worked- in columns.

I am struggling to get it to work so that the first week can be shown on the first page , second week on second page , third week on third page....so on till 6th week in some months. If the list of agents does not finish on first page itself..need an automatic second page.

Something like this
:banghead:
Page 1
Staff name sun mon tue wed thu fri sat SUM
jack
jill
tim
john

****************************Page break if list of agents is over. If not repeat Staff name sun mon tue wed thu fri sat sun***

on next page

Page 2

Staff name sun mon tue wed thu fri sat SUM
jack
jill
tim
john

****************************Page break if list of agents is over. If not repeat Staff name sun mon tue wed thu fri sat sun***

on next page

Page 3
...
Page 4.

Please please help

 

[CJ_London]

suggest have a subreport control for each week - one subreport for each page.

You only need the one subreport report, used by all the subreport controls and use the linkchild and linkmaster properties of each subreport control to filter for each week

 

[Moses76]

I will try this out and get back to you. Thanks for taking the time to reply to my post.

cheers.

Moses