Creating reports and dashboards | Stimulsoft community forum

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. 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.
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

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.