Display Calendar Format report

I have data coming from one table.
This data has data, and items and their quantities to be produced on each day.

I want to show this in a calendar format - Mon Thru Friday. How do I do that using CR9. I tried using Cross-Tab report. But, if there are multiple items to be produced on one day, only one item out of the entire range for the day would show - the report automoatically summarizes.

Please suggest some thing! I am at the last moment of putting this out on the production.

Thanks,
Ankeet.

Can you elaborate more on the report layout. Is it basically a list of items under the proper day heading? For one week at a time or multiple weeks?

If its something like the following

Code:

---

                  Production Report for the week of

Monday        Tuesday      Wednesday    Thursday    Friday
Item A - 75  Item B - 23  Item E - 44  Item H 22    Item F - 10
Item C - 22                                          Item G - 20
Item D - 33

---

Then add a detail sections for each weekday.
Each detail section would contain the Item and Quantity fields underneath the proper heading.
For each detail section write a formula to Suppress the section if the "Date of the record" is not for the section (ie if the date is a Tuesday, suppress all other detail sections).
For each detail section, except for the last one, set the "Underlay following Section" option to true.

brucevde,
Thanks for your reply, you are close. It is exactly as you showed in a description. But then the rows are also grouped by production line number.

So for monday if there are 2 items to be produced by PL101 and 6 by PL102, then the details for monday would be grouped by the production line numbers (display production line numbers as row headers).

Therefore I was trying to use Cross Tab, but cross tab is not a right choice because of its own grouping and summing.

Thanks.