Spacing Totals in Page Footer Using OEINV01.RPT

[jsh8286]

Have an issue regarding spacing using the above (we have modified it to meet our needs but used is as a base) Crystal specification in the totals section (page footer).

Currently as the spec prints out if there is no discount from the original order the page footer totals come out exactly how we want them to:

Subtotal: 100.00

Taxes: 13.00

Total: 113.00

But let's assume there is a discount we now want it to print like this:

Subtotal: 100.00

Less Disc: 10.00

Subtotal: 90.00

Taxes: 11.70

Total: 101.70

Now we can accommodate for the extra lines no problem but don't want to create a second specification.

So my question. Can we get the best of both worlds as it pertains to spacing. When no discount it prints as shown above in the first example and when there is a discount prints as in the second example.

As it stands right now there are gaps in the spacing of the totals section based on the suppression.

Hope this makes sense.

Thanks in advance for any postings.

 

[ettienne]

You could use formulas for each line after subtotal:
if discount = 0 then taxes else discount
if discount = 0 then total else subtotal
if discount = 0 then "" else taxes
if discount = 0 then "" else total

Or suppress the last 2 if discount = 0 since they will only print if there is a discount.
There are different ways to achieve this, this is just one suggestion.

Sage 300 Certified Consultant