Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Passing a boolean from subreport to report

Status
Not open for further replies.

kaarde

Programmer
Jul 29, 2008
5
CA
Hi,

I have a report with a subreport. The subreport is filled with schedules all on the same line (movelayout=false). But when I have two schedules on the same day, I want to print the second schedule under the first one. My code for this works, I've used the Top property on my textboxes. Here's a printscreen of the working report (but with a subreport height doubled) :
The only problem is the subreport height. Because I didn't turn the CanShrink and CanGrow to True, my height is fixed and the records won't show up if I try to move the second schedule.

I would like to pass a boolean from the subreport code to the report code when I detect two schedules on the same day and then change the subreport height. But how ??

If it's impossible, I can turn the CanGrow and Canshrink properties to True and find why not all records show up, but I prefer to keep the height fixed. (Because when these properties are On, not all records show up)

Or do you have another suggestion, feel free to post.

Thank you for your help
 
I may add that the method Me.Parent.Child0.Height is not working from the subreport code, when this line is activated, Run time error 3021 : "No current record" appears.

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top