My greatest challenge!

[mark curtis]

Dear all,

I have a report that contains upto 8 subreports in the detail section. I have minimized the sub reports as much as possible. So I have as followsin the detail section:

________________________________subrpt1
________________________________subrpt2
________________________________subrpt3
________________________________subrpt4
________________________________subrpt5

My problem is that subrpt1 may have some data and then subrpt2 to 4 have none and then subrpt5 has data, which causes me two problems.

1) I end up with white sapce between subrpt1 and subrpt5, which makes the report look ugly!

2) How do I make sure a subreport has a least three lines of data to print near the bottom of the page or go on to a new page, so not as to just leave the headings at the page bottom.

Thanks
Mark

 

[Travis]

1. Set the CanShrink Property of the SubReports to "Yes".

2. Look at the "Keep Together" Properties of report sections and the Report.

 

[mark curtis]

Thanks but I have looked into all them things before and they do not do what I want.

My subrpts are set to can shrink!
keep together on subreports dont hold true if the subrpts have headings.

What I need is some way to check each subreport has data and move the reports up to the bottom of the one that has data.

 

[Rich]

Have you tried not display the headings, and using the HasData method to fill text boxes with the Heading text

 

[mark curtis]

I'll try that tommorrow thanks

 

[mark curtis]

Pat,

Thanks oh great one!

One last thing how do I make my subreport print at least 3 rows of detail when near the foot of the page else send it to the next page?