Include all records.....

[robmason10]

I need to include all entries from a table (data to be held in a GH1) but not all of these entries have an extry in the detail table...thus currently the GH1 is only showing those which DO have a detail entry - sorry for being thick but how do I address this?

 

[gscheepers]

Sounds like a join issue... Do you only have one table from where the information's coming from or is it multiple tables joined together? Gerhard Scheepers

"Great souls have wills; feeble ones only wishes..."

 

[Naith]

Gerhard is right about it being a join issue.

You have the two tables currently being joined with an Equal Join. You want to switch it so that you have a Left Join from the GH table to the Detail table.

All the best with the report,

Naith

 

[lbass]

Hi robmason10,

I interpreted your needs differently--that you need a group header to display information even though there are no related details. It sounds like you already have a left join between the table from which you are drawing your grouped data and the table which contains your detail data, but that when the detail data is null the related group disappears, and you don't want it to.

One way to force the group header to appear would be to create a formula to replace your detail field, which creates a default for the null field, e.g.,

If isnull({detail}) then "N/A" else
{detail} = {detail}

If, instead of the default string, you wanted nothing to appear under the group heading, you could then try suppressing the detail section which contains the formula. I think this would work.

Alternatively, there is a report option which allows you to specify that nulls appear with a default value. I've never used this, and I'm not sure how this works if your field is a string.

-LB