Subreport in Footer

[scott04]

Hi everyone,
I have a subreport in the report footer section of my report. I am trying
to get the labels for the subreport to show since it contains different
fields than my main report. Any sugguestions? Thanks
Scott

 

[Klatuu]

You have not said what you have tried that has not worked.

 

[scott04]

Oh sorry i havent really tired anything other than i tried setting the group
sorting = 1 Ascending which did not work. The labels for the fields just do
not appear but the data appears correctly.

 

[Klatuu]

Here is how I handle the problem.
I put a caculated field in my subform recordsource query
SELECT 1 AS Grouper, ....

Then in my Sorting an Grouping I select Grouper as the first item and select
Yes on Group Header. Then in the Group Header I select Yes for Repeat
Section. Then I put the headers in the Group Header section for the Grouper
header.

 

[scott04]

Thanks for your help that worked perfectly

Here is how I handle the problem.
I put a caculated field in my subform recordsource query
SELECT 1 AS Grouper, ....

Then in my Sorting an Grouping I select Grouper as the first item and select
Yes on Group Header. Then in the Group Header I select Yes for Repeat
Section. Then I put the headers in the Group Header section for the Grouper
header.