X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Group Header Value Not Showing When Printed As Page Header, Access 2016    
post Jun 24 2019, 04:07 AM

Posts: 31
Joined: 10-May 18

I have a report with a group header section that is set to Repeat Section : Yes, so it prints as a page header. The group header is pretty simple - it contains a textbox which is bound the the field we are grouping on (SalesExec) and then labels for the columns of the report where we display the report values.

On the first page of the report the group header prints fine, and the sales exec value is printed OK. On all subsequent pages when the group header is printed at the top, the sales exec value is blank, although all the labels are printed.

When the group changes mid page, that version of the group header prints out fine and does include the Sales Exec field.

Therefore when the group change naturally occurs at a page break position, we don't get the header value of the Sales Exec that the following records relate to!

It seems a bit like an Access "quirk" but I can't seem to find the workaround.
Go to the top of the page
post Jul 1 2019, 07:27 PM

Posts: 35
Joined: 19-June 19
From: Tasmania, Australia

Can post the database ?
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    8th August 2020 - 12:50 AM