supress a detail row of data

[g33kgrrl]

Hi -

I have a row of detail data that has 5 fields of data. I want to not repeat the row if fields 1-4 are identical. Should I use the 'previous' and check each field in a nested if? And then, if they are all identical- supress the row?

There is probably a VERY easy solution which I am just not seeing...

Thanks in advance!!

 

[lbass]

Create a formula {@concat}:

{table.field1}+{table.field2}+totext({table.number})+totext({table.date})

Then use a formula like this for suppression:

{@concat} = previous({@concat})

You don't have to place {@concat} in the report.

-LB

 

[MikeCopeland]

Then use a formula like this for suppression:

{@concat} = previous({@concat})

You don't have to place {@concat} in the report.

I don't understand _how_ to use a formula like this - what does this do, and how does it fit into the report processing. (BTW, I'm not the OP, but this seems like a valuable tool, and I would like to know how to use it...)

 

[lbass]

You would create the formula {@concat} in the field explorer->formula->new and then go to the section expert->details->and enter the formula there:

{@concat} = previous({@concat})

This tests whether the row contains the same instances of the four fields as the previous row, and if it does, it suppresses the whole row.

-LB