Crosstab formatting issue with grouped totals and wrapping column text

[ewalcher]

Hi, I'm trying to improve a report that uses the crosstab control using reports.web.

First of all, I have a dataset of stock items that are in departments and commodities with their sales quantity and value.

e.g
Item 1, dept 1, commodity 1, qty 100, value 4050.00
item 2, dept 1, commodity 2, qty 50, value 742.00
item 3, dept 2, commodity 1, qty 12, value 120.00

I'm using a cross tab the control to show sales for multiple periods. (see image). The rows of the cross tab include the department and commodity because I want grouped totals at these levels.

The first problem is the department and commodity take up too much room horizontally which limits the periods I can display as columns.

2019-02-12_09-08-16.png (219.18 KiB) Viewed 999 times

Is it possible to display the grouping as below in the non-cross tab report using grouping panels? ideally, department and commodity will be at the top and the item information would appear directly below.

2019-02-12_09-07-37.png (80.6 KiB) Viewed 999 times

The second problem is the displaying of the period names rotated 90 degrees. As you can see 'Month Ending 28 February 2018' take a lot of vertical space. I need it to wrap - I've tried enabling the wrap property and setting the max width/height but it has no effect. Is this possible?

e.g display as

Month Ending
28 February 2018

[HighAley]

Hello.

Sorry, I don't see your data.
Do you have the fixed amount of columns?
If yes, you don't need to use the Cross-tab.

If no, you could use additional group headers and data bands and show the Cross-tab for each group or master band.
Or you could try to create this report using Cross-bands.

Thank you.