Creating reports and dashboards | Stimulsoft community forum

Hi,

I'm trying to recreate and enhance the following report in Stimulsoft. The Racks are basically shelves on an aisle, each shelf is long enough to hold a number of pallets. In the old report it's hardwired to 8 pallets per shelf but I would like to add flexibility in to the program to allow that to be redefined. That means, the column of the table is not set in stone and can change based on location. To achieve this I'm using a cross-tab table inside a panel in the data band. However I have some questions in regards to this.

This is what I have so far: Firstly, how do I set it so the table automatically expand and fill the whole panel? I do have the table stretched to the whole panel in the editor but it doesn't do so when rendered. Secondly I would like it to sort from highest rack (A8 A1) to lowest (A1 A1). It seems that no matter how I set up the sorting in the table my sorting settings is being ignored.

Lastly, how do I add a carton count to the end of the table? As seen in the example at the end of the table, if two locations are occupied, it will print a 2 in the column. I am not able to do this to the table.

I have attached a copy of the report, with the connection string removed as the connection string points to azure sql and has some confidential information.

Kindly advise, thanks.

Hello,

> Firstly, how do I set it so the table automatically expand and fill the whole panel?

You can place your Cross-Tab on the band and set HorizontalAlignment=Width

> Secondly I would like it to sort from highest rack (A8 A1) to lowest (A1 A1). It seems that no matter how I set up the sorting in the table my sorting settings is being ignored.
> Lastly, how do I add a carton count to the end of the table? As seen in the example at the end of the table, if two locations are occupied, it will print a 2 in the column. I am not able to do this to the table.

Please send test data for your report.

Thank you.

Okay. Setting Horizontal Alignment to Width solved the first issue. Thanks.

For the second example I will attach a data dump of my development table.

Hello,

> Secondly I would like it to sort from highest rack (A8 A1) to lowest (A1 A1). It seems that no matter how I set up the sorting in the table my sorting settings is being ignored.

You can set the SortDirection option.

Thank you.

Hi,

I think the second method works too. So thanks. That leaves the last question. Is it possible to generate the total that is to the right of the table?

Hello,

Unfortunately, there is no option to show text values in cells and count them.

You can use Cross-Data instead of the Cross-Tab with the necessary calculations.

Thank you.

Noted. I think I have a workaround for this but this now gives me the incentive to experiment.

Thanks.

Hello,

You are welcome.