How to suppress print of duplicate values?

[rsctac]

Using OpenOffice 3.3.0 under Windows 7. Using Base wizard to create a report. Is there any way to suppress the printing of consecutive identical values in a column? Thanks

[Villeroy]

Group by that field so it prints once on top of its group.

[rudolfo]

I think rsctac is rather looking for something like

Code: Select all

   CATEGORY  Start    Seconds  In
-----------  -------- ------- ---
          1  19:00:05       7   4
             19:00:35      20   8
             19:30:05       7   7
             19:35:35       2   6
          2  19:00:05       1   4
             19:00:35       2   8

instead of

Code: Select all

   CATEGORY  Start    Seconds  In
-----------  -------- ------- ---
          1  19:00:05       7   4
          1  19:00:35      20   8
          1  19:30:05       7   7
          1  19:35:35       2   6
          2  19:00:05       1   4
          2  19:00:35       2   8

Still interested in the detailed values of the non category columns, while aggregation with group by would hide this. But this way it is easier to spot the point where the category changes from 1 to 2.
ORACLE's SQL*Plus tool has this feature and calls it "break on columns". But I am not aware if it is in any other reporting tool ...

[rsctac]

Yes, that's exactly what I want to do. However, would like to do it within the BASE report (generated by wizard). Anyone know how to do it that way? Thanks

[Villeroy]

Use Calc's data pilot as report engine with option Identify categories".
menu:Data>Data Pilot>Start
[X] From registered data source ...
Column fields: CATEGORY, Start
Data fields: Seconds, In
[More Options]
"Identify Categories"

[rsctac]

Thanks - I tried the CALC DataPilot; it automatically suppresses the duplicate values. However, I haven't found how to get it to allow a few more columns of data; am I missing something?

[Villeroy]

Drag the columns you would list in a GROUP BY clause into the row fields section.
Drag the columns you would aggregate by some function SUM, COUNT, AVG, MIN, MAY into the data fields section.
Column fields are the same as row fields but with horizontal orientation.
Page fields are filters.
The current maximum of fields is 8 in total. This will limit will be overcome in version 3.4.