Getting rid of Duplicate fields on a Sales Order 1

[straal]

Hi All. I am using CR 7.0. I have an accounting database (simply accounting). I am trying to create custom Sales orders. In the data base I have some options data FIELDS. When I insert any of these fields into the SO I get a duplicate of the last line, but only of the FIELD items here is an example
ITEM # Description FIELD1 FIELD2
1001 pencil cases 12 blue
1200 erasers 6 white
6 white

As you can see the last line of FIELD information is duplicated.
I do not want that last duplicated line. Any help is really appreciated.

Straal

 

[synapsevampire]

Try placing something like the following in the suppress area of the details section:

{field1} = previous({field1})
and
{field2} = previous({field2})

Now if those fields duplicate, it won't show those fields. There are more sophiticated approaches, but that would require a more thorough knowledge of your report.

-k

 

[straal]

I tried out what you suggested. Unfortunately I have some instances where I have legitimate duplicate lines in the middle of the sales order. I only need to get rid of the last line. Is that possible?

Zenon

 

[synapsevampire]

If I understand you correctly, alter it to:

{field1} <> next({field1})
and
{field1} = previous({field1})
and
{field2} <> next({field2})
and
{field2} = previous({field2})

This will only eliminate the last duplicate.

I'd guess that it's more complicated, so you shoudl consider posting example data and expected output.

-k

 

[straal]

Sorry I will try to be more specific
here is the example again

Item# Classification code Weight
9125 3 resin solution 204.10
2000 consumer commodity 16.70
1050 consumer commodity 3.50
1070 consumer commodity 0.50
9515 consumer commodity 22.68
9080 3 resin solution 150.00
9046 3 resin solution 226.80
3 resin solution 226.80

"Classification code" is my FIELD1
"Weight" is my field2
the last line (only fields 1&@2) is a duplicate. I want to try to remove that so that the printout looks like

Item# Classification code Weight
9125 3 resin solution 204.10
2000 consumer commodity 16.70
1050 consumer commodity 3.50
1070 consumer commodity 0.50
9515 consumer commodity 22.68
9080 3 resin solution 150.00
9046 3 resin solution 226.80

I inputed your formula, my printout appeared as:

Item# Classification code Weight
9125 3 resin solution 204.10
2000 consumer commodity 16.70
1050 consumer commodity 3.50
1070 consumer commodity 0.50
9515 22.68
9080 3 resin solution 150.00
9046 3 resin solution 226.80
3 resin solution 226.80

Can this be corrected in any way?

Thank you again
Straal

 

[synapsevampire]

My original formula would eliminate that.

Also it appears that thw Item field is blank or null in those instances, if so, you can use:

insull({table.item})
or
{table.item} = ""

Why would my formula eliminate the consumer commodity anyway?

Preehaps you don't know what the suppression fora section is, right click the details section (not a field) and select format section->X 2 next to suppress and place my formula in there.

-k

 

[straal]

Thanks K, I was suppressing the field not the entire detail section. Also I was using the Supress Blank Section rather then the
Supress (no drill down)
The only formula which worked was the last one you gave me, though I had to change the last line to be

{table.item} = 0

Thanks once again