Solved Want detail to not shrink, but it does... (1 Viewer)

[EdFred]

I've searched, I've tried every combo I can think of, so my old brain must be missing something.
(I'm American, so it's all going to be in non-metric)


Pertinent data feeding report: teamID (which has a header and footer in the report - no report header/footer) and then in the detail memberID.

teamID Header height is 0.5625"
teamID Footer height is 0.5"
detail height is 0.3125"
field heights in detail are 0.2188"

There will only ever be a maximum of 3 members per team so the detail will max at a height 0.9375"
I print this report on 8.5" x 11" paper in landscape mode. I have 2 columns set in page setup so I get 8 reports per page at a size of 2" x 5". This is what I want it to stay at even though throughout the year memberID status will change so it no longer needs to appear on a report.

When this happens I want the memberID to not show on the report, but still want the detail area for each team to remain at a height of 0.9375"

I tried setting the detail to 0.9375" and putting a subreport with a height of 0.3125" in the detail area and tried every combination of can shrink/can grow with every field/detail/mainreport/subreport, but I either get massive amounts of white space or it shrinks down smaller than the 2" x 5"

I don't want to send blank fields as placeholders to the because if the entire team status changes I don't want that printed out at all. Blank field place holders prevent that from happening.

What am I missing? Or am I asking the impossible?

 

[DHookom]

Have you tried a subreport of members in the detail section of the main report. Set the height of the subreport control as needed and don’t allow it to shrink or grow. Make sure your main report recordsource does not include members.

 

[EdFred]

Have you tried a subreport of members in the detail section of the main report. Set the height of the subreport control as needed and don’t allow it to shrink or grow. Make sure your main report recordsource does not include members.

That did work - sort of. It kept the height for the detail. Only issue with it is when all three members have a status change, the report still prints. It's completely blank of course other than header and footer. So I do have to add a status change field in the team table, and all will work.

I had done what you suggested except I was using the same query for the main and sub reports. Once I split that into two queries I am now rockin and rollin.

Many thanks!

 

[DHookom]

Using the same record source in a main and subreport is a common occurance.