[Resolved] Displaying variable in header instead of footer

[BIGGY]

Group 1 in my report puts customer orders together.
Group 2 puts order items together.

Each item has it's own unique Tracking Number. I put together a simple formula that counts the number of tracking numbers. If they are all the same for an order, then I have it display that one tracking number. Otherwise I have it print text saying 'Multiple #s'. Question is...can I get that formula to display in the header at all? If I simply put in a new formula to display the variables, then it shows the tracking number from the section above. Is there any way to get that number to show in the header from the section that's below?

[brucevde]

A formula that contains something like this should work.

If DistinctCount ({[Order Details].ProductID}, {Orders.OrderID}) > 1 Then
  "Multiple Products"
Else
  Cstr({[Order Details].ProductID})

I use the Northwind database : Customers, Orders, Order Details tables.
Group Customers.CompanyName
Group Orders.OrderID
Details - some fields from the Order Details table

Created a formula with the above code and placed it in the Orders Group Header. It printed as expected.

[BIGGY]

That seems to work for me! Thanks much!