Top of the column value hide when we use the suppress?

[rajrev]

HI,
We are using CR 9.0 and SQL server DB.

I put the required field in the Detail section. At the time of running I saw couple of records are douplicated.
Then I suppress the detail section by using the following formula (in the Selection Expert... suppress -formula)
@EmpName = previous(@EmpName)
Now it suppress all the douplicates, but it also suppress the very first record too.
Any comments / suggesion Please let me know.

Note: at present I solved using the groupby empname... but here also another one problem. They need to sort by different field, here becuase of using the empname in the group by - it automaticaly became a main sort field.

If I am not clear pl. let me know.
Thanks
MK

 

[lbass]

In the section expert, uncheck "Suppress," but leave your formula in the x+2 formula area. When the formula does not execute, CR defaults to the check/uncheck setting. In the case of the first record, there is no previous record, so the formula does not execute. If you have "suppress" checked, the first record is then suppressed.

-LB

 

[rajrev]

Great..Thanks a lot.

Thanks
MK