Reputation: 11
I want to suppress the duplicate and display only one value but the previous is only displaying the first record i have first record blank or "null" and the second is not null the previous is displaying the first value.
Upvotes: 0
Views: 3011
Reputation: 11
I Solved my problem using this codes.
PreviousIsNull({@Q3}) or {@Q3} <> Previous({@Q3}) and PreviousIsNull({@E3}) or {@E3} <> Previous({@E3});
Upvotes: 1
Reputation: 7
Select the field you want and select on the properties suppress on duplicate
Upvotes: 0