Creating reports and dashboards | Stimulsoft community forum

I am quite new to Stimulsoft and i'm having trouble grouping pages together by data criteria.

I have 5 seperate pages each with their own group header. Each also has a data header. When the report compiles I have 3 pages of page 1, 3 pages of page 2, 3 pages of page 3 etc. etc.

I'm looking to group the pages together so that i have page 1,2,3,4,5 and then page 1,2,3,4,5 when the next data criteria. Can anyone point me in the correct direction?

Many thanks.

Hello,

Sorry i'm not fully understand your request. Please explain it in more details. Also attach your report to this topic.

Thank you.

I'm looking to create a 5 page report. What is currently happening is that all the page 1's are printed. Then the page 2's etc. etc.
So you get:

1,1,1
2,2,2
3,3,3
4,4,4
5,5,5

I've tried the collate function but get very random ordering?

Setting the collate property to 3 solved the issue.

Can i ask why this figure is 3?? Or can someone point to the documentation that details this property and how it works?

Many thanks.

Hello,

The Collate property determines the number of pages in the group.

Thank you.

This relies on the data count being 3 very time the report is run which is not the case. So therefore i can only assume the collate integer needs to relate to the amount of records returned - should therefore this collate property be set to generate dynamically?

Update: I've currently solved this by assigning the collate property to the count of the datasource on the page render event which seems to have worked.

Hello Rob,

rob.collett@sage.com wrote:This relies on the data count being 3 very time the report is run which is not the case. So therefore i can only assume the collate integer needs to relate to the amount of records returned - should therefore this collate property be set to generate dynamically?

Update: I've currently solved this by assigning the collate property to the count of the datasource on the page render event which seems to have worked.

You can do this in any event of report (except EndRenderEvent) because operation of resorting pages in report processed after report rendering operation.

Thank you.

Hi,
Excuse my ignorance but could someone please advise the exact syntax to do the following? I want to assign the number of pages to the collate property. From my testing I have found that the collate property only works if you set it to the number of pages you want to print. For example if you want to print 6 pages (2 printouts in each so you get 12 printed pieces of paper) then you set the collate property to 6 and it works. Any other number gives varying results.

Newbie so exact syntax and where to place it would be appreciated. Make it child-proof...

Hello,

Sorry, maybe we did not exactly understand your question. Could you explain your issue in more details?

Thank you.