Formatting a table whose columns cover more than 1 page

[John]

Hallo Support,

if I have a table with a large number of columns, more than fit on 1 page, how can I set this up so that the following happens:

• - the columns that don't fit on the first page are automatically moved and rendered when all rows for the first page are finished
  - a "fixed" column can appear at the left on each page
  - for each row, the row height is the same - i.e. row 1 for the columns on the first page would be the same height as row 1 for the remaining columns

There used to be a "collate" function for a page but this seems to have disappeared. I tried SegmentsPerWidth / Height but got very strange results.
I also tried with both a databand and a table, as in the attached MRT.

Thanks in advance.

John Kitching

[HighAley]

Hello, John.

the columns that don't fit on the first page are automatically moved and rendered when all rows for the first page are finished

You should move text components on the second page in designer.

Img1.png (23.01 KiB) Viewed 2728 times

a "fixed" column can appear at the left on each page

What do you mean under fixed column? If the first column should repeat on second page, you should

for each row, the row height is the same - i.e. row 1 for the columns on the first page would be the same height as row 1 for the remaining columns

The height of one row on different pages is the same.

There used to be a "collate" function for a page but this seems to have disappeared. I tried SegmentsPerWidth / Height but got very strange results.
I also tried with both a databand and a table, as in the attached MRT.

You could find Collation property in the properties of the report.

Thank you.

[John]

Hello,

thanks very much. It's working now. One last question - is it possible to get all rows to print first before moving to the next set of columns? At the moment my report displays the first 3 rows for all columns before moving on to the next few rows (see attachment).

Thanks and regards,

John Kitching

[HighAley]

Hello.

This is not typical task, so it needs additional code.
Here is a sample of such code that you could use in End Render event of the report:

Code: Select all

this.RenderedPages = Stimulsoft.Report.Export.StiSegmentPagesDivider.Divide(this.RenderedPages, null);
int CollateCount = 2;
System.Collections.ArrayList list = new System.Collections.ArrayList();
int count = this.RenderedPages.Count;


for (int index = 0; index < CollateCount; index++)
{
	for (int pageIndex = index; pageIndex < count; pageIndex += CollateCount)
    {
    	list.Add(this.RenderedPages[pageIndex]);
	}
}

this.RenderedPages.Clear();
foreach (StiPage page in list)
{
    this.RenderedPages.Add(page);
};

You could add a report variable CollateCount to set Collate property.

Thank you.

[John]

Hello,

that worked great. My template has 3 page segments so I set the collation to 3 and it came out just as I wanted.
Thanks for much for your help.

Regards

John Kitching

[HighAley]

Hello, John.

We are always glad to help you.
Let us know if you need any additional help.

Thank you.

[StixStax]

What do you mean under fixed column? If the first column should repeat on second page, you should [...]

I have the same issue. I would like to repeat the first column (fixed column) on every page that is added horizontally, but i cant figure out what the solution to John problem was. You didnt finish the sentence. Would you be so kind and give some more information?

[Alex K.]

Hello,

Sorry, maybe we did not exactly understand your task. You can place it on each page/segment of your report.

Thank you.