It's not totally clear to me what text you want to appear in the sub summary header in your report where you currently see "blank".
A general suggestion would be to create a calculation field that returns text that uses and If or Case function to return different text from different fields depending on which fields hold the desired text.
If( isempty (FieldA); FieldC; FieldA)
Is just one possible example.
You'd place this field in your report and use it for sorting (and the subsummary part's "break" field) in place of your current fields.
I see. make the actual field have it. rather than the script. you're the best. thanks!
i think i'm hitting a snag because both fields contain value lists.
is it a Get Function if that's the case?
Formatted to permit users to select multiple values such as a check box field? If so, that can create problems when you sort. Otherwise, I don't see how the value list formats will affect this issue--but keep in mind that I'm not completely clear on exactly what you are trying to do.
Your first solution was the right one.
it worked perfectly. I created a field that is:
If (IsEmpty(Field A) and (Field B="Text"); Field C; Field A)
then i sort by this new field, as opposed to Field A.