Sage 100

Using Crystal 2011. Report Header is a formula. Runs fine without a Group. Once I add a group the Header does not show up. The report is using MS Access query linked to Sage via ODBC

What do you mean the Report Header is a formula? Are you formatting it with a formula or you only have a formula in it? What is the formula?

This is my header formula. If {?[Customer# or * for ALL]} = ""*"" then (If {?z_Phase} = ""34"" or {?z_Phase} = ""All"" then ""Donnamax Catalog Printed on "" & CurrentDate else If {?z_Phase} = ""1"" then ""Donnamax Artwork List Printed on "" & CurrentDate else If {?z_Phase} = ""2"" then ""Donnamax Approval Sample List Printed on "" & CurrentDate else If {?z_Phase} = ""3"" then ""Donnamax Items Stocked for Replenishment Printed on "" & CurrentDate else If {?z_Phase} = ""4"" then ""Donnamax Closeout List Printed on "" & CurrentDate ) else ""Prepared exclusively for "" & {Daily_Inventory.CustomerNo} & "" on "" & CurrentDate I just don't understand why it would not display if I add a group. The group happens to be the Product Line Thanks

What's the group you are adding? What table(s)?

Well, the logic seems a little strange to me... I presume this was working before addition of the group. How was the prior working version grouped or sorted?

The group is Product Line. The product Line shows up but the header is blank. If I remove the group the Header is displayed. The table is complex but I don't think that has anything to do with it. I may be wrong. I don't see anything in the Header formula to cause it to disappear when I insert the group.

The report still works fine. But I have to choose do I want it grouped or do I want the Header to display. The customer of course wants both. I'd like to accommodate.

What's the {Daily_Inventory.CustomerNo} field? I'm assuming your parameter is for customer number - specific or ALL. If you have no grouping, the first CustomerNo would show in the header but if you're grouping by product line, that may cause the first customer number to drop off. Not sure why but I've seen it before. You could try changing that to a formula in your formula, e.g. @CustNo (where the formula is simply {Daily_Inventory.CustomerNo}).

When you have no grouping, the formula in the Report Header is going to be based on the first record that appears on the report. In your case, the first record makes sense when plugged into your formula, so you get a result. When you group the data, the formula in the Report Header is going to evaluate the first record of the first group (Product Line). For whatever reason, plugging the values from that record into the formula does not return a valid result. You might try going to Report Options and checking the first two checkboxes regarding NULL values. This may or may not work depending on what's in that first record. If you are trying to get a Heading for each group, move the formula down to the group header. With the formula in the Report Header, you will only get one occurrence of the formula per the entire report.

@ChrisStAmand That did it I just checked the 1st null option, inserted the group and the header is there! Thank you