I am trying to add a dynamic page break feature to a report that already has dynamic grouping, but I am having a problem.
As some background, this report has a parameter for grouping that is used to control the printing of the group header and footer sections which work fine. The original design was not to have page breaks after the group footers.
Now some users have requested an option to allow them to force a page-break after the group footer on demand. This would be controlled by another parameter to indicate whether the report should have a page-break after the group footer or not.
Since the Grouping and Sorting Properties do not seem to allow an expression to control the "Page Break at end" option, I tried to use a new field that was built by the Stored Procedure which prepares the data set. After adding the parameter, when it was selected I put a CHAR(12) -- the old Form Feed ASCII Code -- into a report field in the group footer.
Unfortunately this only printed out an open box character on the report.
Does anyone have a suggestion?
Thank you.
As some background, this report has a parameter for grouping that is used to control the printing of the group header and footer sections which work fine. The original design was not to have page breaks after the group footers.
Now some users have requested an option to allow them to force a page-break after the group footer on demand. This would be controlled by another parameter to indicate whether the report should have a page-break after the group footer or not.
Since the Grouping and Sorting Properties do not seem to allow an expression to control the "Page Break at end" option, I tried to use a new field that was built by the Stored Procedure which prepares the data set. After adding the parameter, when it was selected I put a CHAR(12) -- the old Form Feed ASCII Code -- into a report field in the group footer.
Unfortunately this only printed out an open box character on the report.
Does anyone have a suggestion?
Thank you.