Collation with more than 1 table

John · Post by **John** » Fri May 13, 2011 1:50 am

Hallo Support,

when I have 1 table in my report which goes over 2 or more pages and set the collation then everything works fine.
Assuming, for example, I have more rows than will fit on one page and the table is spread across 3 pages, I see:

page1 - the first columns in the table and the first rows, filling the page
page2 - the next columns in the table and the first rows
page3 - the final columns in the table and the first rows

now the report moves on to the next rows which fit on one page and shows these for the whole table

Fine so far.
What I would like is to be able to add a 2. table to the report - also spread across more than one page and the report should then firstly completely render the first table as described above and then display the 2. table, also moving across first and then down.

I did some testing but I couldn't get it to work. If I do not set the collation, the first table is indeed displayed first but in a different format - firstly displaying all the rows for page1 before moving on to page two. All other collation settings left me with a report in which both tables were mixed together.

Is there any way in which I can get this to work? If not, are you planning to include collation on a table-basis in the future?

Thanks and best regards,

John Kitching

Post by **Alex K.** » Fri May 13, 2011 8:36 am

Hello,

Please send us your report with sample data for analysis.

Thank you.

John · Post by **John** » Mon May 23, 2011 4:37 am

Hallo Support,

sorry for the delay. In the zip file is the mrt which defines tables spread over several pages and taking data from two data tables. The data and its definition are also included.

Regards,

John Kitching

Post by **Alex K.** » Tue May 24, 2011 7:59 am

Hello,

Sorry, maybe we did not exactly understand your report.
Could you, please send examples or screenshots of the this report how it should look like.

Thank you.

John · Post by **John** » Wed May 25, 2011 2:00 am

Hallo Support,

I have created a MS Word document with screenshots and comments which explains how I'd like to have the report displayed, if it is possible. I've also changed the mrt slightly to make it easier to distinguish between the two tables which are displayed. The data is nothing but test data just for demonstrating this issue. All files are in the attached zip.

I hope I have been able to express the issue clearly.

Best regards,

John Kitching

Post by **Alex K.** » Thu May 26, 2011 2:34 am

Hello,

Sorry, but there is no any simple solution for this problem. We can propose several ways for solving the issue:
1. You can create 2 reports, place the first table in the first report and set the Collate=2, and place the second table in the second report and set the Collate=3.
Render reports separately merge them into one for printing.
2. You can set the SegmentPerWidth property to the required value for each page. It will not look nice in the preview, but the report will be printed as needed.

Thank you.

John · Post by **John** » Fri May 27, 2011 12:46 am

Hallo Aleksey,

SegmentPerWidth sounds interesting. I haven't used it before. Unfortunately, I can't find any documentation on it. Can you please tell me what it does and what I need to set it to for each page.

Thanks and regards,

John Kitching

Post by **Alex K.** » Fri May 27, 2011 8:43 am

Hello,

You can read about the segments in our documentation in topic "3.20. Report with Segmented Pages".

Let us know if you need any additional help.
Thank you.

John · Post by **John** » Mon May 30, 2011 2:59 am

Hallo Aleksey,

I've tried SegmentPerWidth and that works fine. Thanks very much for your help.

Regards,

John Kitching

Post by **Andrew** » Mon May 30, 2011 5:50 am

Thank you for letting us know about the issue solved.