Link to home
Start Free TrialLog in
Avatar of Milewskp
MilewskpFlag for Canada

asked on

Headings for a subreport

I have a report with a datasheet view subreport . The subreport can grow. I would like the subreport headings to appear at the top of the subreport when the subreport grows across page boundaries.
ASKER CERTIFIED SOLUTION
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Open the subreport in design view.

Create a new Group for the subreport.  When it asks for the field you want to group by, select "Expression" (probably the last item in the popup).  Then enter "=1" as the expression.

Move this group to the top of the Group/Sort criteria using the Up button (far right side)

Then move your headers into this group section, and set the sections Repeat property = Yes.
Good morning, Jim.  I hate it when that happens (<30 sec diff)

;-)
Always a killer<g>

Jim.
Avatar of Milewskp

ASKER

Thanks Gents, I give that a try.

Jim, where can I find that webinar?
<<Jim, where can I find that webinar? >>

http://www.youtube.com/watch?v=fww9P8MXCR4

Jim.
Thanks Jim.