Hello everyone,

I have a report with two linked tables, thus two body, one for master
information and the other one for details data. I'm trying, without success,
to have the master header printed only once per page, on the top of the page
and the detail body header to print every time there's is a detail group:

master header col1 col2 col3
master record Z data1 data2 data3

detail header col1 col2
detail record a data1 data2
detail record b data1 data2

master record Y data1 data2 data3 <== the master header is not repeated
detail header col1 col2 <== yes I want the detail group header to
show
detail record a data1 data2
detail record b data1 data2

etc.

However as soon as the master group header is deactivated (NoOfHeadingLines
mode=fixed,0 lines), no subsequent detail body group will print its header
section. I tried programmatically to switch the NoOfHeadingLines of the
master body group when needed, without success. It seems that by design for
reports having two related body group, if the header section of the master
body is deactivated, the detail group header will be as well... after the
first time it is printed (basically, it works but only once!).

Anyone knows a workaround?

Regards,

In case someone else looks for a solution:

I solved it by leaving all body sections NoOfHeadingLines active. I switch
the ShowLabel property of all the main body columns to true or false
depending on whether I'm printing the page header (true) or not (false).
This did the trick for me.

"arkadia" wrote:

> Hello everyone,
>
> I have a report with two linked tables, thus two body, one for master
> information and the other one for details data. I'm trying, without success,
> to have the master header printed only once per page, on the top of the page
> and the detail body header to print every time there's is a detail group:
>
> master header col1 col2 col3
> master record Z data1 data2 data3
>
> detail header col1 col2
> detail record a data1 data2
> detail record b data1 data2
>
> master record Y data1 data2 data3 <== the master header is not repeated
> detail header col1 col2 <== yes I want the detail group header to
> show
> detail record a data1 data2
> detail record b data1 data2
>
> etc.
>
> However as soon as the master group header is deactivated (NoOfHeadingLines
> mode=fixed,0 lines), no subsequent detail body group will print its header
> section. I tried programmatically to switch the NoOfHeadingLines of the
> master body group when needed, without success. It seems that by design for
> reports having two related body group, if the header section of the master
> body is deactivated, the detail group header will be as well... after the
> first time it is printed (basically, it works but only once!).
>
> Anyone knows a workaround?
>
> Regards,
>

Hi Arkadia,

before switch all showlabel on or off, try this:

in your pageheader set the body - NoOfHeadingLines to 1, call
body.executeColumnHeadings
and set the body - NoOfHeadingLines to 0

SebDra

"arkadia" <arkadia@discussions.microsoft.com> wrote in message
news:2D5EB6A3-20A5-4E6D-8AB3-E331142AD5CD@microsoft.com...
> In case someone else looks for a solution:
>
> I solved it by leaving all body sections NoOfHeadingLines active. I switch
> the ShowLabel property of all the main body columns to true or false
> depending on whether I'm printing the page header (true) or not (false).
> This did the trick for me.
>
> "arkadia" wrote:
>
>> Hello everyone,
>>
>> I have a report with two linked tables, thus two body, one for master
>> information and the other one for details data. I'm trying, without
>> success,
>> to have the master header printed only once per page, on the top of the
>> page
>> and the detail body header to print every time there's is a detail group:
>>
>> master header col1 col2 col3
>> master record Z data1 data2 data3
>>
>> detail header col1 col2
>> detail record a data1 data2
>> detail record b data1 data2
>>
>> master record Y data1 data2 data3 <== the master header is not
>> repeated
>> detail header col1 col2 <== yes I want the detail group header
>> to
>> show
>> detail record a data1 data2
>> detail record b data1 data2
>>
>> etc.
>>
>> However as soon as the master group header is deactivated
>> (NoOfHeadingLines
>> mode=fixed,0 lines), no subsequent detail body group will print its
>> header
>> section. I tried programmatically to switch the NoOfHeadingLines of the
>> master body group when needed, without success. It seems that by design
>> for
>> reports having two related body group, if the header section of the
>> master
>> body is deactivated, the detail group header will be as well... after the
>> first time it is printed (basically, it works but only once!).
>>
>> Anyone knows a workaround?
>>
>> Regards,
>>