I have a report with a query that looks like this:
mbr# macro result micro microresult
1 -1 Positive 0 Null
1 0 Null -1 Neg
My report is grouped by mbr# I want them all on one line, but because there are NULLS in result field. I get a blank if I put txtresult in grouping line and I get the following if I put in detail line:
mbrgrouping
mbr# Macro Macroresult Micro result
1 -1 -1
Detail
Null
Positive
I want the Positive next to the -1 macro in grouping line. Any help is much appreciated.
Thanks
kim
mbr# macro result micro microresult
1 -1 Positive 0 Null
1 0 Null -1 Neg
My report is grouped by mbr# I want them all on one line, but because there are NULLS in result field. I get a blank if I put txtresult in grouping line and I get the following if I put in detail line:
mbrgrouping
mbr# Macro Macroresult Micro result
1 -1 -1
Detail
Null
Positive
I want the Positive next to the -1 macro in grouping line. Any help is much appreciated.
Thanks
kim