suppress using formula 1

[lkh5650]

Hi

I am using formula in crystal reports to evaluate the group within a group

for instance
within group A, there can be group a,b,c
and i wanna evaluate/suppress
if there is group a, discard group b & c
if there is group b, discard group c
if there is only group c, then display group c

right now the group is sorted as a,b,c
can i do that?

i also need it so that it doesn't display the rows (data) under that group that i dont need..

I used select expert in group, and suppressed it but it would only suppress the group title (?) not the records with it..
just like this

previous({CASES.ID})= {CASES.ID} and {@SourceHierarchy} > {@PreviousHiarchy} ;

 

[lkh5650]

Phew

Thank you so much LB I finally got it to work! yay yayaya
thanks!!!!!!!

Btw i was thinking why would it be descending??
it has to be ascending (1,2,3,4.....10) and picking the top 1 should give me the data i want.

thanks!

 

[lbass]

I should have said minimum, then I think ascending order would work.

-LB