Comparing records 1

[loveyoursite]

CRV 10 - I have a report based upon an .xls spreadsheet. The report grouping is by job code. I need to identify differences in pay ranges and title. For example:

Job Code 100 Beg 9.98 Mid 11.17 Max 13.09 Title ABC
Job Code 100 Beg 9.98 Mid 11.17 Max 13.09 Title ABC

Job Code 319 Beg 11.76 Mid 13.78 Max 15.19 Title PQR
Job Code 319 Beg 12.19 Mid 14.54 Max 16.76 Title MNO
=======================
Job Code 100 can be suppressed because both records are identical.
Job Code 319 should not be suppressed because either the beg, mid or max are different and/or the titles are different.

I would appreciate any recommendations on how to do this.

Thanks!

 

[lbass]

Create a formula that concatenates all the fields, like {@concat}:

{table.jobcode} + totext({table.beg},2,"")+totext({table.mid},2,"") + totext({table.max},2,"")

I'm not sure of the datatypes, just guessing--add or remove totext(,2,"") as appropriate.

Then go to the section expert->details->suppress->x+2 and enter:

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

-LB

 

[loveyoursite]

What an excellent idea! I may have done something wrong though because the result was one row showed for all records that were exactly alike (the one's that were suppose to suppress) and both records showed if there were any differences. Do you by any chance know where I might have made a mistake?

 

[lbass]

I misunderstood. Insert a group on job code (you can suppress the group header and footer). Then change the detail suppression formula to:

maximum({@concat},{table.jobcode}) = minimum({@concat},{table.jobcode})

Alternatively, you could use group selection (report->selection formula->GROUP) and enter:

maximum({@concat},{table.jobcode}) <> minimum({@concat},{table.jobcode})

The advantage of group selection is that if you are using running totals for calculations, you will not have to take into account non-group selected records, whereas if you are suppressing records, running totals will have to build in a formula to exclude suppressed records.

If calculations aren't an issue, either method should work.

-LB

 

[loveyoursite]

That worked! Thanks so much.