Using this example...

FieldCodeCommand
  AllFieldCodes
  310
  320
  330
  340
  350
  360
  370
  390

RecordTable
  FieldCode      Actual     Budget
  310              10         15
  320              10         15
  330              10         15
  340              10         15
  350              10         15
  360              10         15
  390              10         15

 

I put the table (from UDL file retrieval) and command (OLE DB Connection to SQL table) in my report and linked the field "AllFieldCodes" from FieldCodeCommand to the field "FieldCode" from RecordTable with a left outer join from the FieldCodeCommand.  I made the field "AllFieldCodes" the group for the report.  My report should have 8 groups, one for each FieldCode in the FieldCodeCommand, but the only groups that display have detail records.  The groups without detail records, which should print header and footer sections, do not display at all. 

 

Is there any way to get the report to display the header and footer information for the fieldcodes in the FieldCodeCommand regardless of detail information from the RecordTable?

 

Thanks in advance for any input.