Is new page. 1

[ddfff]

Using cr 8.5.

I have a report and on the report I have a field in the details section that repeats on the page.

I want hide or suppress this field from view unless I move to a NEW page.

Any ideas on how I can create a formula to determine when the report moves to a new page.

 

[lbass]

In CR 8.0, if I go to format field->common->and check "Suppress if duplicated," the duplicates will automatically be suppressed EXCEPT at the top of a new page.

-LB

 

[ddfff]

That works somewhat. The only problem is that the Suppress When Duplicate does not seem to work when the field is in a grouped section, grouped by a field other that the one I want to suppress.

Any idea how I might Suppress Duplicates based on the value of the duplicate field and not the grouping it is displayed in.

Thanks Again.

 

[lbass]

When I group by another field, but sort on the field that I want suppressed if duplicated, the duplicated field that is suppressed on the first page reappears on the second page, BUT if the field is not duplicated, it does not repeat on the top of the second page. Is this the behavior you are seeing?

-LB

 

[ddfff]

This is what I am experiencing...

I have several groupings on the page, 4 to be exact.

If I display field 1 in the section which is grouped by field 1, then the suppress when duplicate works correctly. It a duplicate then it does not show except on new page. This is what I want.

Problem is that I am displaying field 1 in the section that is grouped by field 3. In this case, the suppress if duplicate on field 1 does not seem to work. It displays with every new instance of group 3 -- regardless of new page or not. Does not work even if the report is sorted by the field 1 grouping first.

So any ideas on how to make the following:
Display field one in the grouping for section3. Suppress field 1 when field one is a duplicate value, showing only on new page.



Thanks for the time. It is appreciated.

 

[lbass]

Are you dragging a detail field into a group header? Does the detail field have the same value for every record within that group instance? If not, are you trying to capture the maximum or minimum value of the field?

-LB

 

[ddfff]

I am dragging a detail field onto the group header. That is field 1. Field 3 is the group field.

Although the value in field 3 may change, the value in field 1 may not. This is where the problem is.

The suppress when duplicate does not seem to apply when 3 changes but 1 does not.

 

[lbass]

Are you checking "Repeat Group Header on Each Page" for the group based on field 3? If so, then you just need to right click on field 1 ->format field->common->suppress->x+2 and enter:

Not OnFirstRecord and
Not InRepeatedGroupHeader

-LB

 

[lbass]

If you are not repeating the group header, then create two formulas:

//{@reset} to be placed in the page header:
whileprintingrecords;
numbervar linecnt := 0;

//{@linecnt} to be placed in the group (field3) header:
whileprintingrecords;
numbervar linecnt := linecnt + 1

Then right click on field1 in the group (field3) header->format field->common->suppress->x+2 and enter:

{@linecnt} <> 1

-LB

 

[ddfff]

I think that will work. Thank you again.