How can I suppress repeated values in a table?

Problem: You don't want to print repeated values in a column within a table

Example:

You are publishing data into a table, something like this:

      Part No.      Size

      1234           1

      1235           1

      1236           1

      1237           2

      1238           2

      1239           2

But what you want is for the repeated values not to appear - for example:

      Part No.      Size

      1234            1

      1235

      1236

      1237            2

      1238

      1239

you can accomplish this by using the Do not include if element data is same as previous option in a Formula. Here's how to do it:

  1. Open the Element that contains the value that you don;t want to repeat, or create a new Element
  2. Select the Formula radio button
  3. Set up the Formula to publish the required data. If it's simply a case of outputting the contents of the field (ie, you don't really need a Formula to publish he data), choose the field name in the IF area, then either Is Not Blank or a similar option, depending on the field type
  4. Make sure the Publish the Field: radio button is selected in the THEN area and select the same field in the popup menu next to the radio button
  5. Select the Do not include if element data is same as previous check box
  6. Go to the OTHERWISE tab
  7. Select the Publish the Field: radio button and select the same field in the popup menu next to the radio button
  8. So, the field will be published no matter what, but it will suppressed if its contents are the same as the previous entry for the same field

Go to CatBase.com