Is this layout possible in RS using a matrix? The user enters in report parameters for the start and finish date (which could be any amount of time). Then how can it get the format of the report to print in the following way. The weeks would need to be Sunday to Saturday and be labeled week 1 week 2 and so on (the spacing is just off on the sample), it would have to extend for the total time of the parameter 1,2,3,4 weeks etc based on parameters.
Agent | Week 1 | | Week 2
Kim 7/1/2005 7/2/2005 7/3/2005 7/4/2005 7/5/2005 7/8/2005 7/9/2005 …
Field1 22 22 22 33 22 11 11
Field2 88 88 55 44 32 32 11
| Week 1 | | Week2
Jack 7/1/2005 7/2/2005 7/3/2005 7/4/2005 7/5/2005 7/8/2005 7/9/2005 …
Field1 22 22 22 33 22 11 11
Field2 88 88 55 44 32 32 11
Any ideas greatly appreciated
Eric
Agent | Week 1 | | Week 2
Kim 7/1/2005 7/2/2005 7/3/2005 7/4/2005 7/5/2005 7/8/2005 7/9/2005 …
Field1 22 22 22 33 22 11 11
Field2 88 88 55 44 32 32 11
| Week 1 | | Week2
Jack 7/1/2005 7/2/2005 7/3/2005 7/4/2005 7/5/2005 7/8/2005 7/9/2005 …
Field1 22 22 22 33 22 11 11
Field2 88 88 55 44 32 32 11
Any ideas greatly appreciated
Eric