Display Calendar Format report

[ankeet1]

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.

[brucevde]

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

                  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.

[ankeet1]

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.