Problem with display of manual crosstab calendar

[KayKay]

HELP!
cr9
Sql Server stored procedure
We have a manual cross tab report in which we have conditional formula's for each 7 columns (Sat, sun, mon,etc)
We are retrieving the data from the stored proc correctly but cannot display it properly.
We would like the data in the same week to appear in the same row.
This is what we get:

Sat Sun Mon Tue Wed Thur Fri
Week1Data
Week1Data
Week1Data
Week1Data
Week1Data

We would like to see as follows:
Sat Sun Mon Tue Wed Thur Fri
Week1Data Week1Data Week1Data Week1Data Week1Data

We have tried grouping data different ways. We have tried multiple sections. Underlaying each group and/or section. We have tried suppressing the blank object, sections etc.
Our data has no null fields. We also have the start of week as Saturday, which gives a blank group header between weeks.

Thanks in advance for suggestions %-)

 

[nagornyi]

Create summary fields per each day as maximum of the week's data for a given day. Put those fields into the week footer and suppress week detail.

 

[lbass]

If you are not already doing this, you should be using a formula for the grouping by week that makes Saturday the first day of the week, i.e.:

{table.date}-dayofweek({table.date},crSaturday) + 1

Then you would take Nagornyi's suggestion and insert summaries at the group level and suppress the details.

If you don't have data for every week that you want to show in your calendar, you might also want to take a look at thread149-703505.

-LB