Crystal XI - Group by two fields 1

[marisam]

I need to Group by both the App and Subset.

APP Subset Ctry Status Status #
APP01 US Grant 966333
APP01 EP Pub 5566
APP01 1 EP Pub 67676
APP01 2 EP Pub 5555
APP02 US Flg 9090
APP02 EP Grant 123545
APP02 GB Pub 54656765
APP02 JP Pub 8778678
APP03 US DES
APP03 1 EP DES

I created a formula {Tableappno}&""&{table.subset} but it only displays app with subsets.
APP01 1 EP Pub 67676
APP01 2 EP Pub 5555
APP03 1 EP DES

I need to display both app numbers with/without subsets.
For example it should display
APP01 EP Pub 5566
APP01 1 EP Pub 67676
APP01 2 EP Pub 5555
APP03 US DES
APP03 1 EP DES

 

[Turkbear]

Hi,
Test for the lack of subsets and act accordingly:
Try
@GroupOnThis

If IsNull({table.subset}) then
 {Tableappno}&"_"
else
{Tableappno}&""&{table.subset}

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[marisam]

Thanks this works.