Supress Repeating Values

[Guest]

I have created a report, but would like to control when values are printed.
I have used the Hide Duplicate Values, but this only works on 1 page of
data. I would like to suppress the printing of values that crosses mulitple
pages. I have a VB script which partially works. It compares the current
values on the page to the previous page and suppresses the printing of the
value if it appears on the previous page. This works great, until the data
crosses multiple pages.

How can I prevent a value from printing after it has initially printed
(first use)?

 

[Guest]

I don't know, but maybe you can try a different approach and base your report

 

[Guest]

The report is based upon a query; however, I don't think using Unique Values
will work.

Example of how I want the data to appear:

Function 1 Activity1 Risk 1
Risk 2
Activity2 Risk 1
Risk 2
Risk 3
Function 2 Activity 1 Risk 1

As you can see...each will be a "unique" record. The Hide Duplicate values
parameter only works on 1 page. I need something to "hide duplicate" values

 

[David PONDA]

Use the last option in Query wizard box (Non-corresponding query)

 

[Guest]

Data collection isn't the problem. It is suppressing repeated values in the
report that I am interested in.

I only want to show a value (which occurs in multiple records) in the detail
section ONCE.