"suppress if duplicated" not working

Question

On my current report, I clicked on "format object" and set the "suppress if duplicated" on my store number and name fields.

But the store numbers and store names are NOT suppressing.

Any one know why they might not be suppressed?

In my subreport that has a similar order, the "suppress if duplicated" works.

Answer 1

Hi,

'Suppress If Duplicated'  only applies to individual fields. You might need to sort the records to make the same reords next to each other and check if they are equal using PreviousValue in formula. For more info , please see:
http://www.crystalreportsbook.com/Forum/forum_posts.asp?TID=4821

Harry

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Answer 2

Hi,

'Suppress If Duplicated'  only applies to individual fields. You might need to sort the records to make the same reords next to each other and check if they are equal using PreviousValue in formula. For more info , please see:
http://www.crystalreportsbook.com/Forum/forum_posts.asp?TID=4821

Harry

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

PreviousValue is not valid in a formula and  the link seems to talk about suppressing an entire line not a field.

Answer 3

Hi,

The thread talks about how to suppress a rows by one field.
I'm afraid it's not possible to suppress two fields , it seems the adjacent records will be suppressed.

Harry

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Answer 4

Sample report:

State Total For AL    PTD     Direct Ship        $4,686.04         $2,323.16      101.71  

State Total For AL    PTD     Stock                 $608.48            $521.99       16.57  

                                                                                            $5,294.52                     $2,845.15              86.09  

 

State Total For AL    YTD     Direct Ship      $75,186.82      $127,496.17      -41.03

State Total For AL    YTD     Relay                     $0.00        $7,123.07      -100.00

State Total For AL    YTD     Stock             $23,837.44      $16,593.85         43.65  

                                                                                          $99,024.26               $151,213.09                 -34.51  

 

I should be able to format the state total and YTD fields and click on the “suppress if duplicated” and it should look like below.

 

State Total For AL    PTD     Direct Ship        $4,686.04         $2,323.16      101.71  

                                                   Stock                 $608.48            $521.99        16.57  

                                                                                            $5,294.52                      $2,845.15                86.09  

 

State Total For AL    YTD     Direct Ship     $75,186.82        $127,496.17      -41.03

                                                   Relay                    $0.00           $7,123.07     -100.00

                                                   Stock            $23,837.44         $16,593.85        43.65  

                                                                                        $99,024.26                    $151,213.09               -34.51  

 

But it remains showing the duplicate fields like the sample report.