Crystal Report Show All Detail Section on One Page VB.NET

Question

Currently My Crystal Report use PRS Paper / Computer Form Paper with size 9.5" x 11" (where every 5.5", the paper have a tear line). So i am setup my Paper Size on crystal report to 9.5" x 5.5" and get the layout that i want.

So far this is my layout My Layout

Where my footer is set to print at bottom of page so if the detail section have only 1 row, the detail section keep showing blank space to make it fit the page size.

Is is possible for me to make detail section height dynamically? Because i have seen before a report that have minimum height (same as my layout) but when the detail section get more than 50 row the report height is change dynamically based on Computer Form Paper (9.5" x 11").

The report will fit the footer to the Tear line , so user can tear the report on the tear line. And on the report preview all data only showed in one page, where the page size is changed to 9.5" x ??" (depends on how many rows show on detail section)

Answer 1

You can change the size of page footer so it only allows a certain amount of data on Details.

Check this answer.