Forum Discussion
Page break in multi column report
Here are a few steps you can take to ensure the page break occurs at the group level:
Check Group Properties in Subreport:
In the subreport, go to the group properties for the "Date" field.
Ensure that the "Page Break at End" option is selected. This should force a page break after each group.
Main Report Subreport Properties:
In the main report, select the subreport and go to its properties.
Make sure the "Keep Together" option is set to "False". This ensures that the subreport does not try to keep all its content together on one page.
Adjust Column Settings:
In the main report, check the column settings. Ensure that the columns are not interfering with the page breaks. Sometimes, having multiple columns can cause unexpected behavior with page breaks.
Subreport Layout:
Ensure that the subreport layout is set to "Tablix" and not "Flow". Tablix layout allows for better control over grouping and page breaks.
Test with a Simple Report:
Create a simple test report with just the subreport and the date grouping. This can help isolate the issue and ensure that the page breaks are working as expected.
Best Regards
Saud Ansari
If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!
Hello saud968
i tried this it didnt work as expected its still breaking at column level instead of page
please find the below links for the files:
https://drive.google.com/drive/folders/1K4vEPkXFsYGUIJ36ZJl2nWAwVmOyqULa?usp=drive_link
Let's try a few more steps to troubleshoot this:
Subreport Page Break Settings:
In the subreport, ensure that the "Page Break" settings are correctly configured. Go to the "Group Properties" for the "Date" field and check both "Page break at start" and "Page break at end".
Main Report Column Settings:In the main report, verify the column settings. Sometimes, the column settings can override the page break settings. Ensure that the "Columns" property is set to "1" if you want the report to break at the page level.
Subreport Placement:Ensure that the subreport is placed in a container that supports page breaks, such as a "Rectangle" or "List". This can help enforce the page break settings.
Report Rendering Format:Check the rendering format of your report. Some formats, like PDF, handle page breaks differently than others. Ensure you are testing the report in the format you intend to use.
Testing with Minimal Data:Try testing with a minimal dataset to see if the issue persists. Sometimes, large datasets can cause unexpected behavior.
Best Regards
Saud Ansari
If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!Hello saud968
I have tried this it works for column value 1
i want it should be in 3 columns since i want report like below.
