Only show Header with a Detail Record (1 Viewer)

dgreen

Member
Local time
Today, 17:18
Joined
Sep 30, 2018
Messages
396
What would be the setting to start showing the subform values only if you can include the 1st row of data?
I don't want the subform report header and header to show up on the bottom of the page if they can't include the 1st detail record.

See what's happening now (top part of picture) and what I'm trying to do (bottom)
Picture1.png
 

zeroaccess

Active member
Local time
Today, 17:18
Joined
Jan 30, 2020
Messages
586
Can you show us a screenshot of your report in design view? Hard to tell what's what.
 

dgreen

Member
Local time
Today, 17:18
Joined
Sep 30, 2018
Messages
396
Capture.PNG
 

Bullschmidt

Freelance DB Developer
Local time
Today, 17:18
Joined
May 9, 2019
Messages
40
What would be the setting to start showing the subform values only if you can include the 1st row of data?
I don't want the subform report header and header to show up on the bottom of the page if they can't include the 1st detail record.
I wonder if it would help if you set the Detail Section's KeepTogether property to be Yes...
 

dgreen

Member
Local time
Today, 17:18
Joined
Sep 30, 2018
Messages
396
Still stuck. All of the Header and Detail group's KeepTogether are set to Yes.

I also tried changing the Grouping section to "keep header and first record together on one page" but that didn't work.

1584230035144.png

Here is where the "r_Key_Action_Items" fits as a sub report on the Summary report (red bracket).
1584232087139.png

I wonder if it would help if you set the Detail Section's KeepTogether property to be Yes...
 

Attachments

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom