supress if duplicate not working 1

[jazzlover2002]

I'm using CR 8.5.

My report has its detail section supressed and the visible part of the report is in the Group Footer #1 (Group header #1 is also supressed). The grouping is based on a formula called @groupsection. That formula is in the details section and it looks like this:

{species.name}+{grade.name}+ToText({@logprice})

When the report is displayed it looks as follows:

Species Grade Length Range Piece Count Total Cost
-----------------------------------------------------------
Cedar #3 Sawmill 38 to 40 58 $XXX,XXX.XX
Cedar #3 Sawmill 31 to 37 47 $XXX,XXX.XX
Cedar #3 Wormy 31 to 32 33 $XXX,XXX.XX
Cedar #3 Wormy 19 to 24 22 $XXX,XXX.XX
Util #3 Sawmill 36 to 37 30 $XXX,XXX.XX
Util #3 Sawmill 34 to 36 16 $XXX,XXX.XX
Util #4 Sawmill 12 to 17 25 $XXX,XXX.XX
Other #3 Sawmill 19 to 24 18 $XXX,XXX.XX
Other #3 Sawmill 12 to 17 20 $XXX,XXX.XX
Other #4 Sawmill Under 12 19 $XXX,XXX.XX

I want it to look like this:

Species Grade Length Range Piece Count Total Cost
-----------------------------------------------------------
Cedar #3 Sawmill 38 to 40 58 $XXX,XXX.XX
31 to 37 47 $XXX,XXX.XX
Cedar #3 Wormy 31 to 32 33 $XXX,XXX.XX
19 to 24 22 $XXX,XXX.XX
Util #3 Sawmill 36 to 37 30 $XXX,XXX.XX
34 to 36 16 $XXX,XXX.XX
Util #4 Sawmill 12 to 17 25 $XXX,XXX.XX
Other #3 Sawmill 19 to 24 18 $XXX,XXX.XX
12 to 17 20 $XXX,XXX.XX
Other #4 Sawmill Under 12 19 $XXX,XXX.XX

I have attempted to check the suppress if duplicate box on the species and group fields, but that doesn't work.

Any ideas?

Thanks

Dave

 

[darwin101]

try adding another group (wormy/sawmill)

 

[lbass]

If your formula is in the detail section, what happened to the "ToText({@logprice})" part of the formula? It looks like "Cedar" = "Species" and "#3 Sawmill" = Grade, but where it the rest? And what is in {@logprice}?

-LB

 

[jazzlover2002]

Thanks for posting.

To answer your question {@logprice} is a formula that calculates out the cost of the log and ends up in the Total Cost column.

Just this morning I did a work around. I created two more groups one for species and one for grade. I was able to use {species.name} = Previous({species.name}) to suppress duplicates of the species and {grade.name} = Previous({grade.name}) to suppress duplicate grade names successfully.

The names show up on different lines, but it doesn't really affect the readability of the report. My client was happy with that so I'm moving on, because there are more important things to do with this program.

Thanks for your questions, though. I appreciate your attempt to clarify things.

Dave