Manual build table with grouping
Hi, is it possible to group data of TableObject when handling ManualBuild event? I have a table which has many columns (up to 200, the particular number is determined at runtime). I need columns which don't fit into the first page move to the next page. I also have a requirement to group data by several columns (particular columns are determined at runtime).
I set TableObject.Layout = AcrossAndDown and specified several fixed columns. Then I use slightly modified code from documentation (ManualBuild event): https://www.fast-report.com/documentation/U...ectexample6.htm. It works well. But it doesn't set datasource for data band, therefore grouping doesn't work. Code samples which use band's datasource don't allow to print table header only once at the top of the page as far as I can see (examples 1-5). And designer simply crashes when I try to use 2 different TableObject on PageHeaderBand and DataBand with ManualBuild event enabled.
Any suggestion how to make it work?
I set TableObject.Layout = AcrossAndDown and specified several fixed columns. Then I use slightly modified code from documentation (ManualBuild event): https://www.fast-report.com/documentation/U...ectexample6.htm. It works well. But it doesn't set datasource for data band, therefore grouping doesn't work. Code samples which use band's datasource don't allow to print table header only once at the top of the page as far as I can see (examples 1-5). And designer simply crashes when I try to use 2 different TableObject on PageHeaderBand and DataBand with ManualBuild event enabled.
Any suggestion how to make it work?